SQLite
SQLite
3.29.0

4.8

SQLite

SQLite

3.29.016 July 2019

SQL database connection development library.

SQLite
Free
16 July 2019

4.8

See all reviews (6)
DownloadMacUpdateInstall with MacUpdate

Downloaded and installed 16,460 times

Category:

Development

Libraries

Developer Website:
SQLite

SQLite

3.29.016 July 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.29.0:
  • Added the SQLITE_DBCONFIG_DQS_DML and SQLITE_DBCONFIG_DQS_DDL actions to sqlite3_db_config() for activating and deactivating the double-quoted string literal misfeature. Both default to "on" for legacy compatibility, but developers are encouraged to turn them "off", perhaps using the -DSQLITE_DQS=0 compile-time option
  • -DSQLITE_DQS=0 is now a recommended compile-time option
  • Improvements to the query planner:
    • Improved optimization of AND and OR operators when one or the other operand is a constant
    • Enhancements to the LIKE optimization for cases when the left-hand side column has numeric affinity
  • Added the "sqlite_dbdata" virtual table for extracting raw low-level content from an SQLite database, even a database that is corrupt
  • Enhancements to the CLI:
    • Add the ".recover" command which tries to recover as much content as possible from a corrupt database file
    • Add the ".filectrl" command useful for testing
    • Add the long-standing ".testctrl" command to the ".help" menu
    • Added the ".dbconfig" command

Requirements for SQLite

  • Mac OS X 10.4.11 or later

6 Reviews

Rate this app:

09 March 2004

Most helpful

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
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
Version 3.25.0
07 June 2018
Like
Version 3.24.0
10 December 2013
Like
Version 3.8.2
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
20 May 2011
Like
Version 3.7.6.3
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
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
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
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
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
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
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
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
20 May 2011
Thanks Michael, I like the convenience.
Like (2)
Free

4.8

Category:

Development

Libraries

Developer Website:
DownloadMacUpdateInstall with MacUpdate

Downloaded & Installed 16,460 times

Free

4.8

Category:

Development

Libraries

Developer Website:
DownloadMacUpdateInstall with MacUpdate

Downloaded & Installed 16,460 times

Don't like new MacUpdate? Back to old design.

6 Reviews

Rate this app:

09 March 2004

Most helpful

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
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
Version 3.25.0
07 June 2018
Like
Version 3.24.0
10 December 2013
Like
Version 3.8.2
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
20 May 2011
Like
Version 3.7.6.3
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
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
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
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
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
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
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
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
20 May 2011
Thanks Michael, I like the convenience.
Like (2)