v5:database:sqlite
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
v5:database:sqlite [2024/12/15 15:35] – Support for DROP and RENAME COLUMN dregad | v5:database:sqlite [2025/06/01 13:21] (current) – Remove square brackets in tags dregad | ||
---|---|---|---|
Line 17: | Line 17: | ||
[[v5: | [[v5: | ||
</ | </ | ||
- | ** This is the preferred driver for connecting to sqlite | + | ** This is the preferred driver for connecting to SQLite |
- | This preferred driver | + | It supports connections to SQLite version 3 databases. |
Note that SQLite table and index names are case-sensitive, | Note that SQLite table and index names are case-sensitive, | ||
Line 35: | Line 35: | ||
- | {{tag>[sqlite3 active tier1]}} | + | {{tag> |
------------------------------- | ------------------------------- | ||
Line 50: | Line 50: | ||
</ | </ | ||
This deprecated driver supports SQLite Version 2 databases. | This deprecated driver supports SQLite Version 2 databases. | ||
- | {{tag>[sqlite2 unix windows deprecated]}} | + | {{tag> |
--------------------------------------------- | --------------------------------------------- | ||
===== sqlitepo ===== | ===== sqlitepo ===== | ||
Line 65: | Line 65: | ||
</ | </ | ||
This deprecated driver added portability to the sqlite2 driver by stripping the table names from the column names in queries. | This deprecated driver added portability to the sqlite2 driver by stripping the table names from the column names in queries. | ||
- | {{tag>[sqlite2 deprecated]}} | + | {{tag> |
v5/database/sqlite.1734273354.txt.gz · Last modified: by dregad