3.4.14 released

Posted on 16 January 2025

This version brings some SQL syntax support enhancements (UPDATE/DELETE/INSERT with aliases, ordering and limiting) and another set of bugfixes.

  • Enhanced SQL syntax support:
    • Added optional ORDER BY and LIMIT clauses to UPDATE and DELETE statements.
    • Enabled the use of the AS clause in INSERT, UPDATE, and DELETE statements.
    • Resolved syntax error for INDEXED BY.
    • Code Assistant: Improved column prioritization for UPDATE suggestions.
    • Fixed issues with SELECT queries containing subselects that use the * operator to ensure correct results.
    • Addressed execution and editability of complex SELECT queries involving subselects, joined tables, and mixed alias usage. These now run properly using Smart Execution.
    • Corrected formatting when configured to avoid whitespace before binary operators, particularly with the AND keyword.
  • Database list item selection is now retained between sessions, saved in the configuration file, and restored on the next app start.
  • The hex editor dialog now remembers user-defined size.
  • Backported improvements for ScriptingPython, enabling Python version selection via the qmake parameter.

Full ChangeLog.

3.4.13 released

Posted on 28 December 2024

Incremental bugfix release, focused on completer (the code assistant) fixes.

  • Resolved an issue where the completer did not provide proper proposals for column names in the INSERT INTO statement.
  • Addressed a problem where the completer failed to display tables from implicitly attached databases in the case of SELECT other_database.
  • System tables (sqlite_*) are now deprioritized in completer proposals.
  • Restored missing completer entries for string, number, and BLOB literals.
  • Fixed Linux installer issue related to the logname command on some Linux distributions.

3.4.12 released

Posted on 22 December 2024

Incremental bugfix release.

Changes:

  • Resolved issue where queries joining the same table twice returned incorrect results.
  • Addressed issue with smart execution for queries using the USING clause in joins, ensuring proper metadata extraction and enabling result editing.

3.4.11 released

Posted on 20 December 2024

Incremental bugfix release.

Changes:

  • SQLite updated to 3.47.2.
  • Dialog windows now stay fully visible on screen in any case.
  • "Rows Affected" counter correctly supports values over 2 trillion.

Full ChangeLog.

3.4.10 released

Posted on 11 December 2024

Yet another set of bugs fixed and also one enhancement.

Changes:

  • The taskbar has been updated to make the currently active task more visually distinct, improving clarity and ease of navigation.
  • Resolved an issue that affected the correct counting of tables in queries when other databases were attached transparently.
  • Fixed a critical issue that caused the application to crash when enabling the STRICT option in the Table Window.
  • Dialog window positions are now correctly remembered when moved, even if not resized, ensuring a smoother user experience.
  • System Tables Visibility: System tables are once again displayed in the database list if the application is configured to do so.

3.4.9 released

Posted on 06 December 2024

Version 3.4.9 introduces two bug fixes. One is quite important.

Changes:

  • Resolved an issue where queries referencing tables with database prefixes (e.g., dbName.tableName) could fail to execute correctly.
  • Relaxed the restriction on requiring Custom SQL Functions to have unique names, now allowing duplicate names as long as input parameters differ.
  • Binaries for macOS are now built on macOS 13, as macOS 12 is no longer available on GitHub Actions for CI/CD workflows.

3.4.8 released

Posted on 01 December 2024

This hotfix release addresses few issues to enhance stability and usability.

Changes:

  • Fixed crash in Extensions Manager when the percentile extension was loaded (this issue was due to corruption in SQLite 3.46.x, which, although fixed in later versions, was not included in SQLite 3.47.1 source code package).
  • A warning is now displayed when a relative file path is entered in Database Dialog, showing the resolved absolute path.
  • Resolved issue with the Extensions Manager commit button not working after all extensions were removed.

3.4.7 released!

Posted on 29 November 2024

I'm excited to announce the latest version of SQLiteStudio! This update brings several important bug fixes and upgrades SQLite to its latest version (3.47.1).

Notable bug fixes:

  • Wayland Compatibility on Modern Linux Systems. Resolved an issue where the Linux binary downloaded from https://sqlitestudio.pl failed to run on modern Fedora or any Linux distribution that operates exclusively with Wayland as its X server.
  • Improved import() SQL Function Performance. Addressed the extremely poor performance of the import() SQL function when used in SQL queries, offering a significant speed boost.
  • Enhanced Performance with Large Tables. Optimized the application to handle massive tables more efficiently, whether due to a high number of rows or large data values in individual cells.
  • Quicker Application Exit. Fixed a problem where the application would hang in the background for up to a minute after being closed. This delay, caused by issues with WAL journaling and concurrent database access by another application, prevented users from restarting SQLiteStudio immediately.

For the full list of changes, please refer to the ChangeLog.

3.4.6 released!

Posted on 23 November 2024

It's a hotfix release to address urgent problem of "black SQL code line" that appeared in 3.4.5. It also gets two more issues resolved.

Apart from the mentioned "black line" bugfix, there are following 2 issues fixed:

  • Compiling ScriptingPlugin against Python 3.11.
  • Proper support for editing results of SELECT with inline subquery as result column.

3.4.5 released!

Posted on 20 November 2024

A lot of bugs got fixed + few small additions.

Most notable fixes and additions:

  • Extension-based collations (like the ICU) can be now registered in databases using Collations Editor window.
  • Added support for explicit column names syntax in CREATE VIEW.
  • Data cell focus and current data page is maintained during data reload.
  • When trying to load SQLite database as SQL script into SQL Editor window, application detects it and opens Database dialog for that file instead. It has been notorious that users tried to open database with Ctrl-O/Cmd-O from SQL Editor window (which is for loading SQL script file), which caused SQL Editor to choke on big binary files. Now the editor will detect such attempt and redirect user to the Add Database dialog.
  • Improved performance of SQL Editor when working with huge SQL contents.
  • Bunch of SchemaResolver optimizations, resulting in huge performance boost when opening/modifying databases with thousands of tables (from minutes down to milliseconds for opening database with ~6000 tables!).
  • The Database dialog is changed slightly. Now it has an explicit choice whether user wants to create a new database, or to open an existing one. This allows the application to go back using the native file dialog for each operating system and maintain the integrity of user intentions (which was not previously possible with native dialogs). Thanks to @tuffnatty for this big contribution!
  • More bugfixes and features... full list is available as always in the ChangeLog.