SQLite
Revision as of 15:40, 29 June 2020 by Retrograde (talk | contribs) (Created page with "SQLite is a local database. Nevertheless, it allows you to use the advantages and concepts of the classic SQL standard language. The main advantage compared to competing data...")
SQLite is a local database. Nevertheless, it allows you to use the advantages and concepts of the classic SQL standard language.
The main advantage compared to competing databases (for example, common MySQL, PostgreSQL) is the absence of a constantly working dedicated server process responsible for queries. Everything is works through a link between a application and SQLite shared library that accesses the database file.
Actual is the third version of SQLite.
Packages:
sqlite3
- CLI utility that allow you to create and work with SQLite datafiles from the command linesqlite3-doc
- API documentation- Bindings:
sqlite3-tcl
- TCL. By the way, TCL & SQLite has one author. SQLite was part of TCL before it became indepedent project.perl-DBD-SQLite
- DBI/DBD driver for the Perl programming languagepython3-modules-sqlite3
- Pyhton 3 moduleslibsqlite3-devel
- classical C & object oriented C++ headers
Sources
- This page in Russian
- SQLite Wikipedia pages in: