SQLiteStudio: versioni precedenti da scaricare

- ADDED: #5466 Support foreign keys with implicit columns (proper values in FK combobox columns).
- BUGFIX: #5472 Fixed updates cheking under Windows.

- BUGFIX: #5443 Fixed data entering in Grid View after it has got broken in 3.4.18 (entering editing mode by starting to type jumped to wrong cell).
- BUGFIX: #5447 Database object filtering improved - both speed (3x) and reliability (i.e. typing while filtering is in progress).
- BUGFIX: #5450 Increased precision for very small decimal numbers (like 1e-15).
- BUGFIX: #5440 Fixed formatting string literals in WITH-CTE clause.
- BUGFIX: #5436 Updated syntax definitions to support VALUES clause after UNION ALL.
- BUGFIX: Fixed manual updates checking in case when automatic on-startup checking is disabled.

- BUGFIX: #5308 Fixed handling true/false literals in expressions and on/off/yes/no literals in PRAGMA values.

- ADDED: #5231 Added safe-mode command line option to bypass issues caused by corrupted session.
- CHANGE: #5248 Database Export dialog has now Export Indexes and Export Triggers options, just like the Single Table Export dialog.
- CHANGE: SQLite updated to 3.49.0.
- CHANGE: Config options for WxSQLite plugin extended to support AEGIS and Ascon-128 ciphers.
- BUGFIX: #5247 Fixed crash when opening a View's Trigger and enabled trigger-related entries in context menu for a View's Trigger.
- BUGFIX: #5233 Fixed result column name when using [] quoting operator for column alias name.
- BUGFIX: #5226 Fixed SQL formatter for INSERT statement when database prefix is used, so the dot is not removed after database name.
- BUGFIX: #5234 Fixed SQL formatter for GENERATED ALWAYS column in CREATE TABLE statement, so it doesn't quote type name.
- BUGFIX: #5245 Enterprise SQL formatter preview is no longer resetting vertical scroll when updating preview contents.
- BUGFIX: #5254 Fixed handling Views that reference columns with spaces in their name, when commits table modifications.

- BUGFIX: #5218 Fixed Drag&Drop of items in the database list - a bug that was introduced in 3.4.14.
- BUGFIX: #5216 Fixed Query Executor to use Smart Execution Method when there is a Virtual Table mentioned in the query, therefore enabling all advanced features of the Query Executor.

- ADDED: #5190 Added support for optional ORDER BY and LIMIT clauses in UPDATE and DELETE statements.
- ADDED: #5190 Added support for AS clause in INSERT, UPDATE and DELETE statements.
- CHANGE: #5187 Backported compilation improvement for ScriptingPython to allow Python version selection through qmake parameter.
- CHANGE: #5214 Database list item selection is retained in the session for the next application start.
- BUGFIX: #5190 Improved code assistant suggestions for UPDATE to pripritize more relevant columns.
- BUGFIX: #5207 Fixed SQL parser to avoid marking INDEXED BY as syntax error.
- BUGFIX: #5189 Fixed execution of SELECT queries that use subselects with a STAR operator for result columns (in these subselects), so they return correct results.
- BUGFIX: Fixed execution of complex SELECT queries with subselects, that join multiple tables, some with aliases, some without aliases. Results from such queries would not be editable at all. Now they execute properly using the Smart Execution method.
- BUGFIX: #4987 MultiEditor dialog (i.e. hex editor dialog) now remembers size that user sets for it.
- BUGFIX: #5191 Fixed Enterprise Formatter in case when it's configured to avoid whitespaces before binary operator and the AND keyword appears in formatted query.

- BUGFIX: #5183 Fixed completer proposals in the column names of the INSERT INTO statement.
- BUGFIX: #5184 Fixed completer to show tables from implicitly attached database in case of 'SELECT other_database.'
- BUGFIX: System tables (sqlite_*) are now pushed further in the competer proposals.
- BUGFIX: Restored missing completer entries: string, number, BLOB literal.
- BUGFIX: Fixed Linux installer issue related to the logname command on some Linux distributions.

- BIGFIX: #5179 Fixed results returned from query joining the same table twice.
- BIGFIX: #5179 Fixed smart execution when joining tables with USING clause, so the result metadata is extracted properly and results can be edited.

