New version and documentation for TSqlite*Dataset

[LuizAmérico]

I updated the sqlite4fpc homepage adding documentation and some tutorials.

As a bonus i also added some features.

See http://www.geocities.com/camara_luiz/

[JanRoza]

That's great Luiz!

I was just about to ask you why the LOCATE function only worked when an exact match was found but now I read on your webpage that you implemented the loCaseInsensitive and loPartialKey options.

That will probably cure my problem, I'll install the new TSQLite tonight and see if my LOCATE's work now.

Thanks for all your great work!

 
Jan

[LuizAmérico]

I would also recommend you to read the tutorials, specially the third that uses Locate (http://www.geocities.com/camara_luiz/docs/dataset/dataset-tutorial-03.html).

[JanRoza]

Your new version works great, at last the locate works with caseinsensitive and partials.
Your documentation is very clear and easy to follow.
Still hope that one day you will also add filtering to SQLite datasets.

[LuizAmérico]

Add in memory filtering to TSqlite3Dataset is possible, but  i will not implement it because:

1) Is possible to have the same result using sql. In fact, the possibilities provided by Sql are vastly superior to a homebrew search implementation. The speed of such search is also superior because sqlite uses a data structure (balanced btree) that is optimized for search.

2) The data traffic is not an issue for sqlite because most of the time is used in the same machine as the client. Databases that are located in a server and the query data goes by the network can benefit with in memory filtering.

3) Keep the code small. One of the most appropriated usage for sqlite is in embedded devices where code size and memory usage are issues.

[JanRoza]

Understood.
I can live with that.

Have a very good and healthy Xmas!

 
Jan