Welcome to the SQLitePass Components Download Page

SQLitePass is a simple set of components designed for Lazarus , Free Pascal Compiler and Delphi, to give access to SQLite databases.
Tested with Lazarus 0.9.29 - FPC 2.4.x under Windows XP and 7- Linux/Unbuntu 10.04 - Delphi 4 - 6 - 7 - 2009 - 2010.
This project is open source, released under LGPL license. Libraries and components are free.

supports reading from / writing to databases created with :


SQLiteExpert

The Sqlite Expert
for Windows


SQLite Administrator

SQLite Administrator
Database manager
for Windows

Kexi project
for Linux and Windows



SQLITE4FPC

Sqlite4Fpc
Database component for FPC

I hope this library will help you !
Feel free to contribute to this project. Send code correction - bug reports ... to


New Message : 2010-09-10



0.55 is finally ready for download !

This new release provides query parameters management and, as usual, many bugfixes...

Check  latest changes.
 

SQLiteToolbox Demo program


SQLiteToolbox is a simple program designed to test SQLitePass components but it should be usefull to manage SQLite databases. Screenshoots

Windows Version (uses 0.55 components)
compiled with Delphi 4.

Windows Unicode Version (uses 0.55 components)
compiled with Delphi 2010.

Windows Version (uses 0.55 components)
compiled with Lazarus – Free Pascal Compiler.

Linux Version (uses 0.55 components)
compiled with Lazarus – Free Pascal Compiler. (Not available yet)

SQLitePass Packages version 0.55 – 2010.09.10



Runtime and Designtime packages for Lazarus and Delphi 4 - 6 - 7 - 2009 - 2010

SQLitePackages_Download

Information Check the latest changes.

Information Previous versions can be found here.


SQLite library (the database engine library)




From version 0.55, the SQLitePass components directly use the standard precompiled library available on the SQLite webpage under the condition the SQLite library was built with the [SQLITE_ENABLE_COLUMN_METADATA] compiler directive. It seems to be the case for the standard windows sqlite3.dll but not for every linux versions/distributions.

You still can build your own version if you need to.

For Windows users :  compile your own sqlite library using this tutorial.
For Linux users : compile your own sqlite library using this tutorial.



Database samples


You can download and try the following database samples in order to test the components. They have been created with different type of programs :

SQLitePass Sample DatabaseSQLiteExpert Sample Database
SQLite Administrator Sample DatabaseKexi  Sample Database
Download the following utility program if you need to populate a database table with random data.
windows only
Utility Program


License


This library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version. This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details. You should have received a copy of the GNU Lesser General Public License along with this library; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
Contributor : Luc DAVID 2006 - 2010.