
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.
SQLite Download Page
The SQLite source code is maintained in three geographically-dispersed self-synchronizing Fossil repositories that are available for anonymous read-only access. Anyone can view the …
Command Line Shell For SQLite
1.1. SQLite command-line program versus the SQLite library The SQLite library is code that implements an SQL database engine. The "sqlite3" command-line program or "CLI" is an …
SQLite Release 3.50.2 On 2025-06-28
SQLite Release 3.50.2 On 2025-06-28 Prior changes from version 3.50.0 (2025-05-29): Add the sqlite3_setlk_timeout () interface which sets a separate timeout, distinct from the …
Date And Time Functions - SQLite
Oct 19, 2025 · The first six date and time functions take an optional time-value as an argument, followed by zero or more modifiers. The strftime () function also takes a format string as its first …
How SQLite Works
May 31, 2025 · SQLite is a serverless software library, whereas the other systems are client-server based. With MySQL, PostgreSQL, SQL-Server, and others, the application sends a …
Full-Featured SQL - SQLite
SQLite has a full-featured SQL implementation, including: Tables, indexes, triggers, and views in unlimited quantity Up to 32K columns in a table and unlimited rows Multi-column indexes …
SQLite Release 3.49.1 On 2025-02-18
SQLite Release 3.49.1 On 2025-02-18 Prior changes from version 3.49.0 (2025-02-06): Enhancements to the query planner: Improve the query-time index optimization so that it …
CREATE TABLE - SQLite
Apr 30, 2025 · SQLite supports UNIQUE, NOT NULL, CHECK and FOREIGN KEY constraints. Optionally, a generated column constraint. Whether the table is a WITHOUT ROWID table. …
How do I connect and use an SQLite database from C#?
Aug 25, 2008 · Another way of using SQLite database in NET Framework is to use Fluent-NHibernate. [It is NET module which wraps around NHibernate (ORM module - Object …