-
Latest Version
-
Operating System
Mac OS X
-
User Rating
Click to vote -
Author / Product
-
Filename
sqlite-tools-osx-x86-3190000.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.19.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:
- The SQLITE_READ authorizer callback is invoked once with a column name that is an empty string for every table referenced in a query from which no columns are extracted
- When using an index on an expression, try to use expression values already available in the index, rather than loading the original columns and recomputing the expression
- Enhance the flattening optimization so that it is able to flatten views on the right-hand side of a LEFT JOIN
- Use replace() instead of char() for escaping newline and carriage-return characters embedded in strings in the .dump output from the command-line shell
- Avoid unnecessary foreign key processing in UPDATE statements that do not touch the columns that are constrained by the foreign keys
- On a DISTINCT query that uses an index, try to skip ahead to the next distinct entry using the index rather than stepping through rows, when an appropriate index is available
- Avoid unnecessary invalidation of sqlite3_blob handles when making changes to unrelated tables
- Transfer any terms of the HAVING clause that use only columns mentioned in the GROUP BY clause over to the WHERE clause for faster processing
- Reuse the same materialization of a VIEW if that VIEW appears more than once in the same query
- Enhance PRAGMA integrity_check so that it identifies tables that have two or more rows with the same rowid
- Enhance the FTS5 query syntax so that column filters may be applied to arbitrary expressions
- Enhance the json_extract() function to cache and reuse parses of JSON input text
- Added the anycollseq.c loadable extension that allows a generic SQLite database connection to read a schema that contains unknown and/or application-specific collating sequences
Bug Fixes:
- Fix a problem in REPLACE that can result in a corrupt database containing two or more rows with the same rowid. Fix for ticket f68dc596c4e6018d
- Fix a problem in PRAGMA integrity_check that was causing a subsequent VACUUM to behave suboptimally
- Fix the PRAGMA foreign_key_check command so that it works correctly with foreign keys on WITHOUT ROWID tables
- Disallow leading zeros in numeric constants in JSON. Fix for ticket b93be8729a895a528e2
- Disallow control characters inside of strings in JSON. Fix for ticket 6c9b5514077fed34551
- Limit the depth of recursion for JSON objects and arrays in order to avoid excess stack usage in the recursive descent parser. Fix for ticket 981329adeef51011052
- 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