News

3.4.15 released

Posted on 16 January 2025

This hotfix release addresses a significant bug introduced in version 3.4.14.

Changes:

  • Resolved an issue with Drag & Drop functionality in the database list, introduced in version 3.4.14. This bug prevented users from reordering databases, reorganizing databases within folders, and copying or moving tables and views between databases.
  • Fixed the Query Executor to utilize the Smart Execution Method when a Virtual Table is referenced in the query. This ensures that all advanced features of the Query Executor, such as implicit database attachment and inline result editing, are fully enabled for queries involving Virtual Tables.

Full ChangeLog.


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.