Talk:SQLite
From Lazarus wiki
Jump to navigationJump to searchIn general, there are two ways to use SQLite in Lazarus or Pascal programs:
- Using high-level database access libraries such as SQLDB and ZeosLib that enable rapid development of CRUD-type GUI applications with pluggable database drivers for SQLite, PostgreSQL etc with (hopefully) minimal code change.
- Using SQLite-specific libraries that make available to the Pascal programmer extended SQLite functionality beyond generic CRUD operations.
Examples of extended SQLite functionality accessible via C API:
- online incremental backup API
- blob management API
Examples of extended SQLite functionality accessible via SQL:
- working with JSON
- full-text search
I (PierceNg) plan (hope) to document more SQLite-specific content on this page.