Home

Welcome to the libpassqlite wiki!

libPasSQLite 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
  • Create database
  • Run query
• Object wrapper
  • Create database
  • Run query
• Query builder
  • Create database
  • Raw query
  • Table
    • Schema
    • Select
    • Insert
    • Update
    • Delete
  • Transaction

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)
• 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.