-
Latest Version
-
Operating System
Mac OS X
-
User Rating
Click to vote -
Author / Product
-
Filename
sqlite-tools-osx-x86-3330000.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.33.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:
- Support for UPDATE FROM following the PostgreSQL syntax
- Increase the maximum size of database files to 281 TB
- Extended the PRAGMA integrity_check statement so that it can optionally be limited to verifying just a single table and its indexes, rather than the entire database file
- Added the decimal extension for doing arbitrary-precision decimal arithmetic
- Enhancements to the ieee754 extension for working with IEEE 754 binary64 numbers
CLI enhancements:
- Added four new output modes: "box", "json", "markdown", and "table"
- The "column" output mode automatically expands columns to contain the longest output row and automatically turns ".header" on if it has not been previously set
- The "quote" output mode honors ".separator"
- The decimal extension and the ieee754 extension are built-in to the CLI
Query planner improvements:
- Add the ability to find a full-index-scan query plan for queries using INDEXED BY which previously would fail with "no query solution"
- Do a better job of detecting missing, incomplete, and/or dodgy sqlite_stat1 data and generates good query plans in spite of the misinformation
- Improved performance of queries like "SELECT min(x) FROM t WHERE y IN (?,?,?)" assuming an index on t(x,y)
- In WAL mode, if a writer crashes and leaves the shm file in an inconsistent state, subsequent transactions are now able to recover the shm file even if there are active read transactions. Before this enhancement, shm file recovery that scenario would result in an SQLITE_PROTOCOL error
- AvastAvast Mac Security
- PhotoshopAdobe Photoshop CC 2024 25.12
- OperaOpera 114.0 Build 5282.94
- Hero WarsHero Wars - Online Action Game
- Adobe AcrobatAdobe Acrobat Pro 2024.002.20854
- TradingViewTradingView - Track All Markets
- ParallelsParallels Desktop 20.1.0
- 4K Video4K Video Downloader+ 1.9.1
- CleanMyMacCleanMyMac X 4.15.8
- 4DDiG4DDiG Mac Data Recovery 5.2.2
Comments and User Reviews