Interface-based Delphi wrapper
for SQLIte 3

by Nikolai V. Shokhirev

Preface

Code changes:

• unit uSQLite - new unit where the interfaces ISQLiteDatabase and ISQLiteTable are defined.
• unit SQLiteTable3 - slightly modified in order to implement the interfaces ISQLiteDatabase and ISQLiteTable defined in uSQLite.
• unit SQLite3 - the original unit for SQLite API.

Sample application

PictureDB is an enhanced version oh the original example.

Changes:

• Added navigation
• Insert/Delete record
• Post changes (Notes only)

 Mini-manual:

• Create DB: File -> Open DB, Type file name (default: *.sl3)
• Open DB: File -> Open DB, Select file (default: *.sl3)
• Insert picture: Image -> Load, Edit Notes, Press [+]
• Delete picture: Navigate, Press [-]
• Update notes: Edit notes, Press "Post" [V]
  

The program can be freely used for any purpose.  Improvements, corrections and remarks are welcome.

Download: source, demo.

Related links:

SQL with SQLite, a tutorial for beginners: http://www.shokhirev.com/nikolai/abc/sql/sql.html 

Home  |   Shokhirev.com |  Sample code  |   Programming  |   Tools  |   Resume

Please e-mail me at nikolai@shokhirev.com

©Nikolai V. Shokhirev, 2001-2007