Introduction
Here you will find Freepascal/Lazarus components to access sqlite databases. It comprises of two TDataset descendants (TSqliteDataset and TSqlite3Dataset), the Lazarus package and a thin sqlite3 wrapper class. They were designed with simplicity and speed in mind avoiding code complexity and gratuitous overhead.
News
19/12/07
- Site revamped
- Started documentation: api reference + tutorials
- Released new version of TSqlite*Dataset
HISTORY
I was developing a application to catalogue my games (roms) and needed to store the info into a database. I already had experience with Delphi/MySql and was not satisfied with the performance/complexity of such solution. In fact, is a bit overkill to have a server running only for a desktop application.
So i found Sqlite. It was the perfect solution for what i needed: small, without need to install or configure. But, unfortunately, the component that Freepascal provided at that time was not very functional. It was read only, slow, with a lot of bugs. Initially, i tried to hack it and sent some patches (i've used the Karl Brandt code name for some time) to the fpc team, but i concluded that was better to start from scratch. That is what i did.
Since 2004 the TDataset descendant is included in the Freepascal distribution.