SQLite: Difference between revisions

From ALT Linux Wiki
(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...")
 
(Starting recreate translations from the Russian original source)
Line 1: Line 1:
SQLite is a local database. Nevertheless, it allows you to use the advantages and concepts of the classic SQL standard language.
[https://www.altlinux.org/SQLite Русский оригинал] этого перевода текста.


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.
[https://www.sqlite.org/index.html SQLite] is a local database. Nevertheless, it allows you to use the advantages and concepts of the classic SQL standard language.
Everything is works through a link between a application and SQLite shared library that accesses the database file.
'''SQLite''' does not use the client-server paradigm, the software stores all data on one device.
The DBMS is built into the application and works as its integral part. The database format is one file.


Actual is the third version of SQLite.


Packages:
== Installation ==
 
Before installing '''SQLite''', it is highly recommended to upgrade your system.
 
You can read more about updating the system here [[RPM]].
 
$ su-
# apt-get update && apt-get dist-upgrade
 
After we have updated the system, we can start installing the '''SQLite''' package.
 
# apt-get install sqlite3
 
== Meta Commands ==
 
'''TODO'''
 
== Standard Commands ==
 
'''TODO'''
 
== Creating, modifying and deleting a database ==
 
'''TODO'''
 
=== Database creation ===
 
'''TODO'''
 
=== Create tables ===
 
'''TODO'''
 
=== Delete table ===
 
'''TODO'''
 
 
== ALT Linux OS packages ==
 
* <code>sqlite3</code> - CLI utility that allow you to create and work with SQLite datafiles from the command line
* <code>sqlite3</code> - CLI utility that allow you to create and work with SQLite datafiles from the command line
* <code>sqlite3-doc</code> - API documentation
* <code>sqlite3-doc</code> - API documentation

Revision as of 09:25, 6 September 2022

Русский оригинал этого перевода текста.

SQLite is a local database. Nevertheless, it allows you to use the advantages and concepts of the classic SQL standard language. SQLite does not use the client-server paradigm, the software stores all data on one device. The DBMS is built into the application and works as its integral part. The database format is one file.


Installation

Before installing SQLite, it is highly recommended to upgrade your system.

You can read more about updating the system here RPM. 

$ su-
# apt-get update && apt-get dist-upgrade

After we have updated the system, we can start installing the SQLite package. 

# apt-get install sqlite3

Meta Commands

TODO

Standard Commands

TODO

Creating, modifying and deleting a database

TODO

Database creation

TODO

Create tables

TODO

Delete table

TODO


ALT Linux OS 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