| Version | Change log |
| SQLite Expert Profesional 3.52.0 Mar 6, 2026 |
Fix the WAL-reset database corruption bug. Enhance ALTER TABLE to permit adding and removing NOT NULL and CHECK constraints. Add the Query Result Formatter (QRF) library for formatting the results of SQL queries for human readability on a fixed-pitch font screen. Add the format method to the TCL Interface so that QRF is accessible from TCL. QRF is used for result formatting in the CLI, resulting in improved display capabilities. New built-in SQL functions: json_array_insert(), and jsonb_array_insert(). Renovations to the CLI: Major enhancements to the .mode command. Improved result formatting, due to the addition of the QRF extension. For example, numeric values are now right-justified by default in tabular output modes. The default output mode for interactive CLI sessions now uses QRF to display query results in boxes formed using Unicode box-drawing characters, for improved legibility. Batch CLI sessions use the legacy output format for compatibility. Bare (unquoted) semicolons at the end of dot-commands are silently ignored. ← Potential incompatibility! Fix the .testcase and .check commands so that they actually work, and use those commands in scripts that part of the standard SQLite test suite included with the source tree. Command-line arguments that match *.sql or *.txt and are the names of non-empty files are read and interpreted as scripts of SQL statements and/or dot-commands. The argument to the ".timer" command can now be "once", to run the timer on only the next SQL statement. The new "--timeout S" option to the ".progress" dot-command causes SQL statements to interrupt after S seconds. New C-language interfaces: sqlite3_str_truncate() sqlite3_str_free() sqlite3_carray_bind_v2() Add the SQLITE_PREPARE_FROM_DDL option to sqlite3_prepare_v3() which permits virtual table implementations to safely prepare SQL statements that are derived from the database schema. Added the SQLITE_UTF8_ZT constant which can be used |
| SQLite Expert Profesional 3.51.2 Jan 9, 2026 |
Fix an obscure deadlock in the new broken-posix-lock detection logic in item 17 above Fix multiple problems in the EXISTS-to-JOIN optimization that was added as part of optimization item 6b above Other minor bug fixes SQLITE_SOURCE_ID: 2026-01-09 17:27:48 b270f8339eb13b504d0b2ba154ebca966b7dde08e40c3ed7d559749818cb2075 SHA3-256 for sqlite3.c: 733b3fcc6cccb1e334424b9b91a9d68b618385b76ebfcbb106690bd3a9e61367 |
| SQLite Expert Profesional 3.51.1 Nov 28, 2025 |
Fix incorrect results from nested EXISTS queries caused by the optimization in item 6b in the 3.51.0 release. Fix a latent bug in fts5vocab virtual table, exposed by new optimizations in the 3.51.0 release |
Total downloads
84
Last month's downloads
1
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 ...
... latest addition to our arsenal of top-rated software, SQL Check by IDERA, Inc. This innovative tool is ... at ease when it comes to ensuring optimal database performance. SQL Check not only helps identify issues and potential ... also suggests corrective actions, providing you with a comprehensive solution. With user-friendly features and a flexible interface, ...