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.

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.

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.

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.

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.