Download SQLite for Mac - SQL database connection development library. MacUpdate Mac Libraries Software Downloads

SQLite is a C library, written by D. Richard Hipp and others, that implements an imbeddable 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.

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.

OTHER PEOPLE SUGGEST

Helix RADE (votes: 1 )
MySQL (votes: 1 )

Suggest something else:

ANONYMOUS This is *not* an official version and thus shouldn't be taking the SQLite name. The author further doesn't provide their project so we can check that the build is unmodified. Use at your own risk.
(Version 2.8.13)

Replies:

Mar 9 2004

ANONYMOUS Yes, this is an unofficial version, just as the MySQL builds on MacUpdate and VersionTracker are unofficial, and have been for years.

The reason I posted this is that the standard "make; make test; make install" doesn't do what most people want on Mac OS X.

If you don't trust that it's unmodified, you can download the SQLite and readline source archives and build them for yourself. I don't see any point in including them on the .dmg file, though, since if you really doubt that this is the real SQLite, you wouldn't trust that I included the real source, either.
(Version 2.8.13)

Mar 10 2004

ANONYMOUS I think it's more about your willingness to supply the build project you used. As it stands, there is no way to audit that the binary downloaded is a clean SQLite build. You should either release your build project as a sign of good faith or change the name of your release so that it doesn't confuse people with the actual SQLite.
(Version 2.8.13)

Mar 10 2004

ANONYMOUS By "build project," do you mean the Makefile? I wouldn't mind adding that to the .dmg.
(Version 2.8.13)

Mar 11 2004

ANONYMOUS It means releasing *everything* necessary to make an identical copy of the binary files. If you truthfully haven't modified the SQLite source, you should be able to put up just the Xcode (or Project Builder) project files and tell them where to get and put the other source.
(Version 2.8.13)

Mar 11 2004

ANONYMOUS I'm using Make instead of Xcode or Project Builder, so there are no other files except the source archives.
(Version 2.8.13)

Dec 15 2004

ANONYMOUS Thank you for doing it Michael. It is beneficial to the Mac community and I appreciate it.
(Version 2.8.13)

Aug 10 2005

JERRY Note that as of 10.4, Mac OS X comes with sqlite3 in /usr/bin/sqlite3, and has the library for slite3 pre-installed also.
(Version 2.8.16)