SQLite
SQLite
3.31.1

4.8

SQLite free download for Mac

SQLite

3.31.1
28 January 2020

SQL database connection development library.

Overview

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 currently found in more applications than we can count, including several high-profile projects. SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.

The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures. These features make SQLite a popular choice as an Application File Format. Think of SQLite not as a replacement for Oracle but as a replacement for fopen() If you need a GUI for database management, you can install NAVICAT. SQLite is a compact library. With all features enabled, the library size can be less than 300KiB, depending on compiler optimization settings. (Some compiler optimizations such as aggressive function inlining and loop unrolling can cause the object code to be much larger.) If optional features are omitted, the size of the SQLite library can be reduced below 180KiB.

SQLite can also be made to run in minimal stack space (4KiB) and very little heap (100KiB), making SQLite a popular database engine choice on memory constrained gadgets such as cellphones, PDAs, and MP3 players. There is a tradeoff between memory usage and speed. SQLite generally runs faster the more memory you give it. Nevertheless, performance is usually quite good even in low-memory environments.

What's new in SQLite

Version 3.31.1:
  • Revert the data layout for an internal-use-only SQLite data structure. Applications that use SQLite should never reference internal SQLite data structures, but some do anyhow, and a change to one such data structure in 3.30.0 broke a popular and widely-deployed application. Reverting that change in SQLite, at least temporarily, gives developers of misbehaving applications time to fix their code
  • Fix a typos in the sqlite3ext.h header file that prevented the sqlite3_stmt_isexplain() and sqlite3_value_frombind() interfaces from being called from run-time loadable extensions

Join over 500,000 subscribers.

Subscribe for our newsletter with best Mac offers from MacUpdate.

3 SQLite Reviews

Rate this app:

Derekcurrie
20 December 2018

Most helpful

WARNING! SQLite v3.25 and earlier have a critical vulnerability. UPDATE to v3.26+ IMMEDIATELY! v3.26 is the current version. More here:

"Cybersecurity researchers have discovered a critical vulnerability in widely used SQLite database software that exposes billions of deployments to hackers.

Dubbed as 'Magellan' by Tencent's Blade security team, the newly discovered SQLite flaw could allow remote attackers to execute arbitrary or malicious code on affected devices, leak program memory or crash applications...."

https://thehackernews.com/2018/12/sqlite-vulnerability.html
Like (1)
Version 3.25.0
Derekcurrie
20 December 2018
WARNING! SQLite v3.25 and earlier have a critical vulnerability. UPDATE to v3.26+ IMMEDIATELY! v3.26 is the current version. More here:

"Cybersecurity researchers have discovered a critical vulnerability in widely used SQLite database software that exposes billions of deployments to hackers.

Dubbed as 'Magellan' by Tencent's Blade security team, the newly discovered SQLite flaw could allow remote attackers to execute arbitrary or malicious code on affected devices, leak program memory or crash applications...."

https://thehackernews.com/2018/12/sqlite-vulnerability.html
Like (1)
Version 3.25.0
SickTeddyBear
21 September 2011
FYI, this listing now points to the official source at sqlite.org, and no longer has anything to do with Michael Tsai.
Like
Version 3.7.8
Anonymous
09 March 2004
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.
Like (1)
Version 2.8.13
8 answer(s)
Anonymous
Anonymous
09 March 2004
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.
Like (2)
Version 2.8.13
Anonymous
Anonymous
10 March 2004
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.
Like
Version 2.8.13
Anonymous
Anonymous
10 March 2004
By "build project," do you mean the Makefile? I wouldn't mind adding that to the .dmg.
Like
Version 2.8.13
Anonymous
Anonymous
11 March 2004
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.
Like
Version 2.8.13
Anonymous
Anonymous
11 March 2004
I'm using Make instead of Xcode or Project Builder, so there are no other files except the source archives.
Like (2)
Version 2.8.13
Anonymous
Anonymous
15 December 2004
Thank you for doing it Michael. It is beneficial to the Mac community and I appreciate it.
Like (4)
Version 2.8.13
Anonymous
Anonymous
10 August 2005
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.
Like (2)
Version 2.8.16
Hodagacz
Hodagacz
20 May 2011
Thanks Michael, I like the convenience.
Like (2)