Re: [sqlite] DateTime comparison with custom format

tandard". The standard is defined here: http://en.wikipedia.org/wiki/ISO_8601 D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] CURRENT_TIMESTAMP with fractional seconds?

f', 'now')); > Put parentheses around the strftime() function call: CREATE TABLE info(..., stamp DEFAULT (strftime('%f','now'))) The extra parentheses are needed to avoid a parsing ambiguity in the SQL language. D. Richard Hipp d...@hwaci.com ___

Re: [sqlite] Trouble running sqlite3 in ubuntu linux 9.04

urce files (all conveniently packaged in a tarball on the download page): sqlite3.c sqlite3.h shell.c Then run: gcc -static -o sqlite3 -DSQLITE_THREADSAFE=0 sqlite3.c shell.c -ldl Then move the resulting stand-alone, dependency-free executable "sqlite3" to someplace on y

Re: [sqlite] Detecting database corruption

this ? Chim is using a version of SQLite that is over 5 years old. The behavior he describes is not present in any recent version of SQLite, at least not as far as anyone is aware. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlit

Re: [sqlite] Explanation

ase? I think the migration command is: > > echo '.dump' | sqlite3 $db | sqlite3 $dbnew > > Maybe the internal database structure has changed? The file-format is unchanged. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing

Re: [sqlite] Big performance problem with inserting lots of data

On Aug 31, 2009, at 10:28 AM, Kalle Last wrote: > Hello, > > I'm having a big performance problem while trying to use sqlite as a > data output for my application. Before going further, have you seen http://www.sqlite.org/faq.html#q19 ? D. Richard Hi

Re: [sqlite] Big performance problem with inserting lots of data

On Aug 31, 2009, at 11:07 AM, Kalle Last wrote: > 2009/8/31 D. Richard Hipp : >> >> On Aug 31, 2009, at 10:28 AM, Kalle Last wrote: >> >>> Hello, >>> >>> I'm having a big performance problem while trying to use sqlite as a >>> data o

Re: [sqlite] Problems encountered on upgrade from SQLite2 to -3

ave some rows where Field='3' and different rows where Field=3 and SQLite will distinguish between them. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 3.6.17

inal. Works for me: sqlite-imac:bld drh$ ./sqlite3 SQLite version 3.6.17 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table t1(x); sqlite> insert into t1 values('Alberto Simões ξ € 夷'); sqlite> select * fr

Re: [sqlite] SQLite 3.6.17

On Sep 2, 2009, at 9:39 AM, Alberto Simões wrote: Hello, drh. On Wed, Sep 2, 2009 at 2:28 PM, D. Richard Hipp wrote: Works for me: sqlite-imac:bld drh$ ./sqlite3 SQLite version 3.6.17 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlit

Re: [sqlite] SQLite 3.6.17

On Sep 2, 2009, at 9:46 AM, D. Richard Hipp wrote: >>> >>> It worked for me before. No idea what is happenning. >> Can you please send me your env? > > sqlite-imac:bld drh$ ./sqlite3 SQLite version 3.6.17 Enter ".help" for instructions Enter SQL stateme

Re: [sqlite] Problems encountered on upgrade from SQLite2 to -3

nd in particular, it does not contain such a claim coming from someone who does not understand how SQLite3 works. I think if you try my do-over suggestion you will find the people here will be nice, friendly, and much, much more helpful. D. Richard Hipp d...@hwaci.com ___

Re: [sqlite] confused about column affinity

nteger affinity. Hence the '1' on the other side of the = is coerced into a 1. See section 3 "Comparison Expressions" of the same document: http://www.sqlite.org/datatype3.html This all seems really complicated. But we did it that way because it causes SQLite to mimic the behavior of other statically typed database engines (ex: MySQL, PostgreSQL, Oracle, etc.) and hence maximizes compatibility. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Booleans in SQLite

ling list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Booleans in SQLite

