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

[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.3=1=indexes-types.html Note: Testing has shown PostgreSQL's hash indexes to be similar or slower than B-tree indexes, and the

[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

[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