-
Latest Version
-
Operating System
Mac OS X
-
User Rating
Click to vote -
Author / Product
-
Filename
sqlite-tools-osx-x86-3430000.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.43.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:
- Add support for Contentless-Delete FTS5 Indexes. This is a variety of FTS5 full-text search index that omits storing the content that is being indexed while also allowing records to be deleted.
- Added the octet_length(X) SQL function
- Added the sqlite3_stmt_explain() API
- Performance enhancements to JSON processing results in a 2x performance improvement for some kinds of processing on large JSON strings
- New makefile target "verify-source" checks to ensure that there are no unintentional changes in the source tree. (Works for canonical source code only - not for precompiled amalgamation tarballs.)
- Added the SQLITE_USE_SEH compile-time option that enables Structured Exception Handling on Windows while working with the memory-mapped shm file that is part of WAL mode processing. This option is enabled by default when building on Windows using Makefile.msc.
- The VFS for unix now assumes that the nanosleep() system call is available unless compiled with -DHAVE_NANOSLEEP=0
Enhancements to the date and time functions:
- Added new time shift modifiers of the form ±YYYY-MM-DD HH:MM:SS.SSS
- Added the timediff() SQL function
Query planner enhancements:
- Generalize the LEFT JOIN strength reduction optimization so that it works for RIGHT and FULL JOINs as well. Rename it to OUTER JOIN strength reduction
- Enhance the theorem prover in the OUTER JOIN strength reduction optimization so that it returns fewer false-negatives
Enhancements to the decimal extension:
- New function decimal_pow2(N) returns the N-th power of 2 for integer N between -20000 and +20000
- New function decimal_exp(X) works like decimal(X) except that it returns the result in exponential notation - with a "e+NN" at the end
- If X is a floating-point value, then the decimal(X) function now does a full expansion of that value into its exact decimal equivalent
- OperaOpera 115.0 Build 5322.109
- PhotoshopAdobe Photoshop CC 2024 25.12
- OKXOKX - Buy Bitcoin or Ethereum
- BlueStacksBlueStacks Air 5.21.650
- Adobe AcrobatAdobe Acrobat Pro 2024.005.20320
- Hero WarsHero Wars - Online Action Game
- ParallelsParallels Desktop 20.1.3
- 4K Video4K Video Downloader+ 1.10.3
- CleanMyMacCleanMyMac X 5.0.3
- 4DDiG4DDiG Mac Data Recovery 5.2.2
Comments and User Reviews