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
(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
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?
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:
> 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.
"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?
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]
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
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
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
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
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]
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
>
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
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
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.
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
>
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:
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
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
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?
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
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
23 matches
Mail list logo