a few seconds and try the sqlite3_exec again, the works
> correctly. (testing in the debugger)
>
>
>
> Is there anyway to test for this condition so I handle it properly?
The situation you describe does not occur in SQLite version 3.6.5.
D. Richard Hipp
[EMAIL PROTECTED]
_
email to me.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
3.6.5 out by about this time
tomorrow. We plan to release regardless of whether or not we have
test results. But if you find a problem, we will delay the release in
order to fix it.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
and then prepared with a
> different query programmatically. Is there any sort of unique
> identifier in those prepared structures?
I'm not sure I understand the question. Is
http://www.sqlite.org/c3ref/sql.html
what you are asking for?
D. Richa
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
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
;
>
> 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
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
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
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
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
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
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
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
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
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.
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]
..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
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
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
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
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
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?
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
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
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.
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]
__
-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
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
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
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
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
. 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
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
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
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
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
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
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
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
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
.
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
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
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
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
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
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
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
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
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
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]
__
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
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
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
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
'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
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
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
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
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
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
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
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]
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-
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.
(~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
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
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
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
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
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
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
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
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
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 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
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
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
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
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
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
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
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
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-
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
[
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
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
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
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]
_
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
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
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
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]
__
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
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]
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
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
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]
___
501 - 600 of 1539 matches
Mail list logo