Re: [sqlite] 3.5.7 compile failure, with SQLITE_OMIT_VIEW

2008-03-19 Thread Matthew L. Creech
On Wed, Mar 19, 2008 at 12:49 PM, Ken <[EMAIL PROTECTED]> wrote: > > Also Attempting to configure/compile in a different directory than the > makefile.in > resulted in a cp failure while creating the amalgamated source. > This should be fixed in the latest CVS. I also cleaned up the header

Re: [sqlite] is updating Blobs different than inserting??

2008-03-19 Thread Igor Tandetnik
C S <[EMAIL PROTECTED]> wrote: > hi all. wondering if there is any difference in > updating blobs vs inserting? for instance if you have > a small blob and when you update the blob increases in > size and also going from larger to smaller. > > is there anything special that i need to check for or

[sqlite] is updating Blobs different than inserting??

2008-03-19 Thread C S
hi all. wondering if there is any difference in updating blobs vs inserting? for instance if you have a small blob and when you update the blob increases in size and also going from larger to smaller. is there anything special that i need to check for or do to make sure i dont lose any data?

[sqlite] Slow List

2008-03-19 Thread Ken
Is there something wrong with the sqlite list? I sent emails to the list over an hour ago and still nothing is posted? Thanks, Ken ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] 3.5.7 compile failure, with SQLITE_OMIT_VIEW

2008-03-19 Thread Ken
While attempt to compile 3.5.7 the following was generated: gcc -DSQLITE_OMIT_VIEW -DOS_UNIX=1 -I. -I./src -DNDEBUG -DSQLITE_THREADSAFE=1 -DSQLITE_THREAD_OVERRIDE_LOCK=-1 -c ./sqlite3.c -fPIC -DPIC -o .libs/sqlite3.o ./sqlite3.c: In function ‘sqlite3Insert’: ./sqlite3.c:57158: error: syntax

Re: [sqlite] SQL logic error or missing database in version 3.5.6(Bug???)

2008-03-19 Thread Steve Topov
This is SQLite version 3 database file. I checked header. And I can read it with version 3.3.5 dll. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 18, 2008 5:30 PM To: General Discussion of SQLite Database Subject:

Re: [sqlite] Performance degradation after upgrade to 3.5.x on slow flash cards

2008-03-19 Thread Dennis Cote
Dima Dat'ko wrote: > I proceed with playing with the issue. > > sqlite version | flash card type | time from (1) to (2) [milliseconds] > ---++-- > 3.4.2 | SD SanDisk (fast) | 4335 >

Re: [sqlite] algorithm for adding columns to a table

2008-03-19 Thread Derrell Lipman
On Tue, Mar 18, 2008 at 1:03 PM, Virgilio Alexandre Fornazin <[EMAIL PROTECTED]> wrote: > Yes. I did this in my custom version of SQLite. If statement is ALTER TABLE, > and SQLite returns error, I check if it´s ALTER TABLE (t) MODIFY COLUMN ou > DROP COLUMN, doing the exact flow you did.

Re: [sqlite] Complex Query

2008-03-19 Thread BareFeet
Hi Derek, > .m col > .h on > .w 20 17 6 23 6 > .e on They are just the abbreviated version of these dot commands: .mode columns .headers on .width 20 17 6 23 6 .echo on You can get info on each by typing ".help" from within the sqlite3 command line utility. Tom BareFeet

Re: [sqlite] Sorting and Descending Index

2008-03-19 Thread Dennis Cote
Martin Engelschalk wrote: > > I have to select data from a large table (several million records) in > descending order and created an index for that purpose. However, sqlite > seems not to use this index for selecting the data. > > In the documentation of the "create index" - statement, i

Re: [sqlite] Complex Query

2008-03-19 Thread Dennis Cote
Derek Developer wrote: > (2nd attempt... bounced back for some reason...) > > In testing a my code I came across this example. > Could someone help me understand what this syntax is doing please > (from the Seinfeld demo database examples) > > ...m col > ...h on > ...w 20 17 6 23 6 > ...e on >

Re: [sqlite] Performance degradation after upgrade to 3.5.x on slow flash cards

