Difference between revisions of "Talk:SQLite"
From Free Pascal wiki
Jump to navigationJump to search (Plan for this page) |
(Query advice given) |
||
| Line 12: | Line 12: | ||
I (PierceNg) plan (hope) to document more SQLite-specific content on this page. | 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. [[User:Trev|Trev]] ([[User talk:Trev|talk]]) 07:12, 24 March 2021 (CET) | ||
| + | |||
| + | ---- | ||
Latest revision as of 08:12, 24 March 2021
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)
