SQLite

From ALT Linux Wiki
Revision as of 12: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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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 line
  • sqlite3-doc - API documentation
  • Bindings:
  1. sqlite3-tcl - TCL. By the way, TCL & SQLite has one author. SQLite was part of TCL before it became indepedent project.
  2. perl-DBD-SQLite - DBI/DBD driver for the Perl programming language
  3. python3-modules-sqlite3 - Pyhton 3 modules
  4. libsqlite3-devel - classical C & object oriented C++ headers

Sources

  1. English
  2. Russian