Talk:SQLite

From Lazarus wiki
Revision as of 03:59, 24 March 2021 by PierceNg (talk | contribs) (Plan for this page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

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.