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
<[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
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
"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
[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
. 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
[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
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
[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)
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
10 matches
Mail list logo