
	Where results make sense

Topic: SQLite

Related Topics

Structured Query Language

Usenet

Jerry Zucker

Sam Donaldson

Pocket

Curacao

New York, New York

METRO AG

Sulphur

Morello cherry

Play (play)

Water turbine

Coesite

Duchy

Hephaestion

In the News (Sun 15 Nov 09)

Northern Trust

Marvin Harrison

Peter Chernin

Gary Locke

Match Play

Penelope Cruz

Mickey Rourke

AR Rahman

Danny Boyle

Hugh Jackman

	sqlite3: A command-line access program for SQLite databases
		The SQLite library includes a simple command-line utility named sqlite3 that allows the user to manually enter and execute SQL commands against an SQLite database.
		The database schema in an SQLite database is stored in a special table named "sqlite_master".
		SQLite commands are normally terminated by a semicolon.
	www.sqlite.org /sqlite.html (2024 words)

	Zend Developer Zone \| SQLite Introduction
		SQLite is an embedded database library that implements a large subset of the SQL 92 standard.
		SQLite also supports a flexible mechanism for passing database resources in the procedural interfaces, making it equally easy to switch from MySQL, where the resource is passed last, and PostgreSQL, where it is passed first.
		SQLite also features a powerful OO interface that can be used to efficiently retrieve data from a database, saving you from having to implement your own OO wrappers around the procedural interface.
	devzone.zend.com /node/view/id/760 (2701 words)

	Sqlite API (Site not responding. Last check: 2007-10-15)
		A shorter description of the API is at The C language interface to the SQLite library.
		SQLite allows two or more threads to read the database at the same time, but only one thread can have the database open for writing at the same time.
		The SQLite printf routines automatically allocate (and later frees) as much memory as is necessary to hold the SQL statements generated.
	web.utk.edu /~jplyon/sqlite/sqlite_api.html (7459 words)

	SQLite Optimization FAQ (Site not responding. Last check: 2007-10-15)
		SQLite loads these pages into memory when working with the database, with some additional structures to keep track of them.
		Note that SQLite obtains a write lock on the database file when a transaction is open, so when accessing the same database on multiple threads you have to be careful not to starve some of the threads.
		SQLite uses a separate "journal" file to provide the ability to roll back a transaction in case of a failure.
	web.utk.edu /~jplyon/sqlite/SQLite_optimization_FAQ.html (4281 words)

Try your search on: Qwika (all wikis)