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

SQLite 3.16.0

January, 3rd 2017 - 1.77 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-3160000.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.0.

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.0

SQLite 3.16.0 Screenshots

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

What's new in this version:

- Uses 9% fewer CPU cycles. (See the CPU performance measurement report for details on how the this performance increase was computed.)
- Added experimental support for PRAGMA functions
- Added the SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE option to sqlite3_db_config()
- Enhance the date and time functions so that the 'unixepoch' modifier works for the full span of supported dates
- Changed the default configuration of the lookaside memory allocator from 500 slots of 128 bytes each into 125 slots of 512 bytes each
- Enhanced "WHERE x NOT NULL" partial indexes so that they are usable if the "x" column appears in a LIKE or GLOB operator
- Enhanced sqlite3_interrupt() so that it interrupts checkpoint operations that are in process
- Enhanced the LIKE and GLOB matching algorithm to be faster for cases when the pattern contains multiple wildcards
- Added the SQLITE_FCNTL_WIN32_GET_HANDLE file control opcode
- Added ".mode quote" to the command-line shell
- Added ".lint fkey-indexes" to the command-line shell
- Added the .imposter dot-command to the command-line shell
- Added the remember(V,PTR) SQL function as a loadable extension
- Rename the SQLITE_OMIT_BUILTIN_TEST compile-time option to SQLITE_UNTESTABLE to better reflect the implications of using it

Bug Fixes:
- Fix a long-standing bug in the query planner that caused incorrect results on a LEFT JOIN where the left-hand table is a subquery and the join constraint is a bare column name coming from the left-hand subquery. Ticket 2df0107b
- Correctly handle the integer literal -0x8000000000000000 in the query planner