On Sep 3, 2009, at 8:25 PM, Mark Spiegel wrote: > D. Richard Hipp wrote: >> You are both right and both wrong. There are two different integer >> representations used in SQLite. >> >> (1) "varint" or variable length integer is an encoding of 64-bit >>

Re: [sqlite] sqlite3_exec fails on arm

lines of code shown above. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite version 3.6.18 scheduled for Monday

We are on schedule to release SQLite version 3.6.18 on Monday, 2009-09-14. For a preview, see http://www.sqlite.org/draft/index.html D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080

Re: [sqlite] SQLite version 3.6.18 scheduled for Monday

here is no network traffic with "fossil diff"). D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.6.18 scheduled for Monday

ng. Can you suggest better ways of organizing the documentation above? D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.6.18 scheduled for Monday

> create and maintain a private branch of SQLite. See > http://www.sqlite.org/privatebranch.html > for further discussion. > > (5) In our experience, Fossil works better than CVS over slow and/or > unreliable networks. And, Fossil allows users

Re: [sqlite] I'm surprised what the author of web2py on web2py mailing list just said about sqlite

> > cheers, > Stef > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org htt

Re: [sqlite] sqlite3_exec fails on arm

tabase file onto the device, your copy utility corrupted the database file (again, possibly by \r to \r\n translation) (3) your compiler somehow thinks that sizeof(char)!=1. There might be other causes, but those are the ones that come to mind. > CLOSE 16 D. Rich

[sqlite] SQLite version 3.6.18

ready for production use. Please let me know if you encounter any problems. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] A question about how to interpret pragma integrity_check

't solve the problem. It means the index is corrupt. Try running "REINDEX". D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Date and age calculations

ose ages are between 11 and 12. Is there > any way I can make the SELECT more precise? > > Thank you very much, > > Craig Smith > cr...@macscripter.net > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Date and age calculations

I didn't think about the BETWEEN operator. How about this: WHERE birth BETWEEN date('now','-24 years') AND date('now','-12 years') D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite testing

ind out what platforms are tested. In particular do you > test on > · Solaris with the Sum compiler? > · SCO OpenServer with its native compiler? > We test on linux (x86, amd64), mac (x86), win32, win64, and wince. D. Richard Hipp d...@hwaci.com

Re: [sqlite] Running test after misc7-6.1.2

seconds have elapsed, then it should give up and report an error. My first guess would be that usleep() is not working quite right on your system. What OS are you running? What compiler? D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] New function request: sqlite3_busy_timeout_???(sqlite3*, int ms, int minSleepMs)

recipient is strictly prohibited. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL Lite date / time functions

date from reports where reportid='123456', 'start > of month','+1 month','-1 day') > or > > SELECT date((select date from reports where reportid='123456') , > 'start of month','+1 month','-1 day') &

Re: [sqlite] Most wanted features of SQLite ?

held belief that since OSes provide byte-level locking of files it should be a simple matter to provide row-level locking in a serverless database engine. The proposed paper will explain why that belief is incorrect. D. Richard Hipp d...@hwaci.com ___

Re: [sqlite] Date comparisons

e an index on table2.dateitem2: SELECT ... FROM table1 AS t1 LEFT JOIN table2 AS t2 WHERE t2.dateitem2 BETWEEN datetime(t1.dateitem1, '-10 minutes') AND datetime(t1.dateitem1,'+10 minutes'); D. Richard Hipp d...@hwaci.com _

Re: [sqlite] Date comparisons

" - you are comparing strings or floating-point numbers and the answer you are getting is correct for strings and/or numbers. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQL language question

about ON UPDATE SET NULL? Has anybody ever actually seen ON UPDATE SET NULL used in practice? D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem if IF NOT EXISTS

STS was added to the SQLite version 3.x.x series in January 2006. Version 2.8.17 is from December 2005. Development on the 2.x.x series ended at that point. There will be no further enhancements to 2.8.17. D. Richard Hipp d...@hwaci.com ___ sqlite

Re: [sqlite] Sqlite reading all column data on selects.

