|
- 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
- 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
- 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 application that accepts user input and passes it down into the SQLite library for evaluation Understand that these are two different things When somebody says "SQLite" or "sqlite3" they might be referring to either
- 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
- 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
- Implementation Limits For SQLite
Limits In SQLite "Limits" in the context of this article means sizes or quantities that can not be exceeded We are concerned with things like the maximum number of bytes in a BLOB or the maximum number of columns in a table SQLite was originally designed with a policy of avoiding arbitrary limits Of course, every program that runs on a machine with finite memory and disk space has limits of
- 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
|
|
|