| Version | Change log |
| Valentina Studio 14.6.1 Nov 5, 2024 |
Valentina Studio: [Imp][Query Editor]9419 - Ensured unique tab names are generated for each new query. [Imp][Query Editor] Display RowID in the list of fields for SQLite tables. [Imp] Added an optional menu button to the toolbar, displayed by default in the GNOME desktop environment on Linux. [Imp][SQL Editor] Added a separate option to insert a space after functions during autocompletion. [Imp][Data Editor] Added a filter to Choose Shown Columns dialog. [Imp][Data Editor] Corrected the button width when viewing BLOB. [Imp][Form Editor] Remember the last selected language and apply it to new scripts and slots. [Imp][SQLite] Updated SQLite engine to version 3.47.0. [Imp][Scripting Documentation] The Help?Scripting Environment dialog now operates in non-modal mode, allowing for easier switching between documentation and code. [Fix][Form Editor] Log messages from ling.log_output. [Fix][Form Editor] Corrected the datasource object script template (datasource?dataSource). [Fix][Schema Editor] Fixed an issue where object properties were sometimes shown incorrectly, displaying properties from another object. [Fix][Schema Editor] Fixed update after applying changes on a diagram for PostgreSQL and DuckDB. [Fix][SQL Editor] Fixed autocompletion of user functions for non-Valentina databases. [Fix][Data Editor]9360 - Fixed an error when filtering PostgreSQL enum values. [Fix][Data Editor]9359 - Fixed processing an array with commas for PostgreSQL. [Fix][Data Editor]9424 - Fixed hangs when trying to view field with long text. [Fix][Data Editor]9425 - Don't show the confirmation message about unlinking when clicking to link records. |
| Valentina Studio 14.6 Oct 25, 2024 |
Valentina Studio: [Linux] - Qt upgraded from 6.3.1 to 6.8 [Win64] - Qt upgraded from 6.3.1 to 6.8 [New][SQL Editor] - Now uses "SQL GLOT" or "SQL Parse" tools to Format SQL query. In the new dialog you can choose which tool to use. Each tool has its own set of preferences. Each tool has advantages. [New][SQL Editor] - the contextual menu now has a 'Format' item. [New][DuckDB] - Supported connection to MotherDuck service. [Impp][DuckDB] - Updated the DuckDB library to version 1.1.2. [Imp][Report Editor] - Updated the chart control with a modern design. [Imp][SQL Editor] - When you drag from the left panel a Db Object (Table, Field, etc) and drop it into the Text Area of SQL Editor, the dialog is opened. Now this dialog has the checkbox “Quote Identifiers”. [Imp][Data Editor] - Added a confirmation prompt for unlink actions. [Imp][Data Editor] - Reduced a page size to 100 000 [Fix][Form Editor] - Added methods to the QTableWidgetItem class to retrieve item information, such as by index or from the selection. [Fix][Form Editor] - Disabled the advanced editor from opening with the Cmd/Ctrl key when the selection mode is set to ExtendedSelection for the table view control. [Fix][Form Editor] - Fixed filtering records for Valentina datasource. [Fix][Query Editor] - Fixed the display of tip messages on the scene for HiDPI monitors. [Fix][Query Editor] - Removed the database name from the table/view control header. [Fix][Query Editor] - Prevented automatic aliasing for the first instance of a table on the scene. [Fix][DuckDB]9409 - Can't open read-only DuckDB file in Valentina Studio [Fix][MongoDB]9408 - Buttons to edit documents in MongoDB collection are not visible [Fix][PostgreSQL] - Fix shows a new link as real after applying changes to a diagram. [Fix][MacOS][Icons] - issues with two monitors of different DPI. Valentina DB: [Fix] - possible date racing. |
| Valentina Studio 14.5.2 Sep 28, 2024 |
Valentina Studio: [New][DuckDB] - Added to preferences: the number of threads memory limit pivot limit [Imp][Diagram Editor] - Ctrl-W now closes a current diagram, not a whole Tab. [Imp][Data Editor] - Don't use double click to open an advanced editor of a cell. [Fix][Workspaces] - show the status of the bookmarks. [Fix]9331 - Accessing an encrypted database in the Schema Editor. |
| Valentina Studio 14.5.1 Sep 20, 2024 |
Valentina Studio: [New] - DuckDB Plugin: DuckDB support is implemented in the following Tools: Schema Editor Virtual Links SQL Editor Data Editor Related Data Editor Diagram Editor Query Editor - PRO Dump creation and loading SQL file can be created and loaded back. XML/JSON can be created. CSV Export and Import. Preferences panel Pre-connect, post-connect scripts of Bookmarks Project Editor Form Editor Report Editor [New][DuckDB] Added duckdb_sakila database to cloud examples: [New] - Supported Linux arm64 architecture. You can now download RPM or DEB archive and install it on the arm64-based system, such as Raspberry Pi. See folder “lin_arm_64” on the FTP. [Imp][SQL Editor]9389 - Auto-scroll SQL Text to a placeholder and highlight it, when you choose it in the panel 'Parameters': This is convenient for big SQL scripts. [Imp] Improvements for execution of the pre-connect scripts: A pre-connect script, written in Python or JavaScript, offers a customizable approach to configuring connection parameters before establishing a database connection. This feature enables users to dynamically adjust settings like database name, username, password, host, port, and other connection attributes according to specific needs or runtime conditions. For instance, it can obtain a connection-token for an Azure SQL database via a PowerShell script. [Imp] In the post-connect script of the bookmark, the connection and database objects are added to the result, allowing for initialization, such as changing DuckDB database connection settings. |
| Valentina Studio 14.5 Sep 18, 2024 |
Valentina Studio: [New] - DuckDB Plugin: DuckDB support is implemented in the following Tools: Schema Editor Virtual Links SQL Editor Data Editor Related Data Editor Diagram Editor Query Editor - PRO Dump creation and loading SQL file can be created and loaded back. XML/JSON can be created. CSV Export and Import. Preferences panel Pre-connect, post-connect scripts of Bookmarks Project Editor Form Editor Report Editor [New][DuckDB] Added duckdb_sakila database to cloud examples: [New] - Supported Linux arm64 architecture. You can now download RPM or DEB archive and install it on the arm64-based system, such as Raspberry Pi. See folder “lin_arm_64” on the FTP. [Imp][SQL Editor]9389 - Auto-scroll SQL Text to a placeholder and highlight it, when you choose it in the panel 'Parameters': This is convenient for big SQL scripts. [Imp] Improvements for execution of the pre-connect scripts: A pre-connect script, written in Python or JavaScript, offers a customizable approach to configuring connection parameters before establishing a database connection. This feature enables users to dynamically adjust settings like database name, username, password, host, port, and other connection attributes according to specific needs or runtime conditions. For instance, it can obtain a connection-token for an Azure SQL database via a PowerShell script. [Imp] In the post-connect script of the bookmark, the connection and database objects are added to the result, allowing for initialization, such as changing DuckDB database connection settings. |
| Valentina Studio 14.1.4 Aug 3, 2024 |
Valentina Studio: [Imp] - Improved stability. |
| Valentina Studio 14.1.3 Jul 30, 2024 |
Valentina DB: [Fix]9382 - Db triggers “AFTER STARTUP” and “BEFORE SHUTDOWN” are never executed Valentina SQLite Server: [New]9378 - Now the databases_sqlite folder can have subfolders. This allows you to organize your SQLite databases. Wiki Valentina Studio: [Imp][Diagrams] - Controls without model are now deleted, instead showing as an empty space. [Imp][PostgreSQL] - Remove support of OID (it was deprecated in 2005 and removed on pg12). [Imp][SQLite][Win] - now we have a single plugin file for LOCAL and CLIENT to VSERVER. [Imp][ValentinaDB][Win] - now we have a single plugin file for LOCAL and CLIENT to VSERVER. [Imp]9385 – Use the schema-qualified table name, if possible, when generating the INSERT command for the “Copy Record As SQL” actions in the SQL Editor and Data Editor. [Fix][SSH] - Fixed an issue where SSH connections on Linux incorrectly reported a valid password as wrong. |
