|
- SQLite Home Page
What Is SQLite? 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 is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day
- SQLite Download Page
A bundle of command-line tools for managing SQLite database files, including (1) the command-line shell, (2) sqldiff, (3) sqlite3_analyzer, and (4) sqlite3_rsync (64-bit) (SHA3-256: 58352ee49880019efaba4fc8c6470c3a700e6ddd5e0d56310c64fdfc0cef44df) Precompiled Binaries for Windows: sqlite-dll-win-x86-3500100 zip (1 02 MiB)
- Documentation - SQLite
Remote Copy Of A Live Database → The sqlite3_rsync program makes a consistent copy of a live database to or from a remote system Database Hash (dbhash exe) → This program demonstrates how to compute a hash over the content of an SQLite database
- SQLite In 5 Minutes Or Less
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
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 is the most widely deployed database in the world with more applications than we can count, including several high-profile projects
- Command Line Shell For SQLite
The SQLite project provides a simple command-line program named sqlite3 (or sqlite3 exe on Windows) that allows the user to manually enter and execute SQL statements against an SQLite database or against a ZIP archive
- An Introduction To The SQLite C C++ Interface
sqlite3_prepare() → Compile SQL text into byte-code that will do the work of querying or updating the database The constructor for sqlite3_stmt sqlite3_bind() → Store application data into parameters of the original SQL sqlite3_step() → Advance an sqlite3_stmt to the next result row or to completion
- Query Language Understood by SQLite
The routines sqlite3_prepare_v2(), sqlite3_prepare(), sqlite3_prepare16(), sqlite3_prepare16_v2(), sqlite3_exec(), and sqlite3_get_table() accept an SQL statement list (sql-stmt-list) which is a semicolon-separated list of statements
|
|
|