- BUGFIX: #5148 Fixed executing queries that refer to tables with database prefix (i.e. dbName.tableName).
- BUGFIX: #5149 Relaxed recent limitation on requiring Custom SQL Functions to have unique names, so that names can duplicate if input parameters differ.

- CHANGE: #5146 If user enters a relative file path to the database dialog, a warning will issued to the user pointing out actual resolved path for the relative path entered.
- BUGFIX: #5145 Fixed Extensions Manager crashing the app if the percentile extension was loaded before. The percentile SQLite extension became corrupted in SQLite 3.46.x, then it got fixed, but the fix is not included in SQLite 3.47.1 source package.
- BUGFIX: #5144 Fixed Extensions Manager commit button when all extensions got removed from the list.

- CHANGE: #5131 SQLite updated to 3.47.1 (except for SQLCipher, which is still on 3.46.1 at the moment).
- BUGFIX: #5119 Fixed very bad performance of import() function executed from SQL Editor.
- BUGFIX: #5124 Fixed ScriptingPython plugin compilation against Python >= 3.12.
- BUGFIX: #5134 Improved performance significantly when working with big values (~1MB per cell) in multiple columns/rows of a table data grid view.
- BUGFIX: #5122 Fixed Linux packages to run properly under Wayland.
- BUGFIX: #5136 Fixed application hanging at quitting when the database is in WAL journaling mode and there is another client still accessing the database.
- BUGFIX: #5135 Counting rows in enormous tables (which can take very long time) no longer blocks the application.

- ADDED: #4974 Extension-based collations (like the ICU) can be now registered in databases using Collations Editor window.
- ADDED: #5041 Added support for column list syntax in CREATE VIEW.
- ADDED: #4774 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: #4928 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: #5079 Data cell focus and current data page is maintained during data reload.
- CHANGE: #4740 Dialog geometry is saved & restored for several dialog windows (i.e. Import, Export, Populate and more...).
- CHANGE: #4861 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.
- CHANGE: #4861 When trying to load SQLite database as SQL script into SQL Editor window, application detects it and opens Database dialog for that file instead.
- CHANGE: #4861 When trying to load huge SQL script (over 10MB) into SQL Editor, user is asked to confirm it.
- BUGFIX: #4828 Fixed Linux installer error 'logname: no login name'.
- BUGFIX: #4761 Fixed current query highligting color to respect configured color, instead of always using default color. Also removed query content selection after execution.
- BUGFIX: #4796 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.
- BUGFIX: #4819 Fixed sorting order cached in data view when executing query with less columns than previously.
- BUGFIX: #4846 Fixed crash when using NOT NULL DEFERRABLE INITIALLY DEFERRED.
- BIGFIX: #3454 German translation fixes.
- BUGFIX: #4835 Fixed detecting cell value change (to enable commit button) when erasing cell with BLOB value starting with null byte.
- BUGFIX: #4842 Fixed querying ROWID column from tables. It no longer causes issues with editing query result data.
- BUGFIX: #4844 Fixed moving/copying Views from one base to another using drag&drop or copy&paste.
- BUGFIX: #4861 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.
- BUGFIX: #4872 Fixed executing SQL directly from file, so it does not skip CREATE TRIEGGER statements.
- BUGFIX: #4871 Fixed executing SQL directly from file, so it no longer disables foreign key checks during execution.
- BUGFIX: #4874 Fixed Foreign Key dropdown in data grid when foreign key references 2 different tables with same foreign column name in both referenced tables.
- BUGFIX: Fixed tiny memory leak in the import() function.
- BUGFIX: 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).
- BUGFIX: #5096 Fixed executing large DDL scripts (more than 100 DDL statements) with CREATE TRIGGER in them.
- BUGFIX: #4831 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.
- BUGFIX: #5077 Fixed question dialog for going back to structure tab if there are uncommited structure changes (thanks to @marcpley).
- BUGFIX: #5076 Fixed broken order of data insertion when adding new row to a table with GENERATED column (thanks to @marcpley).
- BUGFIX: #4949 Added extra calls for cleaning up WAL files 

