On Tue, Dec 6, 2011 at 9:49 PM, Dan Kennedy wrote:
> On 12/06/2011 03:28 PM, Max Vlasov wrote:
>
>> Hi,
>> Noticed a strange regression after 3.7.7 (in 3.7.8 and inherited in 3.7.9)
>>
>>
> There is a candidate fix for this in fossil now.
>
>
Dan, thanks
I checked the latest trunk against my unpr
I have variables containing lists of values I'd like to insert into a table one
row at a time. For example: if I have a variable called "road" containing
three items: Miller lane, Pine street, Wilson blvd. How can I insert each of
the road names in separate columns in my table? Something like
On 12/07/2011 12:25 PM, Dan Kennedy wrote:
On 12/07/2011 01:35 AM, Alejandro Martínez wrote:
I'm trying to use sqlite3 as a cache layer for queries on other
database. Actually, replace an existing layer cache which is very
adhoc and propietary (and that sucks), and i'd like to replace it with
so
On 12/07/2011 01:35 AM, Alejandro Martínez wrote:
I'm trying to use sqlite3 as a cache layer for queries on other
database. Actually, replace an existing layer cache which is very
adhoc and propietary (and that sucks), and i'd like to replace it with
something peer reviewed / open source, etc lik
H K wrote:
>
> Is it possible to load these functions with the load_extension function?
>
Please take a look at the SQLiteFunction help topic in the
System.Data.SQLite CHM file,
here:
http://system.data.sqlite.org/index.html/artifact?filename=Doc/SQLite.NET.ch
m&ci=tip
--
Joe Mistachkin
__
yED is nice, but there isn't an automated way of loading a schema into it to
get an ER diagram out, is there?
I thought if you go down that path you were basically stuck drawing your
diagram by hand (using their ER diagram shapes).
-sean
-Original Message-
From: sqlite-users-boun...@sql
On 6 Dec 2011, at 9:58pm, Jos Groot Lipman wrote:
> At some point (idle?) the readers should close the database connection and
> you must make sure any new connection starts to the new database?
Right. One way to do it is to have a table in the database used to point to
the next database. Nor
At some point (idle?) the readers should close the database connection and
you must make sure any new connection starts to the new database?
(just brainstorming)
Jos
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Alejandro Ma
It would be a pretty small ammount of data. Say... 10Mb at most.
How would that be? I mean, the "switching the databases".
It would need to be transparent to the readers. How would they see the new data?
On Tue, Dec 6, 2011 at 5:23 PM, Jos Groot Lipman wrote:
>
> -Original Message-
> Fr
Am Dienstag, den 06.12.2011, 04:45 -0800 schrieb priya786:
> Hello i want to know how to get the database diagram from sqlite.Please tell
> me the solution.Thanks in Advance.
for ER diagrams i.e.
- dia (http://live.gnome.org/Dia, linux and ms)
- yED (http://www.yworks.com/en/products_yed_about.ht
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Alejandro Martínez
Sent: dinsdag 6 december 2011 19:35
To: General Discussion of SQLite Database
Subject: [sqlite] Cache design using sqlite3...
I'm trying to use sqlite3 as a ca
> I like navicat lite generally, though the lite version does not have
> diagramming. Their commercial edition does have this and they have 30 day
> free trials, so I'd probably check that out first and see if it does what you
> need. Mac users seem to universally adore sql editor (Puneet just s
I'm trying to use sqlite3 as a cache layer for queries on other
database. Actually, replace an existing layer cache which is very
adhoc and propietary (and that sucks), and i'd like to replace it with
something peer reviewed / open source, etc like sqlite.
So... I would like to have a process whic
I haven't tried any of the pro options since getting management to buy into
something free is easier than something that isn't.
I like navicat lite generally, though the lite version does not have
diagramming. Their commercial edition does have this and they have 30 day free
trials, so I'd prob
On 12/06/2011 03:28 PM, Max Vlasov wrote:
Hi,
Noticed a strange regression after 3.7.7 (in 3.7.8 and inherited in 3.7.9)
I have a Russian morphology database and different queries working with it.
I narrowed it to the following case and populated with a couple of English
words (just to make sens
Hi Sean,
> That said, having looked at tens of free options and seen the average
> quality, I would strongly recommend paying a few hundred bucks for a
> professional product if I needed this functionality.
Do you have any recommendations on commercial database diagram products?
Thanks,
Malcol
On Dec 6, 2011, at 6:45 AM, priya786 wrote:
> Hello i want to know how to get the database diagram from sqlite.Please tell
> me the solution.
If you are on a Mac, SQL Editor is a very nice product for about $80.
http://www.malcolmhardie.com/sqleditor/
--
Puneet Kishor
_
He wants an ER diagram, not a dump of the tables and contents. I wanted this
too and did some digging.
There are a lot of pay tools that can do this (I think navicat for example does
it). If pay tools are not an option, there are a bunch of things that claim to
work, such as SQLFairy and some v
On 5 Dec 2011, at 6:41pm, Helen Chen wrote:
>I am using Mac OX to run sqlite 3. In sqlite 3 I typed in
> create table test2(code integer);
You hit return key ? You got a prompt back ?
> Then I typed
> .import 'cheps.txt' test 2
You should have typed
.import cheps.txt tes
Yuriy Kaminskiy wrote:
> Yuriy Kaminskiy wrote:
>> Yuriy Kaminskiy wrote:
>>> When WHERE condition is constant, there are no need to evaluate and check
>>> it for
>>> each row. It works, but only partially:
>> ...
>>> [In fact, you can move out out loop not only *whole* constant WHERE, but
>>> al
You're seeing on of my pet peeves...error messages like "cannot open file" or
Microsoft's famous "cannot load dll". Some of us need to know WHY.
So, change all your "cannot open" lines in shell.c to this:
fprintf(stderr, "Error: cannot open \"%s\":%s\n", zFile, strerror(errno));
Then you
Hello everybody,
I have written some additional functions to do some very specific work with
SQLite using the .NET SQLite provider.
The functions are written in VB.net and compiled into a dll file.
Is it possible to load these functions with the load_extension function?
Thank you.
ik
___
Regarding:
>
> Hello i want to know how to get the database diagram from sqlite.Please
> tell
> me the solution.Thanks in Advance.
>
> Quick answer:
The sqlite3 utility, linked from the sqlite.org website, can dump
schema with the
.schema
command. If you need more than this, you will h
Hello Team of SQLite3,
I am using many self-made extension functions and some self-made virtual
table extensions to access files and folders with SQL statements.
This is very effective but I have a problem to duplicate my databases,
which are using them.
When I try to create a copy of my databas
Dear all,
I am using Mac OX to run sqlite 3. In sqlite 3 I typed in
create table test2(code integer);Then I typed
.import 'cheps.txt' test 2 It then give me error message saying that cannot
open "cheps.txt" I also tried without the '' around the file name. The
database,
On Dec 6, 2011, at 1:45 PM, priya786 wrote:
> i want to know
Yes.
> how to get the database diagram from sqlite.
Yes
> Please tell me the solution.
42.
In other news, I prefer mine round:
http://www.visualcomplexity.com/vc/project.cfm?id=42
___
Hello i want to know how to get the database diagram from sqlite.Please tell
me the solution.Thanks in Advance.
--
View this message in context:
http://old.nabble.com/Database-Diagram-tp32923825p32923825.html
Sent from the SQLite mailing list archive at Nabble.com.
_
Hi,
there seems to be an inconsistency for limit checks between zeroblob() and
the rest of code:
sqlite> CREATE TABLE "a" ("c" BLOB);
sqlite> INSERT INTO "a" VALUES (zeroblob(11));
Error: string or blob too big
sqlite> INSERT INTO "a" VALUES (zeroblob(10));
sqlite> SELECT "c" FROM
Hi,
Noticed a strange regression after 3.7.7 (in 3.7.8 and inherited in 3.7.9)
I have a Russian morphology database and different queries working with it.
I narrowed it to the following case and populated with a couple of English
words (just to make sense)
The following database
CREATE TABLE [Be
> *The prgama PRAGMA journal_size_limit = **N , *does not seem to limit
> the size of the WAL log file. Is there any precondition to be
> satisfied before calling the pragma ?
I have same problem (on Windows). See this console session:
SQLite version 3.7.9 2011-11-01 00:52:41
Enter ".help" for i
30 matches
Mail list logo