| Version | Change log |
| SQLite Expert Profesional 3.48.0 Jan 14, 2025 |
Refactor the "configure" script used to help build SQLite from canonical sources, to fix bugs, improve performance, and make the code more maintainable: This does not affect the "configure" script in the sqlite3-autoconf-NNNNNNN.tar.gz "amalgamation tarball", only the canonical sources. The build system for the amalgamation tarball is unchanged. If you are using the amalgamation tarball, nothing about this change log entry applies to you. The key innovation here is that Autosetup is now used instead of GNU Autoconf. That seems like a big change, but it is really just an implementation detail. The ./configure script is coded very differently, but should work the same as before. One advantage of the new configure is that you no longer need to install TCL in order to build most SQLite targets. TCL is still required to run tests or to build accessory programs (like sqlite3_analyzer) that use TCL, but it is not required for most common targets. Hence, as of this release, the only build dependencies are a C compiler and "make" or "nmake". Improved EXPLAIN QUERY PLAN output for covering indexes. Allow a two-argument version of the iif() SQL function. Also allow if() as an alternative spelling for iif(). Add the ".dbtotxt" command to the CLI. Add the SQLITE_IOCAP_SUBPAGE_READ property to the xDeviceCharacteristics method of the sqlite3_io_methods object. Add the SQLITE_PREPARE_DONT_LOG option to sqlite3_prepare_v3() that prevents warning messages being sent to the error log if the SQL is ill-formed. This allows sqlite3_prepare_v3() to be used to do test compiles of SQL to check for validity without polluting the error log with false messages. Increase the minimum allowed value of SQLITE_LIMIT_LENGTH from 1 to 30. Added the SQLITE_FCNTL_NULL_IO file control. Extend the FTS5 auxiliary API xInstToken() to work with prefix queries via the insttoken configuration option and the fts5_insttoken() SQL function. Increase th |
| SQLite Expert Profesional 3.47.2 Dec 8, 2024 |
Fix a problem in text-to-floating-point conversion for SQLite that can cause values between '1.8446744073709550592eNNN' and '1.8446744073709551609eNNN' for any exponent NNN to be rendered incorrectly. In other words, some numeric text values where the first 16 significant digits are '1844674407370955' might be converted into the wrong floating-point value. See forum thread 569a7209179a7f5e. This problem only arises on x64 and i386 hardware. The problem was introduced in 3.47.0. Other minor bug fixes. |
| SQLite Expert Profesional 3.47.1 Nov 25, 2024 |
Fix the makefiles so that they once again honored DESTDIR for the "install" target. Add the SQLITE_IOCAP_SUBPAGE_READ capability to the VFS, to work around issues on some non-standard VFSes caused by making SQLITE_DIRECT_OVERFLOW_READ the default in version 3.45.0. Fix problems with line endings in the new sqlite3_rsync.exe utility on Windows. Fix incorrect answers to certain obscure IN queries caused by new query optimizations added in the 3.47.0 release. Other minor bug fixes. |
Total downloads
32
Last month's downloads
0
Last week's downloads
0
... latest addition in the software category - Active Table Editor. Developed by DB Software Laboratory Limited, this software ... allows users to edit any table in any database with ease. The intuitive user interface makes it ... an individual, small business owner or corporation, Active Table Editor can help streamline your data editing process and ...
... Download Club is pleased to introduce the revolutionary SQL DataTool from SQL DataTool. Designed to handle various tasks, including SQL backup, restore, and import/export data, SQL DataTool is the ultimate solution for every SQL user. Its user-friendly interface and exceptional features make ...
Discover the power of seamless database management with Database .NET Professional, a cutting-edge software solution developed by ... professionals, offering an intuitive interface that simplifies complex database tasks. With support for a wide range of database systems, including SQL Server, MySQL, Oracle, and SQLite, ...
