*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
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
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 a;
Error:
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.
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
___
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,
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
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 have
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
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'll see
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
also
all constant
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 test2
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
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
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,
Malcolm
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
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
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
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
-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
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
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 donts...@home.nl wrote:
-Original
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
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.
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:
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
mci=tip
--
Joe Mistachkin
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
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
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 Tue, Dec 6, 2011 at 9:49 PM, Dan Kennedy danielk1...@gmail.com 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
30 matches
Mail list logo