|
- 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 repository contents and download historical versions of individual files or ZIP archives of historical check-ins You can also clone the entire repository
- 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 "
- Documentation - SQLite
Customizing And Porting SQLite → This document explains how to customize the build of SQLite and how to port SQLite to new platforms Locking And Concurrency In SQLite Version 3 → A description of how the new locking code in version 3 increases concurrency and decreases the problem of writer starvation
- 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
- CREATE TABLE - SQLite
SQLite supports UNIQUE, NOT NULL, CHECK and FOREIGN KEY constraints Optionally, a generated column constraint Whether the table is a WITHOUT ROWID table Whether the table is subject to strict type checking Every CREATE TABLE statement must specify a name for the new table Table names that begin with "sqlite_" are reserved for internal use
- Datatypes In SQLite
SQLite uses a more general dynamic type system In SQLite, the datatype of a value is associated with the value itself, not with its container The dynamic type system of SQLite is backwards compatible with the more common static type systems of other database engines in the sense that SQL statements that work on statically typed databases work the same way in SQLite However, the dynamic
- System. Data. SQLite: System. Data. SQLite Download Page
The canonical System Data SQLite source code is maintained in a Fossil repository that is 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
|
|
|