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
01/05/2010- New release of TSqlite*Dataset
- Updated the tutorials
- Fixed some broken links
01/11/2009
- Moved site from Geocities to Yola
- Updated the documentation (tutorials, api reference)
- New release 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.
