Re: [sqlite] OK to drop support for legacy file formats?

If you need a special function foo() use the extension api of sqlite. This is perfectly correct! Few bytes are the footprint of a quick and small database. Thats is more or less the definition. Code that is rarely used and also, does not provide a core function in sqlite, should simply not be

[sqlite] SQLite in OpenOffice?

Hi all, wouldn't sqlite fit into the openoffice package as access fits into Microsoft Office? / Jonas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Performance problem

According to the postgresql documentation, the hash algorithm is discouraged compared to b-tree for performance reasons. http://www.postgresql.org/docs/view.php?version=7.3idoc=1file=indexes-types.html Note: Testing has shown PostgreSQL's hash indexes to be similar or slower than B-tree indexes,

[sqlite] Big Players League

Personally I'm a big fan of Sqlite (great tool), and I really hope that this issue can be solved (so we can choose Sqlite). I understand that solving this issue demands big changes, but I believe this will take Sqlite to the big players league. There are great competition in that division

[sqlite] Work around for count (distinct a) ?

Hi, I have noticed that it is hard to acheive the count (distinct a) command in sqlite. However, I have tried the suggested work around by: SELECT count(ticker) FROM (SELECT DISTINCT ticker FROM ListDetail WHERE TableName LIKE sixty% AND Ticker This is also giving an error, is there any