2008-03-19 Thread Dima Dat'ko
Thank you all who supports sqlite! I'm impressed with your work. It happened so that I read the release notes of the newest 3.5.7 only recently. I tried my test with this version and the result is sqlite version | flash card type | time from (1) to (2) [milliseconds]

Re: [sqlite] Sorting and Descending Index

2008-03-19 Thread drh
Martin Engelschalk <[EMAIL PROTECTED]> wrote: > Hello All, > > I have to select data from a large table (several million records) in > descending order and created an index for that purpose. However, sqlite > seems not to use this index for selecting the data. > > In the documentation of the

Re: [sqlite] SQLITE_CONSTRAINT error after sqlite3_step

2008-03-19 Thread Vincent Vega
Dennis , Thanks a lot for this detailed explnation. I will follow your suggestions. Bottom line, in terms of memory allocations, even if I get SQLITE_CONSTRAINT ,I should release the memory I got at sqlite3_mprintf() by calling sqlite3_free() and also release the memory I got at

Re: [sqlite] Malformed database schema with SQLite version > 3.5.x

2008-03-19 Thread drh
MarcoN <[EMAIL PROTECTED]> wrote: > Hello, everybody. > > I have the following problem: I have an old project that uses a database > created with an older SQLite library version. > Now, since I updated SQLite to 3.5.5, I can't use the database anymore, > because any query on the database tables

Re: [sqlite] Sorting NULs with Dynamic Typing

2008-03-19 Thread P Kishor
On 3/19/08, Derek Developer <[EMAIL PROTECTED]> wrote: > In SQLite a NUL is nothing. Inserting a NUL into a column defined as Integer > for example creates a zero length entry not an Integer of value zero. > > How do traditional databases with static typing deal with this? Probably all

Re: [sqlite] Performance degradation after upgrade to 3.5.x on slow flash cards

2008-03-19 Thread Dima Dat'ko
Thank you Dennis for your answer. I proceed with playing with the issue. To whom it might be interesting here are timing results for a simple function demonstrating the problem (please see the code bellow). sqlite version | flash card type | time from (1) to (2) [milliseconds]

Re: [sqlite] Sorting NULs with Dynamic Typing

2008-03-19 Thread Igor Tandetnik
"Derek Developer" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > In SQLite a NUL is nothing. Inserting a NUL into a column defined as > Integer for example creates a zero length entry not an Integer of > value zero. > > How do traditional databases with static typing deal with this?

Re: [sqlite] Sorting NULs with Dynamic Typing

2008-03-19 Thread Dan
> How does SQLite handle sorting with a column that contains values > (including zero) and NULs? Are the NULs converted to zero for the > purposes of sorting? A null value is considered less than all other values when sorting. http://www.sqlite.org/datatype3.html#comparisons Dan.

[sqlite] Sorting and Descending Index

2008-03-19 Thread Martin Engelschalk
Hello All, I have to select data from a large table (several million records) in descending order and created an index for that purpose. However, sqlite seems not to use this index for selecting the data. In the documentation of the "create index" - statement, i found the following sentence:

[sqlite] Sorting NULs with Dynamic Typing

2008-03-19 Thread Derek Developer
In SQLite a NUL is nothing. Inserting a NUL into a column defined as Integer for example creates a zero length entry not an Integer of value zero. How do traditional databases with static typing deal with this? Do they check the column delaration and convert the NUL to a zero value upon entry?

[sqlite] Complex Query

2008-03-19 Thread Derek Developer
(2nd attempt... bounced back for some reason...) In testing a my code I came across this example. Could someone help me understand what this syntax is doing please (from the Seinfeld demo database examples) ...m col ...h on ...w 20 17 6 23 6 ...e on Is this some form of typecasting? This is

Re: [sqlite] Last insert in a table

2008-03-19 Thread A.J.Millan
Puneet, Dennis, Jay: Thank a lot for yours replies. Always is nice to have several views of a matter. I'm agreeing also that the Dennis one is the most elegant answer. In my case it have an additional benefit, with that table I can also track the last modified row. Sometimes I need that