of later pages without having to read earlier pages. SQLite never reads pages that follow what is needed. Once the necessary pages are in memory, SQLite only looks at the specific parts of a row that are requested. Unrequested columns are never extracted or decoded from the raw row data. D

Re: [sqlite] Sqlite reading all column data on selects.

the database is not too badly fragmented, it will usually succeed. When autovacuum=OFF, then pointer map pages are not availble and SQLite is compelled to read all prior pages when seeking to the end of an overflow chain. D. Richard Hipp d...@hwaci.com __

Re: [sqlite] Attach databases using tons of memory (DBI Perl)

ses. But even if you don't do this, the cache size should be 2000 pages which is only about 64MB for each attached database. What does sqlite3_mem_used() and sqlite3_mem_highwater() tell you about SQLite's memory usage? Are you sure that it is SQLite and not your perl s

Re: [sqlite] SQLite Suitability for Shopping Cart

e.com/SQLite-Suitability-for-Shopping-Cart-tp25530589p25615724.html > Sent from the SQLite mailing list archive at Nabble.com. > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlit

Re: [sqlite] TH3 license

in the public domain (for all countries that > recognize that concept). > > Rich > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com

Re: [sqlite] Compiler warnings with Sun Studio 12.1 on Solaris 10

now, we cannot even evaluate the warnings to determine whether or not they are bugs because you haven't told us what version of SQLite you are attempting to compile so the line numbers are meaningless. (In a 100,000-line source file, line numbers shift drastically from day to day.) W

Re: [sqlite] Compiler warnings with Sun Studio 12.1 on Solaris 10

Complains about this constant: (((sqlite3_int64)1)<<63) Harmless All warnings are harmless and will remain unaddressed for now. Thanks for the reports, though! D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiler warnings with Sun Studio 12.1 on Solaris 10

eFUnFQfAu > nXkAnRqqCi4MNIllFSuoW0F9FwIz/8Hi > =gmns > -END PGP SIGNATURE- > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com

[sqlite] Fwd: sqlite3_prepare_v2

. And as this belongs to Apple, I think this might be > the affected program, not withstanding it works. Besides I have a > Nokia Cell, which I don't know if for connecting it to the CP might > need the missing element. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite behaviour on FreeBSD and KVM

day or two. That seems to be what happened here. If you see a redundant message, simply ignore it. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Documentation for bubble-generator.tcl

The only documentation is comments in the code. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Retrieved]Re: DB Corruption

ually remove the duplication entries, then reconstruct the database file from the dump, you should recover all information. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Retrieved]Re: DB Corruption

ing hundreds or thousands of updates without BEGIN...COMMIT and you haven't already complained about the speed, this suggests that your database is running asynchronously (i.e. with PRAGMA synchronous=OFF or on a system that does not support fsync() or

Re: [sqlite] Problem with PAGE_SIZE and CACHE_SIZE in the sqlite356 c-api

g. You should not need to modify the source code. See: http://www.sqlite.org/compile.html#default_cache_size http://www.sqlite.org/compile.html#default_page_size D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Retrieved]Re: DB Corruption

age 439 is never used > Page 458 is never used > Page 469 is never used > Page 483 is never used > Page 500 is never used > Page 502 is never used > Page 505 is never used > Page 508 is never used > Page 510 is never used > Page 512 is never used > Page 535 is never used >

Re: [sqlite] Bug in 3.6.18 genfkey code: trigger not working for quoted column names

FROM parent; > SELECT * FROM child; > > Actual result: > 0 > 7 > > Expected result: > SQL error near line 6: constraint failed > SQL error near line 7: constraint failed > 1 > 1 > > I suggest the fix attached to this mail. > > Regards, > Thomas. > _

Re: [sqlite] A rowid request

cceptable. > > Please let me know if we can have some hope that this feature will > be added in a future update. This is very unlikely to be added. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http:

Re: [sqlite] sqlite build issues on IBM's HP-UX 11i

