SQLite
SQLite
3.30.1

4.8

SQLite free download for Mac

SQLite

3.30.1
11 October 2019

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.30.1:
  • Fix a bug in the query flattener that might cause a segfault for nested queries that use the new FILTER clause on aggregate functions.
  • Cherrypick fixes for other obscure problems found since the 3.30.0 release

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)
Free

4.8

App requirements: 
  • Intel 32
  • Mac OS X 10.4.11 or later
Developer Website: 
Download(2.4 MB)MacUpdateInstall with MacUpdate

Downloaded & Installed 16,567 times