SQLite DB Editor - Search localsearch

sqlite.org

https://sqlite.org/index.html

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.org

https://sqlite.org/download.html

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 repository contents and download historical versions of individual files or ZIP archives of historical check-ins. You can also clone the entire repository.

sqlite.org

https://sqlite.org/about.html

About SQLite

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.

sqlite.org

https://sqlite.org/quickstart.html

SQLite In 5 Minutes Or Less

The Command Line Interface or "CLI" is a simple command-line program that accepts SQL input text and passes it through to the SQLite database engine core to be executed. The name of the CLI program is "sqlite3" (or "sqlite3.exe" on Windows). Use the CLI for manual interactions with a database. At a shell or DOS prompt, enter: " sqlite3 test.db ".

sqlite.org

https://sqlite.org/whentouse.html

Appropriate Uses For SQLite

SQLite is not directly comparable to client/server SQL database engines such as MySQL, Oracle, PostgreSQL, or SQL Server since SQLite is trying to solve a different problem. Client/server SQL database engines strive to implement a shared repository of enterprise data. They emphasize scalability, concurrency, centralization, and control. SQLite strives to provide local data storage for ...

sqlite.org

https://sqlite.org/lang.html

Query Language Understood by SQLite

SQL As Understood By SQLite SQLite understands most of the standard SQL language. But it does omit some features while at the same time adding a few features of its own. This document attempts to describe precisely what parts of the SQL language SQLite does and does not support. A list of SQL keywords is also provided.

sqlite.org

https://sqlite.org/fullsql.html

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 Indexes can use DESC and COLLATE Partial indexes Indexes On Expressions Clustered indexes Covering indexes CHECK, UNIQUE, NOT NULL, and FOREIGN KEY constraints.

sqlite.org

https://sqlite.org/draft/download.html

SQLite Download Page

sqlite.org

https://sqlite.org/releaselog/3_50_0.html

SQLite Release 3.50.0 On 2025-05-29

SQLite Release 3.50.0 On 2025-05-29 Add the sqlite3_setlk_timeout () interface which sets a separate timeout, distinct from the sqlite3_busy_timeout (), for blocking locks on builds that support blocking locks.

sqlite.org

https://sqlite.org/releaselog/3_50_2.html

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 sqlite3_busy_timeout (), for blocking locks on builds that support blocking locks.