machines (linux, mac, windows, on x86 and x86_64) then we may well take you up on your offer to debug on HPUX/pa-risc. But at this time, that would not be useful. Thanks. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Encoding specs & functions overloading

istered for UTF-8 input is useless? LIKE and GLOB are the same as other functions. I have added test cases to SQLite verify that correct encoding (UTF8 or UTF16) of overloaded LIKE and GLOB functions are called based on the database encoding. D. Richard Hipp d...@hwaci.com _

Re: [sqlite] Bug in date() function ??

e data, the example date > has 31 days added to it. Which is correct. > > When I subtract '-1 month' the date only gets 28 days > subtracted from it. > > Surely adding or subtracting a month modifier to a date > should be the same number of days in each direction

Re: [sqlite] Bug in date() function ??

On Oct 13, 2009, at 3:17 PM, Keith Roberts wrote: > On Tue, 13 Oct 2009, D. Richard Hipp wrote: > >> To: General Discussion of SQLite Database >> From: D. Richard Hipp >> Subject: Re: [sqlite] Bug in date() function ?? >> >> >> On Oct 13, 2009, at

Re: [sqlite] Segfault on a specific input

> done boolean default 'f' > ); > INSERT INTO todo (title) VALUES ('Learn web.py'); > I tried this under both 3.6.6.2 on Linux, and 3.6.10 on Mac OS X. http://www.sqlite.org/src/info/2d401a Fixed in 3.6.18 D. Richard Hipp d...@hwaci.com ___

[sqlite] SQLite version 3.6.19

erage). We consider this release to be production ready. Nevertheless, testing can only prove the presence of bugs, not their absence. So if you encounter problems, please let us know. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sql

Re: [sqlite] Corrupted database

ed immediately by ExitProcess(), is it the case that the write might not actually occur? D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Corrupted database

and thousands of test cases to verify that partial writes do not corrupt the database file. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite encription

file to allow/deny acces? I believe Adobe AIR has built-in support for SQLite database encryption. Check your documentation. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Spam filtering. Was: Data migration tool certification

l I get around to approving them before they can send emails to this list. Are there other suggestions on how to limit or curtail the kind of mailing list abuse practiced by Talend? D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list

Re: [sqlite] Order of operations when using TRIGGERs

KEY, never a raw ROWID, for anything that you want to persist for longer than the current transaction. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Order of operations when using TRIGGERs

ely on being able to access that value in my TRIGGER as > NEW.columnName ? AFTER triggers only. With BEFORE triggers, the NEW.columnName value might not have been generated yet. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlit

[sqlite] Fwd: error message

; > The proceedure entry point sqlite3_prepare_v2 could not be located > in the dynamic link library SQLite3.dll > > How can I fix and what do I need to do? > > I am about to upgrade to Windows 7 > > Thank you. > John T. Mas

Re: [sqlite] Fwd: error message

On Oct 24, 2009, at 11:40 AM, D. Richard Hipp wrote: > > > Begin forwarded message: > >> From: John Mason >> Date: October 24, 2009 11:12:26 AM EDT >> To: d...@hwaci.com >> Subject: error message >> >> I have a windows xp operating system and

Re: [sqlite] Fwd: error message

On Oct 24, 2009, at 11:40 AM, D. Richard Hipp wrote: > > > Begin forwarded message: > >> From: John Mason >> Date: October 24, 2009 11:12:26 AM EDT >> To: d...@hwaci.com >> Subject: error message >> >> I have a windows xp operating system and

Re: [sqlite] sqlite3_release_memory() current status

nterest in it I should have. > > Thanks, > PK > ___________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_ENABLE_COLUMN_METADATA question ...

dependancies other than > SQLITE_ENABLE_COLUMN_METADATA? > > Is there anything I might have overlooked?? > > Any ideas?? > > Thanks in advance, > Rob Sciuk > ___________ > sqlite-users

Re: [sqlite] sqlite3_release_memory() current status

