SQLite for Mac

Developer's Description

SQLite is a C library, written by D. Richard Hipp and others, that implements an embeddable SQL database engine. Programs that link with the SQLite library can have SQL database access without running a separate RDBMS process. The 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.

SQLite is not a client library used to connect to a big database server. SQLite is the server. The SQLite library reads and writes directly to and from the database files on disk.

SQLite is used by Mac OS X software such as NetNewsWire and SpamSieve.

When you download SQLite and build it on a stock Mac OS X system, the sqlite tool has a very primitive command-line editing facility. This build of sqlite uses the GNU readline library, which provides fancy command-line editing (using, e.g. Emacs key bindings) as well as a command history. Software built using the included libsqlite.a library does not link with readline and thus is not tainted by the GPL.

Full Specifications

What's new in version 2.8.16

  • Fix a bug that can lead to database corruption if there are two open connections to the same database and one connection does a VACUUM and the second makes some change to the database.
  • Correctly handle quoted names in CREATE INDEX statements.
  • Fix a naming conflict between sqlite.h and sqlite3.h.
  • Avoid excess heap usage when copying expressions.
  • Other minor bug fixes.
  • Official change list.

General

Release August 25, 2008
Date Added August 10, 2005
Version 2.8.16

Operating Systems

Operating Systems Mac OS X 10.4 PPC, Macintosh, Mac OS X 10.3, Mac OS X 10.2, Mac OS X 10.3.9, Mac OS X 10.1
Additional Requirements Mac OS X 10.1

Popularity

Total Downloads 5,128
Downloads Last Week 4
Report Software

Related Software

Adobe AIR

Free
Adobe AIR

JavaScript OSA

Free
JavaScript OSA
SvnX logo

SvnX

Free
SvnX

SCPlugin

Free
SCPlugin
Promo image for CNET Shopping

Get the best price on everything

Shop your favorite products and we’ll find the best deal with a single click. Designed to make shopping easier.