SQLite 3.3.8
SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.
Here are some ke
SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.
Here are some key features of "SQLite":
Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.
Zero-configuration - no setup or administration needed.
Implements most of SQL92. (Features not supported)
A complete database is stored in a single disk file.
Database files can be freely shared between machines with different byte orders.
Supports databases up to 2 terabytes (241 bytes) in size.
Sizes of strings and BLOBs limited only by available memory.
Small code footprint: less than 30K lines of C code, less than 250KB code space (gcc on 486)
Faster than popular client/server database engines for most common operations.
Simple, easy to use API.
TCL bindings included. Bindings for many other languages available separately.
Well-commented source code with over 95% test coverage.
Self-contained: no external dependencies.
Sources are in the public domain. Use for any purpose.
The SQLite distribution comes with a standalone command-line access program (sqlite) that can be used to administer an SQLite database and which serves as an example of how to use the SQLite library.
Create A New Database:
At a shell or DOS prompt, enter: "sqlite3 test.db". This will create a new database named "test.db". (You can use a different name if you like.)
Enter SQL commands at the prompt to create and populate the new database.
Write Programs That Use SQLite
Below is a simple TCL program that demonstrates how to use the TCL interface to SQLite. The program executes the SQL statements given as the second argument on the database defined by the first argument. The commands to watch for are the sqlite3 command on line 7 which opens an SQLite database and creates a new TCL command named "db" to access that database, the invocation of the db command on line 8 to execute SQL commands against the database, and the closing of the database connection on the last line of the script.
#!/usr/bin/tclsh
if {$argc!=2} {
puts stderr "Usage: %s DATABASE SQL-STATEMENT"
exit 1
}
load /usr/lib/tclsqlite3.so Sqlite3
sqlite3 db [lindex $argv 0]
db eval [lindex $argv 1] x {
foreach v $x(*) {
puts "$v = $x($v)"
}
puts ""
}
db close
tags
the database new database database and sql commands zero configuration lindex argv less than use the sqlite database self contained the sqlite
Download SQLite 3.3.8
http://www.sqlite.org/sqlite-3.3.8.tar.gz
Authors software
Similar software
|
 SQLite 3.3.8 (by  D. Richard Hipp)
SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.
Here are some ke
|
|
DBD::SQLite 1.12 (by Matt Sergeant)
DBD::SQLite is a Self Contained RDBMS in a DBI Driver.
SYNOPSIS
use DBI;
my $dbh = DBI->connect("dbi:SQLite:dbname=dbfile"
|
|
Lua-Sqlite3 0.4 (by Michael Roth)
Lua-Sqlite3 project is a binding of Sqlite3 for Lua.
Lua-Sqlite3 is unique in contrast to other database bindings that it consists
|
|
libdbi-drivers 0.8.1 (by David Parker)
libdbi implements a database-independent abstraction layer in C, similar to the DBI/DBD layer in Perl.
Writing one generic set of
|
|
Libsqlfs 1.0 (by Andy Tai)
Libsqlfs is a library, used in conjunction with the popular open source SQLite database software
|
|
sqlitewrapped 1.3 (by Anders Hedstrom)
sqlitewrapped is a C++ wrapper for the Sqlite database C application programming interface.
The code works for linux/unix, as well
|
|
LiteMan 0.2 (by Igor Khanin)
LiteMan is a simple GUI database manager for the SQLite embeded database engine version 3
|
|
pgets 0.1 (by Lennart Poettering)
pgets is a simple Linux tool for reading stored call accounting data from Auerswald ETS 4308i PBX over a serial line into SQLite or P
|
Other software in this category
|
Berkeley DB 4.5.20 (by Oracle)
Berkeley DB (libdb) is a programmatic toolkit that provides embedded database support for both traditional and client/server applicat
|
|
SQLite 3.3.8 (by D. Richard Hipp)
SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.
Here are some ke
|
|
gdbm 1.8.3 (by Phil Nelson)
gdbm is a database indexing library replacement for the traditional 'dbm' and 'ndbm' libraries
|
Featured Software
jEdit 4.3 pre8
jEdit is an Open Source text editor written in Java
Opera 9.02
Surf the Internet in a safer, faster, and easier way with Opera browser
GNU Aspell 0.60.4
GNU Aspell is a Free and Open Source spell checker designed to eventually replace Ispell
0.00 
Public Domain
0K
RSS