On Oct 26, 2009, at 5:53 PM, Peter Kasting wrote: > On Mon, Oct 26, 2009 at 2:48 PM, D. Richard Hipp > wrote: > >> On Oct 26, 2009, at 5:00 PM, Peter Kasting wrote: >>> as >>> far as >>> I can tell the current code shouldn't cause any performance

Re: [sqlite] sqlite3_release_memory() current status

On Oct 26, 2009, at 6:16 PM, D. Richard Hipp wrote: > > The memory management has undergone multiple rewrites in the previous > two years, but as far as we know, sqlite3_release_memory() still works > as advertised. Please let us know if you find otherwise. FWIW, with the latest ch

Re: [sqlite] SQLite: question

ert a row, having the value "STATUS" on > that TEXT column; Then try to select the row by using WHERE myColumn > = "STATUS". It does not work for me. > > Could you please tell me whether this is a bug or I am just using

Re: [sqlite] Grammar of "X is Y"

is wrong here. That said I'd much > rather > the behaviour of sqlite changed to match the docs rather than vice- > versa > because I really want to write neat queries like: > > select col1 is col2 from table > See the second bullet on http://www.sqlite.org/releaselog/3_

Re: [sqlite] A constraint bug?

IGNORE" in the insert statements, either. > > Cheers, > > Mick O'Neill > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com _

Re: [sqlite] Getting older version from website

On Nov 3, 2009, at 8:03 PM, Edward Diener wrote: > D. Richard Hipp wrote: >> On Nov 3, 2009, at 9:34 AM, Edward Diener wrote: >> >>> Is it possible to retrieve an older version of sqlite from the web >>> site >>> rather than the latest version ? >&g

Re: [sqlite] Getting older version from website

On Nov 3, 2009, at 9:34 AM, Edward Diener wrote: > Is it possible to retrieve an older version of sqlite from the web > site > rather than the latest version ? http://www.sqlite.org/download.html#cvs D. Richard Hipp d...@hwaci.com _

Re: [sqlite] SQLite on PocketBook

seen that sort of thing before, especially with GCC. There are some options to GCC (which escape my memory right now) that can force it to use strict IEEE 754 floating point rather than its preferred, speedier but non-standard alternative. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Fwd: How to Custom Sqlite for Vxwors

> yours > : kanghui > > > > 09年新晋3D主流网游《天下贰》，网易六年亿资打造 D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite version 3.6.20

/books.html Version 3.6.20 is considered stable and ready for production use. As always, please let us know if you encounter any problems. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

Re: [sqlite] Sqlite performnace problem on big project

lution ? > separaring the blogs into another table and let small columns on > main table ? Separating the mail body BLOBs into a separate table would help too. But the index above will help the most, I suspect. D. Richard Hipp d...@hwaci.com __

Re: [sqlite] SQLite on PocketBook

in SQLite we will be happy to look into it for you. But we have no capability of helping you with your ARM problems. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Local data structures vs sqlite

eally need to go? If it is absolutely critical that you find your answer in nanoseconds, then by all means use C code. But if you are operating on human timescales (tens or hundreds of milliseconds) then SQLite will be fast enough and, depending on what you are trying to accomplish, might be

Re: [sqlite] 3.6.20 NATURAL self-join still not fixed

from test1 natural join test1; > 100 Try that again using 3.6.20. That problem was fixed by http://www.sqlite.org/src/vinfo/ 6fe63711754on 2009-10-19. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http:

Re: [sqlite] 3.6.20 NATURAL self-join still not fixed

SELECT sqlite_version(); SELECT sqlite_source_id(); Thanks! D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Fwd: SQLite 3.6.20 problem

effect. If I run "sqlite3 -batch > existing.db < create_tables.sql", no tables are actually created. > > This seems to be a major change. Does -batch serve any purpose any > longer? D. Richard Hipp d...@hwaci.com ___ sqlit

Re: [sqlite] Request: SQLITE_USE_MALLOCA

h > stack space, bad things happen and it's usually very difficult to > debug. Have you actually measured how much stack space SQLite is using (even with SQLITE_USE_ALLOCA)? Is excess stack space usage really a problem? D. Richard Hipp d...@hwaci.com

