-
Latest Version
-
Operating System
Mac OS X
-
User Rating
Click to vote -
Author / Product
-
Filename
sqlite-tools-osx-x86-3150000.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.15.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!
What's new in this version:
- Added support for row values
- Allow deterministic SQL functions in the WHERE clause of a partial index
- Added the "modeof=filename" URI parameter on the unix VFS
- Added support for SQLITE_DBCONFIG_MAINDBNAME
- Added the ability to VACUUM an ATTACH-ed database
Enhancements to the command-line shell:
- Add the ".testcase" and ".check" dot-commands
- Added the --new option to the ".open" dot-command, causing any prior content in the database to be purged prior to opening
- Enhance the fts5vocab virtual table to handle "ORDER BY term" efficiently
- Miscellaneous micro-optimizations reduce CPU usage by more than 7% on common workloads. Most optimization in this release has been on the front-end (sqlite3_prepare_v2()).
Bug Fixes:
- The multiply operator now correctly detects 64-bit integer overflow and promotes to floating point in all corner-cases. Fix for ticket 1ec41379c9c1e400.
- Correct handling of columns with redundant unique indexes when those columns are used on the LHS of an IN operator. Fix for ticket 0eab1ac759.
- Skip NULL entries on range queries in indexes on expressions. Fix for ticket 4baa46491212947.
- Ensure that the AUTOINCREMENT counters in the sqlite_sequence table are initialized doing "Xfer Optimization" on "INSERT ... SELECT" statements. Fix for ticket 7b3328086a5c116c.
- Make sure the ORDER BY LIMIT optimization (from check-in 559733b09e) works with IN operators on INTEGER PRIMARY KEYs. Fix for ticket 96c1454c
- OperaOpera 115.0 Build 5322.77
- PhotoshopAdobe Photoshop CC 2024 25.12
- OKXOKX - Buy Bitcoin or Ethereum
- BlueStacksBlueStacks Air 5.21.650
- Adobe AcrobatAdobe Acrobat Pro 2024.005.20320
- TradingViewTradingView - Track All Markets
- ParallelsParallels Desktop 20.1.2
- 4K Video4K Video Downloader+ 1.10.3
- CleanMyMacCleanMyMac X 5.0.3
- 4DDiG4DDiG Mac Data Recovery 5.2.2
Comments and User Reviews