Self-contained, embeddable, zero-configuration SQL database engine

SQLite 3.16.2

January, 7th 2017 - 1.1 MB - Freeware

Free Download

Security Status

Latest Version

SQLite 3.45.3
Operating System

Mac OS X
User Rating

Click to vote
Author / Product

Richard Hipp / External Link
Filename

sqlite-tools-osx-x86-3160200.zip

Sometimes latest versions of the software can cause issues when installed on older devices or devices running an older version of the operating system. Software makers usually fix these issues but it can take them some time. What you can do in the meantime is to download and install an older version of SQLite 3.16.2.

For those interested in downloading the most recent release of SQLite for Mac or reading our review, simply click here.

All old versions distributed on our website are completely virus-free and available for download at no cost.

We would love to hear from you

If you have any questions or ideas that you want to share with us - head over to our Contact page and let us know. We value your feedback!

Download SQLite 3.16.2

SQLite 3.16.2 Screenshots

The images below have been resized. Click on them to view the screenshots in full size.

What's new in this version:

- Fix the REPLACE statement for WITHOUT ROWID tables that lack secondary indexes so that it works correctly with triggers and foreign keys. This was a new bug caused by performance optimizations added in version 3.16.0. Ticket 30027b613b4
- Fix the sqlite3_value_text() interface so that it correctly translates content generated by zeroblob() into a string of all 0x00 characters. This is a long-standing issue discovered after the 3.16.1 release by OSS-Fuzz
- Fix the bytecode generator to deal with a subquery in the FROM clause that is itself a UNION ALL where one side of the UNION ALL is a view that contains an ORDER BY. This is a long-standing issue that was discovered after the release of 3.16.1. See ticket 190c2507.
- Adjust the sqlite3_column_count() API so it more often returns the same values for PRAGMA statements as it did in prior releases, to minimize disruption to applications that might be using that interface in unexpected ways.