libPasSQLite

It is delphi and object pascal bindings and wrapper around SQLite library. SQLite is library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.

Table of contents

• Requierements
• Installation
• Usage
• Testing
• Raw bindings
• Object wrapper
• Query builder

Requirements

• SQLite
• Embarcadero (R) Rad Studio
• Free Pascal Compiler
• Lazarus IDE (optional)

Library is tested for

• Embarcadero (R) Delphi 10.3 on Windows 7 Service Pack 1 (Version 6.1, Build 7601, 64-bit Edition)
• Embarcadero (R) Delphi 11.0 Version 28.0.42600.6491 on Windows 10 (Version 10.0, Build 19042, 64-bit Edition)
• FreePascal Compiler (3.2.0) and Lazarus IDE (2.0.10) on Ubuntu Linux 5.8.0-33-generic x86_64

Installation

Get the sources and add the source directory to the project search path. For FPC add the source directory to the fpc.cfg file.

Usage

Clone the repository git clone https://github.com/isemenkov/libpassqlite.

Add the unit you want to use to the uses clause.

Testing

A testing framework consists of the following ingredients:

1. Test runner project located in unit-tests directory.
2. Test cases (DUnit for Delphi and FPCUnit for FPC based) for all containers classes.

Raw bindings

libpassqlite.pas file contains the SQLite translated headers to use this library in pascal programs. You can find C API documentation at SQLite website.

• Create database
• Run query

More details read on wiki page.

Object wrapper

sqlite3.database.pas file contains the SQLite object wrapper.

• Create database
• Run query

More details read on wiki page.

Query builder

sqlite3.builder.pas file contains the SQLite query builder.

• Create database
• Raw query
• Table
  • Schema
  • Select
  • Insert
  • Update
  • Delete
• Transaction

More details read on wiki page.