|
- 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 Documentation
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 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 "
- 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
- 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
- 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
- Distinctive Features Of SQLite
Distinctive Features Of SQLite This page highlights some of the characteristics of SQLite that are unusual and which make SQLite different from many other SQL database engines Zero-Configuration SQLite does not need to be "installed" before it is used There is no "setup" procedure There is no server process that needs to be started, stopped, or configured There is no need for an
|
|
|