Search database sqlite> select * from tblone Sqlite> insert into tblone values('archlinux', 30) Insert data sqlite> insert into tblone values('helloworld',20) 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.Ĭreate a database $ sqlite3 databasename Create table sqlite> create table tblone(one varchar(10), two smallint) gambas3-gb-db-sqlite3 – Gambas3 Sqlite3 database access component.ruby-sqlite3 – Ruby bindings for the SQLite3 embedded database.php-sqlite – sqlite3 module for PHP (do not forget to enable it in /etc/php/php.ini).sqlite-tcl – the Tcl interface to the SQLite library.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-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.The source code for SQLite is in the public domain.
SQLite is the most widely deployed SQL database engine in the world. SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
