Re: [sqlite] Adding SQL commands

Bertrand Mansion <[EMAIL PROTECTED]> writes: > <[EMAIL PROTECTED]> wrote : > >> I have a similar problem with character encoding in the current >> SQLite versions, by the way. I store UTF-8 encoded data from a >> Python program using PySQLite using a prepackaged SQLite, but since >> the prepackage

Re: [sqlite] Adding SQL commands

<[EMAIL PROTECTED]> wrote : > I have a similar problem with character encoding in the current SQLite > versions, by the way. I store UTF-8 encoded data from a Python program > using PySQLite using a prepackaged SQLite, but since the prepackaged > libsqlite is built without SQLITE_UTF8, I can't use

Re: [sqlite] Adding SQL commands

Joel Rosdahl wrote: "D. Richard Hipp" <[EMAIL PROTECTED]> writes: [...] - page size 512 to 64K selectable at compile-time. Default: 1K [...] - max blob size Adjustable at compile-time up to 2^64 bytes. Performance for large BLOBs is not good and it is recommended that large BLOBs be stored

Re: [sqlite] Adding SQL commands

"D. Richard Hipp" <[EMAIL PROTECTED]> writes: > [...] >> - page size > > 512 to 64K selectable at compile-time. Default: 1K > > [...] >> - max blob size > > Adjustable at compile-time up to 2^64 bytes. Performance for large > BLOBs is not good and it is recommended that large BLOBs be s

Re: [sqlite] Adding SQL commands

[EMAIL PROTECTED] wrote: Great...can you tell me if there will be any increased technical specs??? Ver 3.0 will have a 64-bit ROWID, what about: - page size 512 to 64K selectable at compile-time. Default: 1K - max table rows 2^64 - max database size 2^32 pages. The current implementat

RE: [sqlite] Adding SQL commands

. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 11:52 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Adding SQL commands [EMAIL PROTECTED] wrote: > [I]f version 3.0 is a foundation move to implement enhanced language > functionality later,... That is a c

Re: [sqlite] Adding SQL commands

[EMAIL PROTECTED] wrote: > [I]f version 3.0 is a foundation move to implement enhanced language > functionality later,... That is a correct assessment. SQLite version 3.0.0 is an enhancement to the foundation. SQL Langauge enhancements can be made later and in a backwards-compatible way. The onl

RE: [sqlite] Adding SQL commands

MAIL PROTECTED] Sent: Tuesday, April 13, 2004 7:20 PM To: Thomas, Basil; [EMAIL PROTECTED] Subject: Re: [sqlite] Adding SQL commands Hi Basil, The first use of IF is same syntax as the case statement so I don't think it is required and as IF isn't SQL92 I doubt it will be included so your

Re: [sqlite] Adding SQL commands

[EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 8:03 AM Subject: [sqlite] Adding SQL commands I would like to add some commands to SQLite to make my SQL(ite) programming life easier!!! The commands are: IF - e.g IF ((select count(*) from foo) = 100)

[sqlite] Adding SQL commands

I would like to add some commands to SQLite to make my SQL(ite) programming life easier!!! The commands are: IF - e.g IF ((select count(*) from foo) = 100) select "good"; ELSE select "bad"; END EXISTS