Recent

Author Topic: New version and documentation for TSqlite*Dataset  (Read 5037 times)

LuizAmérico

  • Sr. Member
  • ****
  • Posts: 458
New version and documentation for TSqlite*Dataset
« on: December 19, 2007, 09:14:27 pm »
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

  • Hero Member
  • *****
  • Posts: 585
    • http://www.silentwings.nl
New version and documentation for TSqlite*Dataset
« Reply #1 on: December 20, 2007, 08:55:58 am »
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!

  :D
Jan
OS: Windows 10 (64 bit) / Linux Mint (64 bit)
Laz: Lazarus 2.0.10 FPC 3.2.0
       CodeTyphon 7.2 FPC 3.3.1

LuizAmérico

  • Sr. Member
  • ****
  • Posts: 458
New version and documentation for TSqlite*Dataset
« Reply #2 on: December 20, 2007, 11:52:15 am »
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

  • Hero Member
  • *****
  • Posts: 585
    • http://www.silentwings.nl
New version and documentation for TSqlite*Dataset
« Reply #3 on: December 20, 2007, 10:15:24 pm »
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.
OS: Windows 10 (64 bit) / Linux Mint (64 bit)
Laz: Lazarus 2.0.10 FPC 3.2.0
       CodeTyphon 7.2 FPC 3.3.1

LuizAmérico

  • Sr. Member
  • ****
  • Posts: 458
New version and documentation for TSqlite*Dataset
« Reply #4 on: December 21, 2007, 12:33:39 pm »
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

  • Hero Member
  • *****
  • Posts: 585
    • http://www.silentwings.nl
New version and documentation for TSqlite*Dataset
« Reply #5 on: December 21, 2007, 02:26:10 pm »
Understood.
I can live with that.

Have a very good and healthy Xmas!

 :D
Jan
OS: Windows 10 (64 bit) / Linux Mint (64 bit)
Laz: Lazarus 2.0.10 FPC 3.2.0
       CodeTyphon 7.2 FPC 3.3.1

 

TinyPortal © 2005-2018