In 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.
"May not work with recent versions of SQLite. Skip." - Telling people to "skip" because it *may* not work leaves me wondering whether it will work. If you don't know for sure, then please remove the advice. Just because something has not been updated does not mean it does not work. Trev (talk) 07:12, 24 March 2021 (CET)