- ADDED: #3488 SQLite ICU extension is boundled into binary packages (thanks to @tuffnatty).
- ADDED: #4697 Added a 'Restore original hotkey' buttons at keyboard shortcuts page of configuration dialog.
- ADDED: Added sqlar extension to the default set of extensions provided with binary packages.
- CHANGE: #4689 Sorting order is not cleared when table data is refreshed. To removed sorting order user can either double-click on header (once or twice) to restore no sorting for a column, or use context menu to clear any sorting.
- CHANGE: #4735 Order of functions loading has changed. Now it's: built-in, extension-provided, user-defined. The last loaded has the highest precedense.
- CHANGE: #4732 SQLite updated to 3.41.2 (except for SQLCipher, which is still on 3.39.4 at the moment).
- CHANGE: #4683 Custom syntax highlighting colors now use theme-based colors by default (to work well with dynamically changing color palette in night/day theme changes) and can be explicitly enabled in configuration.
- BUGFIX: #4676 #4716 #4693 #4701 #4669 #4721 Few critical fixes for Query Executor, fixing a frequent error: near ")": syntax error.
- BUGFIX: #4685 Fixed WINDOW/OVER/FILTER keyword handling in the SQL parser.
- BUGFIX: #4694 Fixed messages for toolbar buttons in Code Snippets window & fixed loading translations for plugins.
- BUGFIX: #4698 Fixed handling object names with '{' and '}' in their names.
- BUGFIX: #4681 Fixed risk of null reference call in the SqliteOrderBy.
- BUGFIX: #4707 Fixed database file selection dialog, so it doesn't complaint about read-only files.
- BUGFIX: #4679 Fixed issue with case sensivity of CTE alias.
- BUGFIX: #4697 Changed default hotkey for rolling back pending changes in table data from Ctrl+Backspace to Alt+Shit+Backspace. Default hotkey affects new users and will not change automatically for those who upgrade from older SQLiteStudio.
- BUGFIX: #4739 Fixed committing changes in Extensions Manager if modifying valid extension settings, while there is another invalid, yet untouched extension on the list.
- BUGFIX: #4715 Fixed the UPDATE OF column popup on MacOSX.
- BUGFIX: #4754 Fixed Windows uninstaller to not create separate uninstall entries in Windows registry per each SQLiteStudio version and added SQLiteStudio icon for the uninstall entry in Windows Add/Remove programs.
- BUGFIX: Tcl plugin compilation improved on Ubuntu 18.04 (thanks to @tuffnatty).

- CHANGE: #4585 SQLite updated to 3.40.0 (except for SQLCipher, which has latest version 3.39.2).
- BUGFIX: #4600 #4587 Fixed very slow loading of data in tables with foreign keys.
- BUGFIX: #4549 Query executor column aliases do not need wrapping anymore, because parser in 3.4.0 does not strip wrapped aliases anymore.
- BUGFIX: #4219 Removed duplicated UI config entries generated by Printing plugin.
- BUGFIX: #4563 Installer now runs the application at final step as a regular user even if running as root.
- BUGFIX: Fixed icon path for Linux installer, so that SQLiteStudio shows with the icon in Linux application list.
- BUGFIX: #4550 Fixed the Test Connection button in Database Dialog.
- BUGFIX: #4569 Fixed casual application crash on database disconnection.
- BUGFIX: #4529 Fixed application freeze when creating table with ICU collation.
- BUGFIX: #4586 Fixed unloading & loading SQLCipher plugin during single run of application.
- BUGFIX: #4577 Fixed SSL handshake issue under Linux during updates checking.
- BUGFIX: #4590 Fixed TLS issue under Windows.
- BUGFIX: #4364 Fixed table modification script in case all existing columns of a table are deleted, but the table remains and then new columns are added.
- BUGFIX: #4098 Fixed disappearing table (not really, just in UI) when dragging it and dropping onto SQL Editor.
- BUGFIX: #4594 Initial (default) colors of current line/query in SQL Editor is fixed to not be just black.
- BUGFIX: #4140 #4343 Disabling Foreign Keys during execution SQL directly from file.
- BUGFIX: #4593 Fixed row/column (de)selection on header ctrl+click.
- BUGFIX: #4596 Fixed thread-safety issue with QtScripting (JavaScript) built-in plugin.