ain that all prepared statements are finalized prior to
calling sqlite3_close()?
I have no idea what kind of VFS layer is being used for the iPhone.
It might be something custom. If so, there could be a leak in the VFS
layer someplace.
D. Richard Hipp
[EMAIL PROTECTED]
_
ts in
mutex_unix.c to see if the HOMEGROWN_RECURSIVE_MUTEX implementation
really is safe for FreeBSD.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
, then the file name argument passed to the program
> is
> encoded in GB18030, and this exact byte stream (without any encodig
> conversion) shoud be passed to system APIs. Correct me if I'm wrong
> here,
> please.
I designed and implemented SQLite under the assumption that unix
alw
er using SQLite in their product should never have to mess
with SQLITE_CORE. The SQLITE_CORE macro is for internal use only. If
you find a case where you think you have to set SQLITE_CORE manually
in order to compile SQLite, that is bug - either in SQLite itself or
in your use of SQLite.
problem reported by ticket #3201
http://www.sqlite.org/cvstrac/tktview?tn=3201
which would fixed by check-in [5341]
http://www.sqlite.org/cvstrac/chngview?cn=5341
on 2008-07-04. The fix appears in SQLite release 3.6.0.
D. Richard Hipp
[EMAIL PROTECTED]
___
yone see why my default text value doesn't work?
It works fine when I try it. What does your INSERT statement look like?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
locked, the sqlite3.exe CLI that you
download from the SQLite website will not realize this (because the
locks are in the wrong place) and trouble will result.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
explain what I need to do to support larger data strings?
SQLite works fine with strings that are megabytes in size. There are
multiple tests for this kind of thing in the automated test suite.
Dunno why you are having problems.
D. Richard Hipp
[EMAIL PROTECTED]
On Aug 2, 2008, at 3:08 PM, David Nelson wrote:
> i have attached ther database -- only 14k
The mailing list automatically deletes all attachments.
>
> and i use sqlite3.exe, not the command line
sqlite3.exe *is* the CLI. Not sure what you mean here.
D. Richard Hipp
[EMAIL
r than a file. You do not have to modify any of the
core SQLite code to do this, but you do need to write your own VFS
module, which will require that you have a deep understanding of how
the SQLite core operates.
D. Richard Hipp
[EMAIL PROTECTED]
__
unchanged when extended result
codes are disabled, fixing legacy test cases, writing new test cases,
and so forth. This is at least one full day's worth of uninterrupted
work to get right. And the benefit does not seem worth the effort
right now. We have bigger fish to fry.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
l speed comparison, then speed1.test
should probably be modified to set PRAGMA synchronous=OFF.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
nt
machines, please at least audit the speed1.test script first to see if
it is appropriate for the job.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Works when I try it.
But I'm not running on windows. Do you really need two backslashes in
the filename? Should there be just a single backslash? You do not
quote backslashes in SQL strings as you do in C.
D. Richard Hipp
[EMAIL PROTECTED]
_
tabase.
>
> Regards
> Daniel
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
t would explain where the memory
is going, would it not? We will need quite a bit more information
from you if we are to help you debug your problem.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sq
CREATE INDEX newidx1 ON fs_main(fs_itemtype, fs_textid);
See http://www.sqlite.org/optoverview.html#like_opt
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Aug 15, 2008, at 12:33 PM, Jeff Godfrey wrote:
>
> I'm writing a Tcl-based application that manages a pool of separate
> SQLite database files. ... Is it safe for me to blindly open the
> other database
> and grab the record I need?
Yes.
D. Richard Hipp
[
gt; after
> values?
Generate an equivalent database in a disk file. Then run the disk
file through the sqlite3_analyzer utility which you can download from
the website.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-
Change cache sizes using separate cache_size
pragmas for each attached database.
Please also note that in the next release (SQLite version 3.6.2) the
cache_size pragma will probably become a no-op. We are working on
alternative mechanisms to control the amount of cache memory used.
D. R
ror. So I've been wondering if there's any halfway nice
> and
> clean solution for this, or if I'm maybe just missing an existing
> feature.
Lemon does not have any feature that will provide the application with
access to the follow-set. You could perhaps tease that informatino
gt; mapelements_rtree.NELON>=7900 and
> mapelements_rtree.SWLON<=8000 and
> mapelements.ID=mapelements_rtree.ID;
Please try changing the last term as shown below (add a "+" before the
r-tree ID column):
mapelements.ID = +mapelements_rtree.ID
Let us kn
make sqlite3_analyzer
The sqlite3_analyzer.exe for windows is built by cross-compiling. You
can maybe get this to build natively on windows, but it will likely
require some work.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sql
On Aug 18, 2008, at 2:17 PM, Darren Landrum wrote:
> An object of the class Preset will have the functions to load a
> database into memory
Why do you want to load the database into memory? Why not just open
it and use it off of disk?
D. Richard Hipp
[EMAIL PRO
would be the combination of the OS disk
cache and SQLite's internal page cache will make actual disk I/O
relatively rare, even for an on-disk database.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/c
reason why that wouldn't work.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Aug 19, 2008, at 9:37 AM, Jeffrey Becker wrote:
> So in the cases where the lock cant be acquired, the built in vfs
> implementations return SQLITE_BUSY?
>
Yes
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sql
to
> execute a simple PRAGMA
> statement. If anyone knows of a solution to this problem I would
> appreciate the help.
>
What else have you changed other than 3.5.7 -> 3.6.1? If you pull
out 3.6.1 and recompile with 3.5.7 again does the problem go away?
I do not recall making any
On Aug 19, 2008, at 11:14 AM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
wrote:
> Are there
> any problems with creating the database with 3.5.7 and then reading
> it with 3.6.1?
There are not suppose to be any difference. Nobody else has reported
differences.
D
a AS b, b AS a WHERE a=2;
SELECT a AS x, b AS x WHERE x=1;
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ite
website) over that file and post the results. The sqlite3_analyzer
utility will give us additional information that might suggest ways of
reducing the size of the database file.
See also http://www.hwaci.com/sw/sqlite/prosupport.html#compress
D. Richard Hi
28MB figure? The sqlite3_analyzer output you
posted tells me that the total database size is a little over 9MB, not
28MB.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mail
ory usage by the application. It is not at
all clear to me that SQLite was using all 28 MB. What does
sqlite3_memory_highwater() tell you?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bi
On Aug 20, 2008, at 2:22 PM, Brown, Daniel wrote:
> sqlite3_memory_highwater() ~ 25673060
> sqlite3_memory_used() ~ 23222709
>
OK. I'll have a look....
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite
eing the in-memory database use about
15% more space than the on-disk database. I'm not sure what you are
doing to get 3x memory usage.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
s been fixed since 3.6.1 that causes it to
use less memory.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
(~2MB)
http://www.fossil-scm.org/index.html (~6MB)
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Aug 13, 2008, at 10:59 AM, Dennis Cote wrote:
> D. Richard Hipp wrote:
>>
>> (2) Formal and detail requirements that define precisely what SQLite
>> does.
>>
>> http://www.sqlite.org/draft/tokenreq.html
>> http://www.sqlite.org/draft/syntax.
re passing strings into windows APIs.
Thus the older SQLite bugs and the bugs in your code cancelled each
other out. When the bug in SQLite was fixed, the cancellation went
away and the bug was expressed.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-
se causes the freed disk space
to go onto a freelist to be used on the next INSERT. The space is not
returned to the OS and the file size is not reduced. To reduce the
database file size run VACUUM or enable auto_vacuum.
D. Richard Hipp
[EMAIL PROTECTED]
rmance due
to the added cost of checking type constraints at each step.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ading perhaps 250KB of code
space for a heap space savings of less than 1KB.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ay, but I'm still
> left with the last three.
>
> Am I just out of luck?
>
Run this command:
sqlite3 old.db .dump | sqlite3 new.db
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
the SELECT clause. This looks like a bug.
>
OK. Even though this kind of thing is probably an abuse of SQL, I'm
working on ticket #3343. Just for the record, I'd like everybody to
know that the following is really, really hard to do correctly and is
going to require a lot of extra code in
column in SQLite.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Sep 4, 2008, at 8:56 PM, Darren Duncan wrote:
> D. Richard Hipp wrote:
>> One occasionally sees SQLite schemas of the following form:
>>
>> CREATE TABLE meta(id LONGVARCHAR UNIQUE PRIMARY KEY, );
>>
>> In other words, one sometimes finds a PRIMAR
've finally been straightened out on
that point. Sorry for the false alarm
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
gt; so id will _still_ be a valid integer primary key, even if the
> implementation detail of rowid changes.
I promise that INTEGER PRIMARY KEY will always be an alias for the
rowid in SQLite. This will not change.
>
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
there any
> reliable method to determine the minimum page-cache allocation size
> needed for a given page_size?
>
sqlite3_status(SQLITE_STATUS_PAGECACHE_SIZE, ...)
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
e some thread-local storage. This is pthreads thing. There is
nothing SQLite can do about it. If you are concerned, compile with -
DSQLITE_THREADSAFE=0. This is not a bug in SQLite.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
s
the disk cache behavior in the VFS
layer. SQLite passes sufficient flag information into the "open"
method of the VFS to let it know when the file can be a memory cache
versus a real file.
D. Richard Hipp
[EMAIL PROTECTED]
___
s
f you create a TEMP table to hold the 3000 selected records then do:
INSERT INTO temptab SELECT * FROM maintab WHERE ...;
You can then do your computations on the temporary table without even
interfering with writers on the main table.
D. Richard Hipp
[EMAIL PROTECTED]
__
ging them without a very good reason.)
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
st
suite. The language bindings for TCL are the most natural and easy-to-
use of any language I have seen.
The statistics in the quote above are dated. Recently we have been
getting about 11,000 unique IPs per day at the website and the amount
of TCL
just
> the way it is? Yes, I know I have
> a 3 column index and only using 2 for this query.
I do not see how it is possible for what you say to be true - unless
you have omitted important details of your query, such as a WHERE
clause.
What is the argument to sum(), btw? You should ge
On Sep 21, 2008, at 8:51 AM, Russ Leighton wrote:
> I am interested in ... a way
> to constraint/control index selection on queries.
>
What other SQL database engines have this capability and what syntax
do they use?
D. Richard Hipp
[EMAIL
SQLite version 3.6.3 is now available for download from the website
http://www.sqlite.org/download.html
Version 3.6.3 fixes several bugs in version 3.6.2, most notably the
problem with DISTINCT.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite
with an error. In other words,
the new syntax is a requirement, not a hint.
Comments? Objections?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
structed. It is too late to offer hints after the fact.
> I
> forget if sqlite_stmt keeps a copy of the sql so I may well be
> suggesting the impossible here. The api would reinforce the
> non-standard nature of the action while keeping the sql dialect free
> of no
seems to have
> fixed my problem. Is there any reason this shouldn't be on
> by default?
It only works on a Mac. The build fails on other posix platforms.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqli
.
The COPY method in the TCL interface has never been documented, I
don't believe. And TCL is a case-sensitive language. So I don't
think this is going to be a big issue.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
database recovery - that
is the task of the rollback journal. So the statement journal can be
deleted at will without damaging the database. And, in fact, the
statement journal is opened with delete-on-close.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-use
th remarkably little fuss.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
cks to inside of SQLite so that your
application code does not have to mess with them. It does not
magically provide you any additional concurrency.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Any help would be appreciated
>
Have you read this document: http://www.sqlite.org/atomiccommit.html
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Oct 1, 2008, at 6:25 PM, Mark Spiegel wrote:
> -DSQLITE_OMIT_CONFLICT_CLAUSE=1
This disables REPLACE.
Also, just so you will know, sqlite3_prepare16() works by converting
the SQL into UTF8 then calling sqlite3_prepare().
D. Richard Hipp
[EMAIL PROTEC
www.sqlite.org/cvstrac/captcha?nxp=/cvstrac/tktnew
>
The problem has already been fixed. See
http://www.sqlite.org/docsrc/vinfo/31aaf2c3f5275e43bf301ace914056203f3fccd3
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
http://www.sqlite.org/draft/syntaxdiagrams.html
http://www.sqlite.org/draft/syntax.html
Comments, criticism, and error reports are welcomed - particularly if
they are received in time to be addressed prior to the release of
3.6.4, currently scheduled for Oct 15.
D. Richard Hipp
[EMAIL
On Oct 3, 2008, at 10:48 AM, D. Richard Hipp wrote:
> http://www.sqlite.org/draft/syntaxdiagrams.html
> http://www.sqlite.org/draft/syntax.html
Bad link. Should have been: http://www.sqlite.org/draft/lang.html
>
>
> Comments, criticism, and error reports are welcomed
. I installed ImageMagick and
Ghostscript on a Mac and the script will run there, but the resulting
images look really, really bad.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ge. You can substitute "display" if
you prefer. Or you can omit it all together if you don't want to look
at the GIF immediately after it is produced.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.o
modify these two files in order to compile using Visual C++
> 2003.
This problem was fixed by check-in [5732].
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
epending on their magnitude. If you change the value of an integer
it might change the amount of storage it requires, which then requires
rewriting everything that comes afterwards.
It is recommended that large BLOBs be stored in a separate table with
only an INTEGER PRIMARY KEY.
D. Ri
I
didn't look at the content before approving it....
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
-release announcements on sqlite-
users and use only sqlite-dev for such purposes. If you think this
revised policy is out of line with the usual practice on other
projects, please let me know.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users
mined at compile-time. But OP_IsNull takes no
measurable amount of time, so why clutter up the code base to do so?
You will get much better output from EXPLAIN if you first run the
shell macro ".explain"
D. Richard Hipp
[EMAIL PROTECTED]
__
as the above that attempt to tell
SQLite to use a 32-bit integer where it is expecting to have a 64-bit
integer. But such configurations are untested. You will likely
encounter bugs. I recommend that you only use SQLite on platforms
that have a working 64-bit integer capability.
D.
me again why you want BNF instead of syntax
diagrams? Most people find the syntax diagrams to be much easier to
understand.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/ma
osed. The error checking to
> detect these things and return SQLITE_MISUSE is probabilistic - it is
> not guaranteed to succeed. But when it does, it is helpful in finding
> application errors.
>
> SQLITE_MISUSE returns do not set the error message. So
> sqlite3_errmsg() will conti
the error message. So
sqlite3_errmsg() will continue to return the previous error, whatever
that was.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
le the sqlite3 command
> shell is
> running without problems.
The command-line shell uses sqlite3_open() too. So if it works there,
I do not understand why it is not working in your program. Have you
run your program in a debugger to see exactly where it is crashing?
l unbound and thus
understood as NULL. I prepared the statement once and reused it to do
1000 inserts. The average time was 26.058 milliseconds. Then I did:
UPDATE t1 SET a=$av WHERE rowid=$rid
I prepared the statement separately 1000 times. The average time was
55.458 milliseconds.
Ev
On Oct 15, 2008, at 8:11 AM, D. Richard Hipp wrote:
> SQLite version 3.6.4 is now available for download on the SQLite
> website:
>
> http://www..sqlite.org/download.html
>
> SQLite version 3.6.4 is considered a stable release. Upgrading from
> version 3.6.3 is opt
3.6.4 visit
http://www.sqlite.org/3_6_4.html
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
E_MUTEX_NOOP
yourself. Instead set SQLITE_THREADSAFE=0 and let SQLITE_MUTEX_NOOP
be set automatically.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
em by using sqlite3_snprintf() instead
of sprintf(). sqlite3_snprintf() always uses "." for the radix point
regardless of what locale says - for exactly the reason that Igor
cites. Also with sqlite3_snprintf() you can use %Q instead of '%s' to
avoid SQL injection attacks.
D. Richar
..COMMIT with the INSERT statements in between, you can do
thousands and thousands of fast INSERTs for each relatively slow COMMIT.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
p20075044.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
[EMAIL PROTECTED]
e discrepancy here.
> Are
> recursive triggers required to implement some FK constraints that the
> above solution cannot impose?
>
Does http://www.sqlite.org/cvstrac/fileview?f=sqlite/tool/
genfkey.README answer your questions?
D.
he C
> standard. That's the reason for these warnings. Its also a reason
> not to
> turn off the warnings.
>
Dan is using the void* to hold a 0 or a 1. So his code will work
correctly as long as sizeof(void*)>=1. It would be a strange machine
indeed that failed to meet that
h only 100 records so that I
can poke around a bit?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
might consider
> running a VACUUM just *before* deleting the records, to avoid peaks
> persisting ... and even then (say) every *other* week.
> Just a thought !
>
VACUUM also defragments a database file which sometimes helps
subsequent operations to run faster.
D. Richard Hipp
[E
is not far from the actual database file size of
2.6MB.
I think the growth in database size is probably occurring because you
are inserting more values into the database than you think you are.
The first few pages of the output of sqlite3_analyzer are attached.
D. Richard Hipp
[EMAIL PROTECT
I have no explanation for the observed behavior.
Have you tried running "PRAGMA integrity_check" against the database
as a normal user?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
R
that you looked up? What error message does sqlite3_errmsg(db) return?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
and enhancement of SQLite.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
der any circumstances, even if they are using completely
separate database connections.
My advice is that you not use threads. Threads are evil. But,
recognizing that you are unlikely to heed this warning, at the very
least compile with SQLITE_THREADSAFE=1 if you really think you must
use threa
;
>
> Ocado Limited
>
> Titan Court
> 3 Bishops Square
> Hatfield Business Park
> Hatfield
> Herts
> AL10 9NE
> Tel: +44 (0) 1707 228000
> Fax: +44 (0) 1707 227999
> www.ocado.com
> ___
> sqlite-users mailing list
> sql
If there is anyone from MIO.com is subscripted to this list (and using
a private, non-mio.com domain) I would appreciate it if you would
contact me by direct email. Tnx.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite
On Nov 6, 2008, at 6:16 PM, Griggs, Donald wrote:
> Another interesting thing:
>
http://www.sqlite.org/cvstrac/chngview?cn=5866
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/c
201 - 300 of 1539 matches
Mail list logo
