SQLite
From the project home page:
- SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.
Installation
Related packages are:
- sqlite-doc – most of the static HTML files that comprise this website, including all of the SQL Syntax and the C/C++ interface specs and other miscellaneous documentation
- sqlite-analyzer –
sqlite3_analyzer
is a command-line utility program that measures and displays how much and how efficiently space is used by individual tables and indexes with an SQLite database file - sqlite-tcl – the Tcl interface to the SQLite library
- php-sqlite – sqlite3 module for PHP (do not forget to enable it in
/etc/php/php.ini
) - ruby-sqlite3 – Ruby bindings for the SQLite3 embedded database
- gambas3-gb-db-sqlite3 – Gambas3 Sqlite3 database access component
Using sqlite3 command line shell
The SQLite library includes a simple command-line utility named sqlite3 that allows the user to manually enter and execute SQL commands against an SQLite database.
Create a database
$ sqlite3 databasename
Create table
sqlite> create table tblone(one varchar(10), two smallint);
Insert data
sqlite> insert into tblone values('helloworld',20); sqlite> insert into tblone values('archlinux', 30);
Graphical tools
- DB Browser for SQLite — High quality, visual, open source tool to create, design, and edit database files compatible with SQLite.
- Sqliteman — Simple sqlite3 browser and editor.
For tools supporting multiple DBMSs, see List of applications/Documents#Database tools.
Using sqlite in shell script
See forum post.
gollark: Well, not really, it could also somehow move to the future's chat platforms.
gollark: Continue, my slave.
gollark: Anyway, if I can somehow get my hands on a closed timelike curve, this will be much easier.
gollark: What happens if they don't, and the bot shuts down before they've all been sent?
gollark: You know, this could work with some sort of smarter text generator, and perhaps a more predictable server.
This article is issued from Archlinux. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.