Re: [sqlite] SQLite Order BY

Dar All, Can someone guide me, why the ORDER BY in SQLite is too slow. we observed that if the change in data values is small then ORDER BY works better . but if the change is big then the performance is very slow. Even sometime I can not finish a query execution, and wait and may be

[sqlite] New Email notification program

I've added another email notification program to the growing number of available programs. You can pick it up from http://www.lazarusid.com/download/cvstrac-notify-0.5.tar.gz Currently the program is fairly similar to the Python script provided on the Wiki. I don't have Python on my machine

Re: [sqlite] Can anyone recommend some ISAM db to me?

All the involvement of SQL makes no sense in a simple embedded application which is performing associative lookups or ISAM type access. Look at perhaps using DBM or its derivative or something like C-Tree or another B-Tree method. In mimimal applications we have used AVL trees with success. The

Re: [sqlite] Can anyone recommend some ISAM db to me?

Sarah wrote: > Hi, all > After trying SQLite on my embedded platform, I feel that it's a little too > complicated and time-consuming to my platform, especially the parsing. > So, could someone recommend several ISAM ones to me?(I'm a newbie of > database*^_^*) I can recommend Berkeley DB from

Re: [sqlite] Can anyone recommend some ISAM db to me?

By "the parsing" do you mean to say it is difficult to read the result of a query? Yes, I think that can become quite complicated. But there are some good recipes for doing this, including the simple one in the documentation. You can do a lot with simple SQL statements. Before throwing SQLite

RE: [sqlite] Can anyone recommend some ISAM db to me?

Well there's always XBase. Old, solid, widespread. But, I doubt XBase will be that much different overhead, and complexity wise. SQLite is really hard to beat for its intended purpose. And as far as superior implementation, I have never seen an XBase implementation that can even come close to

Re: [sqlite] results of SELECT contains carriage returns

Hi, I have a database where some values contain carriage returns. I am using the command line to execute sqlite commands, eg: sqlite3 Disney.db "SELECT * FROM Characters" When I get the result of a SELECT statement, the output has columns separated by pipe characters and rows by new lines.

[sqlite] Can anyone recommend some ISAM db to me?

Hi, all After trying SQLite on my embedded platform, I feel that it's a little too complicated and time-consuming to my platform, especially the parsing. So, could someone recommend several ISAM ones to me?(I'm a newbie of database*^_^*)