Re: [sqlite] How do I output multi-word strings without braces?

the source SQLite tree is TCL script. We're comfortable having mixed Tcl/SQLite questions here. http://www.sqlite.org/docsrc/artifact/07b4fa3fd6 D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8

Re: [sqlite] sqlite3_analyzer with 3.6.19 distribution

On Nov 11, 2009, at 11:24 AM, Jens Miltner wrote: > > Is sqlite3_analyzer supposed to work in 3.6.19? > No. sqlite3_analyzer has been busted for a long time. But the 3.6.0 version of sqlite3_analyzer works just fine, even on databases created using 3.6.19. D. Richard Hipp d...@

[sqlite] Fwd: failing attempts at sending "Feature request: PRAGMA maximum_file_format"

do when the > requested default_file_format is higher than the highest supported > version. It may be reasonable to handle this as equivalent to PRAGMA > legacy_file_format=0 instead of treating it as an error.) > > Does this sound like something worth adding? If it

Re: [sqlite] Fwd: failing attempts at sending "Feature request: PRAGMA maximum_file_format"

On Nov 12, 2009, at 1:30 PM, D. Richard Hipp wrote: >> >> To write more future-proof code I would like to have something like >> PRAGMA default_file_format or PRAGMA maximum_file_format that lets me >> explicitly specify the highest file format version SQLite will use

[sqlite] Fwd: Content filtered message notification

ect: Re: [sqlite] Fwd: failing attempts at sending "Feature > request: PRAGMA maximum_file_format" > > > On Thu, 2009-11-12 at 13:37 -0500, D. Richard Hipp wrote: >> On Nov 12, 2009, at 1:30 PM, D. Richard Hipp wrote: >>>> >>>> To writ

Re: [sqlite] BUG (?) foreign_keys=on/off within a transaction

www.sqlite.org/docsrc/vinfo/a802dbe3fbf6d0979de534d400910211b854b978 D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Why does LIKE operator affect order of query plan?

using LIKE it should always continue using LIKE. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Why does LIKE operator affect order of query plan?

, on the other hand, do store the original SQL text and can re-prepare and so they can optimize for parameters on the RHS of a LIKE. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] compiler warnings with 3.6.20 on Visual Studio 2005 (with all updates)

g C4244: 'function' : conversion from > 'ynVar' to 'int', possible loss of data > .\sqlite3.c(86804) : warning C4244: 'function' : conversion from > 'ynVar' to 'int', possible loss of data > .\sqlite3.c(87249) : warning C4244: &

Re: [sqlite] bad data in a database file or bug?

On Nov 17, 2009, at 8:09 PM, Vasu Nori wrote: > > but can't select the row _id = 0 What does the following query show: SELECT _id, typeof(_id) FROM feeds; D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users

Re: [sqlite] bad data in a database file or bug?

nteger > 14|integer Please email your database directly to me for analysis. d...@hwaci.com D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] bad data in a database file or bug?

On Nov 17, 2009, at 9:49 PM, D. Richard Hipp wrote: > > On Nov 17, 2009, at 9:45 PM, Vasu Nori wrote: >> >> sqlite> SELECT _id, typeof(_id) FROM feeds; >> 1|integer >> 2|integer >> 3|integer >> 4|integer >> 5|integer >> 6|integer >>

Re: [sqlite] SQL error: disk I/O error and symlink

LLOW, not for this reason, but to prevent an attack using symbolic links that could allow an unprivileged user to trick SQLite into deleting a file that the unprivileged user does not have access rights for. D. Richard Hipp d...@hwaci.com ___ sqli

Re: [sqlite] substr in sqlite3 3.6.20

can see that they behave differently with 3.6.7 doing the right > thing. > I did not find any mentioning of that here > http://www.sqlite.org/changes.html > If that is a bug, it *is* a major one! > > -- > Dmitri Priimak > > ___________

<    1   2   3   4   5   6   7   8   9   10   >