SQLiteStudio

What's new in this version:

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).

More bugfixes and features:
- added: Extension-based collations (like the ICU) can be now registered in databases using Collations Editor window.
- added: Added support for column list syntax in CREATE VIEW.
- added: Added checking if data types are matched in both columns while creating foreign column. This applies for Column Dialog Foreign Key, Table Foreign Key and also in the Query Executor (user will receive warning if executed query breaks the Foreign Key data type alignment).
- added: During exporting data in Export Dialog, the progress bar now shows number of rows already exported in real time (still filesystem may buffer writing operation, so data may appear in the output file with delay).
- added: Data cell focus and current data page is maintained during data reload.
- changed: Dialog geometry is saved & restored for several dialog windows (i.e. Import, Export, Populate and more...).
- changed: When loading SQL script into SQL Editor, contents of current editor are retained. Instead another editor is open to load SQL script, with exception when current editor is empty - in that case it is used for loading.
- changed: When trying to load SQLite database as SQL script into SQL Editor window, application detects it and opens Database dialog for that file instead.
- changed: When trying to load huge SQL script (over 10MB) into SQL Editor, user is asked to confirm it.

Fixed:
- Fixed Linux installer error 'logname: no login name'
- Fixed current query highligting color to respect configured color, instead of always using default color. Also removed query content selection after execution.
- Fixed Database Dialog file selection, so user has clear understanding whether new file is to be created, or existing file to open. Also fixes file selection dialog on MacOS when creating new database file.
- Fixed sorting order cached in data view when executing query with less columns than previously
- Fixed crash when using NOT NULL DEFERRABLE INITIALLY DEFERRED
- BIGFIX: #3454 German translation fixes
- Fixed detecting cell value change (to enable commit button) when erasing cell with BLOB value starting with null byte.
- Fixed querying ROWID column from tables. It no longer causes issues with editing query result data.
- Fixed moving/copying Views from one base to another using drag&drop or copy&paste.
- Fixed application freezing when loading big files into SQL editor (over 1MB or bigger). Now it can work with huge files, although all smart helpers (e.g. syntax highlighting, etc) are disabled in such window.
- Fixed executing SQL directly from file, so it does not skip CREATE TRIEGGER statements
- Fixed executing SQL directly from file, so it no longer disables foreign key checks during execution
- Fixed Foreign Key dropdown in data grid when foreign key references 2 different tables with same foreign column name in both referenced table
- Fixed tiny memory leak in the import() function.
- Fixed import() function options parser, so it no longer overwrites import plugin configuration with incorrect types of configuration values (i.e. string 'true' instead of expected boolean)
- Fixed executing large DDL scripts (more than 100 DDL statements) with CREATE TRIGGER in them
- Fixed warning message of forbidded cell edition when trying to do it on a multi-level View results, where the View was given an alias name. Now the warning is clear about forbidden edition due to multi-level View
- Fixed question dialog for going back to structure tab if there are uncommited structure changes
- Fixed broken order of data insertion when adding new row to a table with GENERATED column
- Added extra calls for cleaning up WAL files upon application exit
- Fixed copying (drag&drop or copy&paste) tables between databases when a column in the table requires quoting due to being a keyword.
- Fixed unchecking Named Constraint option in constraint configuration
- Improved cell editing behavior, so entering edition with Enter key or mouse Double-Click no longer preselects whole value.
- Fixed custom SQL functions editor to prevent duplicated argument names. Also fixed correct argumentName-to-value assignment if arguments share same initial part of their name. Also fixed handling of differnt type of arguments passed to custom SQL function.
- #5082 #5083 Fixed cell editing to preselect proper FK value from dropdown, to correctly load cell value if it containts single quote character and to have proper content selection depending on how editing is triggered.
- When editing FK value inline (not from dropdown), the autocompleted value also updates selection of item in the dropdown (yet to be shown if user chooses so). This also fixes up/down keyboard navigation basing on autocompleted value.
- GitHub Actions Linux build: include qt5-qtwayland to fix segfault in AlmaLinux 9.3
- 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).
- Improved handling of columns named 'true' or 'false', which are allowed in SQLite, but are treated in a very unusual way by SQLite.