Global web icon
sqlite.org
https://sqlite.org/index.html
SQLite Home Page
SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world.
Global web icon
sqlite.org
https://sqlite.org/quickstart.html
SQLite In 5 Minutes Or Less
Below is a simple C program that demonstrates how to use the C/C++ interface to SQLite. The name of a database is given by the first argument and the second argument is one or more SQL statements to execute against the database.
Global web icon
sqlite.org
https://sqlite.org/serverless.html
SQLite Is Serverless
SQLite is an example of a classic serverless database engine. With SQLite, there are no other processes, threads, machines, or other mechanisms (apart from host computer OS and filesystem) to help provide database services or implementation.
Global web icon
sqlite.org
https://sqlite.org/download.html
SQLite Download Page
See the How To Compile SQLite page for additional information on how to use the raw SQLite source code. Note that a recent version of Tcl is required in order to build from the repository sources.
Global web icon
sqlite.org
https://sqlite.org/whentouse.html
Appropriate Uses For SQLite
Systems designers report success using SQLite as a data store on server applications running in the datacenter, or in other words, using SQLite as the underlying storage engine for an application-specific database server.
Global web icon
sqlite.org
https://sqlite.org/docs.html
Documentation - SQLite
Multi-threaded Programs and SQLite → SQLite is safe to use in multi-threaded programs. This document provides the details and hints on how to maximize performance.
Global web icon
sqlite.org
https://sqlite.org/useovernet.html
SQLite Over a Network, Caveats and Considerations
SQLite is designed for situations where the data and application coexist on the same machine. SQLite can still be made to work in many remote database situations, but a client/server solution will usually work better in that scenario.
Global web icon
sqlite.org
https://sqlite.org/about.html
About SQLite
SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private.
Global web icon
sqlite.org
https://sqlite.org/cli.html
Command Line Shell For SQLite
On startup, the sqlite3 program will show a brief banner message then prompt you to enter SQL. Type in SQL statements (terminated by a semicolon), press "Enter" and the SQL will be executed. For example, to create a new SQLite database named "ex1" with a single table named "tbl1", you might do this:
Global web icon
sqlite.org
https://sqlite.org/althttpd/doc/trunk/althttpd.md
Althttpd: The Althttpd Webserver - SQLite
Althttpd is a simple web-server that has run the https://sqlite.org/ website, among others, since 2004. Althttpd strives for simplicity, security, and low resource usage.