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.

3.4.4 released!

Posted on 06 April 2023

Mostly important bugfixes, but also few new things.

  • Added ICU extension, shipped with binary packages (thanks to @tuffnatty)
  • Syntax highlighting is now responsive to day/night automatic changes made by the OS (if syntax colors are set to default).
  • Fixed a very common bug with query execution, manifesting itself usually with the "near ")": syntax error" message .
  • SQLite updated to 3.41.2
  • More bugfixes... full list is available as always in the ChangeLog.

3.4.3 released!

Posted on 19 January 2023

A quick release with just few bugfixes.

Linux binaries are build on Ubuntu 20.04 (in oppose to versions 3.4.0 - 3.4.2, which were built on Ubuntu 22.04), which enables these binaries to be run on both Ubutnu 22.04 and 20.04.

Other than that changes are cosmetic and can be reviewed in the ChangeLog.

3.4.2 released!

Posted on 16 January 2023

Yet another bugfix release for the 3.4.x series. It brings 32 bugs fixed and 2 small enhancements.

As always, the full ChangeLog is available.

3.4.1 released!

Posted on 02 December 2022

An important update after the 3.4.0. It fixes few key issues.

Most notable bugs fixed:

  • Loading data of tables that refer other tables with foreign key could take very, very long in some cases. It's fixed now to work as fast as it was in 3.3.3.
  • Crash when clicking "Test connection" in Database Dialog.
  • Crash when executing JavaScript-implemented custom SQL functions.
  • TLS issues when checking online for updates.
  • SQLite version updated to most recent 3.40.0.

...but there are more fixes in this release. As usually, I recommend to see ChangeLog for full list.

3.4.0 released!

Posted on 16 November 2022

This version brings quite a number of new features, enhancements and updates, but also a lot of bugfixes.

Most notable changes:

  • Installer packages are back (while portable packages are still available on GitHub Releases page). The new installer is driven by the VMware InstallBuilder.
  • SQLite upgraded to latest 3.39.4. With the upgrade also new features and updated SQL syntax is fully supported:
    • RETURNING syntax in INSERT/DELETE/UPDATE
    • MATERIALIZED syntax in CTE
    • STRICT tables
    • RIGHT, FULL OUTER JOIN, IS (NOT) DISTINCT FROM
  • Python scripting plugin (alongside of already existing similar Tcl, JavaScript and SQL plugins).
  • Code Snippets - a collection of SQL snippets that you can maintain in your SQLiteStudio and use it instantly from the Code Assistant (by triggering the assistant twice).
  • Added convenient way to increase/decrease font size by using Ctrl+MouseWheel or by (configurable) shortcuts Ctrl + + and Ctrl + -.
  • Application state (session) is saved (apart from normal application exit) whenever the state changes and also during critical application crash.
  • WAL mode is now handled properly upon application quit or database disconnection.
  • Database dialog has now just one browse button, but uses Qt file dialog, not native one.
  • Windows i386 (32 bit) binaries are now provided out of the box.
  • Changed F2 hotkey, so it enters inline editing of a cell (no longer it opens the config dialog, which now is under F10 key).
  • Fixed Dead Keys support under Linux.
  • Linux binaries are now built on Ubuntu 22.04 (used to be 20.04).
  • New model of translation files (thanks to the Crowdin).

...and a lot more. Full changelog is available here.

3.3.3 released!

Posted on 12 April 2021

Rather small, yet important bugfix release. Includes update to the most recent SQLite (3.35.4) and brings back independent SQLite library file to allow user manual updates if necessary.

Other notable changes are:

  • Expanded/collapsed state of connected databases is saved and restored upon next startup.
  • The "DEFAULT" column on Structure tab is now correctly showing the default value (it was always empty in 3.3.2).
  • Fixed support for portable config directory (the "sqlitestudio-cfg") that was broken in prior 3.3.x version.
  • Few bugs causing unexpected application crash were fixed, improving overall stability of the application.
  • Import and Export dialogs are now rendered correctly under "Fusion Dark" theme.

Full changelog is available here.

3.3.2 released!

Posted on 07 March 2021

Yet another bugfix release, due to critical bug in 3.3.1, which caused SQL numbers and star operators to be wrapped with quotes.

Apart from this key bugfix, one more fix in this version is that parenthesis pairs matching now uses different color scheme than text selection colors, so it is not confusing anymore. By the way of this release also automated Unit Tests are added for SQL formatter component, to reduce amount of regression bugs.