=== New === * [Parquet][Start Page] Added cloud examples that are available for download from the Start Page. === Improvements === * [DuckDB] DuckDB engine updated to v1.5.4. * [Schema Editor][ValentinaDB] The database creation dialog now remembers the last used settings. * [Data Editor] Large record counts are now formatted using locale-aware separators, for example 1,000,000. * [Data Editor] Find Column is now available from the Records -> Find Column... menu item and by shortcut: Cmd+Shift+K. * [Data Editor] The column lookup dialog now supports Up, Down, and Esc keys. * [Schema Editor] Record counts are now formatted using locale-aware separators in the Property Inspector. * [Form Editor] Improved error handling when adding or updating records. * Updated translations. === Fixes === * [ValentinaDB] Fixed a rare crash that could occur when importing very large CSV files. * [Data Editor] Fixed paging after switching from a high page in one table to a smaller table, so the grid no longer becomes empty after the switch. * [Data Editor][MySQL] Fixed record counts for MyISAM tables. MySQL reports INFORMATION_SCHEMA.TABLES.TABLE_ROWS as a cached estimate for MyISAM, so Valentina Studio now treats it as an estimated count instead of an exact count. * [Data Editor] Fixed filtered record counts in the status bar when paging is used. * [ValentinaDB] Fixed BLOB and Picture field handling when limited BLOB data is returned as text. This fixes the Picture control in related SubForms. * [Data Editor][DuckDB] Fixed handling of DuckDB VARIANT Object, Array, and Geometry values in query results and record updates. * [Query Editor] Adjusted the query panel width so buttons fit correctly in all UI languages.

=== New === * [DuckDB] Added support for the VARIANT field type. * [Report Editor] Added ODS Spreadsheet export format. * [Report Editor] Added support for Parquet files as report data sources. * [Parquet] Added support for working with Parquet files, including the Start Page, Schema Editor, Data Editor, SQL Editor, and Data Transfer. * [Parquet] Added support for local folders with multiple Parquet files, including cross-file SQL queries and switching between files in the Data Editor. * [Parquet] Added Show Metadata, Show On Disk, and Copy Path actions to the Parquet table context menu. * [SQL Editor][Pro] Added visual EXPLAIN for SQL commands. * [Data Editor][SQL Editor] Added a new button for quickly locating a field in tables, related tables, and query results. * [Schema Editor] Link objects can now open the Data Editor from the context menu, toolbar, or double-click. * [Diagram Editor] Added the ability to attach Pre-Create and Post-Create SQL scripts to table definitions in diagrams. * [Schema Editor][ODBC] Added Primary Key property support for ODBC tables. === Improvements === * [DuckDB] DuckDB engine updated to v1.5.2. * [ValentinaDB] Improved search, sorting, and numeric field loading performance for non-indexed fields. * [ValentinaDB] Optimized indexed ORDER BY/GROUP BY operations and COUNT(DISTINCT ...) on indexed fields. * [ValentinaDB] Improved aggregate calculations. * [ValentinaDB] Optimized database opening. * [ValentinaDB] Added SIMD acceleration, improving SQL and API operations. * [SQL Editor][AI Chat] Added the ability to refresh the list of available models from supported AI providers. * [Schema Editor][ValentinaDB] Added a confirmation dialog when changing the Compressed option in the Inspector panel. === Fixes === * [Data Transfer][MSSQL] Fixed paged data transfer for SQL Server. * [Data Transfer][ODBC] Fixed hangs during transfers from ODBC sources in some cases. * [Data Transfer] Fixed incorrect value order during batched transfers with bound parameters. * [Data Transfer] Fixed incorrect bind placeholders in some cases. * [Form Editor] Fixed Templates and Methods menu snippets for Python and JavaScript. * [Form Editor] Fixed Templates and Methods menus after changing the scripting language. * [ODBC] Fixed showing the correct name for ODBC connections. * [Data Editor] Fixed an issue where custom fonts were not applied to table grid values. * [ValentinaDB] Fixed a rare cache issue that could cause a crash or corruption. * [ValentinaDB] Fixed the 4 GB limit issue in CSV import.

=== Improvements === * DuckDB engine updated to v1.5.0 * SQLite engine updated to v3.51.2 === New === * [Query Editor] Added support for generating UPDATE, DELETE, and INSERT queries in addition to SELECT. === Fixes === * [Data Editor] Fixed scrollbar overlap on the last row of the table view. * [DuckDB] Fixed display of the correct engine version in the Property Inspector.

=== NEW === * [SQL Editor][AI] Query results can be attached to the AI chat context using the Attachment button. Results are sent as CSV text; avoid sending very large result sets to conserve tokens. [Query Editor] * New expressions in SELECT automatically receive an alias in the form ExprN. * Added the ability to edit query text directly and apply changes to the diagram. You can paste a full SELECT query into the right panel or edit the query generated by Query Editor, then click Apply Changes. * [Form Editor] Added DuckDB client and local factories, accessible from scripts. * [Valentina DB] Added the GROUPING aggregative function. * [Report Editor] Added support for inheritable report parameters. It is now possible to define whether a subreport parameter value is inherited from the parent report. === IMPROVEMENTS === * [DuckDB] DuckDB engine updated to v1.4.3. * [SQL Editor][AI Chat] Switching between dark and light themes now works more correctly. * [Tips] Updated tips translations. [Valentina DB] * Improved performance of UDF and scalar built-in functions. * Journal is now always truncated on Flush() to its minimal size (4 KB header). [Query Editor] * The Select tab has been updated: the Function column is renamed to Aggr Function, the Filter column is renamed to Where, and Where/Having columns now accept conditions starting directly with an operator (e.g. = 'PG' instead of rating = 'PG'). * Where and Having cells now display only the condition value (right-hand side) for a more compact view. * Tooltips on the Execute button now reflect the keyboard shortcut configured in Settings. [Form Editor] * Added a text property to the QLabel class definition. * Auto-completer is now added only when a combo box is editable. * [Form Editor] Improved defining signal handlers dynamically. The preferred way to create dynamic signal–slot connections is to use a signal member variable, e.g.: this.tabWidget.currentChanged.connect. * [Data Transfer] Now supports transferring records in batches, providing a significant speedup over network connections. Configurable records-per-batch count, with optional multi-row binds for Valentina DB, DuckDB, and SQLite. Batch configuration is saved in the mapping file. === FIXES === * [Dump] BOM is now added only for UTF-16/32 encodings and only at the beginning of the file. * [Form Editor] Fixed getting the CheckBox stateChanged signal parameter value. * [Report Editor] Fixed printing reports to ODT format. [Valentina DB] * SUM/CASE aggregation on an ENUM field no longer always returns 0. * ENUM fields in IF/CASE clauses now produce correct results. * Fixed: only one journal file was created when opening two databases with a shared journal folder. * Fixed: a DATE field was incorrectly affecting an unrelated foreign key. * Fixed journal file location when cloning a database. * Fixed: HAVING no longer prevents use of a column that appears in GROUP BY but is absent from the SELECT list. * Fixed incorrect sorting when using ORDER BY over an aggregative result. * Fixed: a multi-column unique key was incorrectly preventing UPDATE operations.

=== NEW === Valentina Studio introduces integrated AI Chat to enhance your SQL workflow. [SQL Editor] * AI Chat in SQL Editor * Integrated AI chat inside the SQL Editor. * AI can help explain queries, suggest improvements, generate SQL, and more. * Easily add context to your question (current query, database schema, schema of specific tables/views mentioned in the query) * Answers from the AI can be copied directly into your SQL or anywhere else. * ASK and AGENT modes to work with AI. * In the Agent mode, AI can modify (with confirmation ) the text of SQL Editor. * In Agent Mode, AI has access to: * SQL Editor — execute and modify queries * Python engine of Valentina Studio * Custom instructions via the “Remember…” command * Each SQL Editor has own AI Chat with own context. * Multiple Cursors support (Cmd+Shift+Up/Down to add cursor, Option+Click to insert cursor, Option+D for Find Next Occurrence). * Information button showing available keyboard shortcuts. [Data Editor] * Improved layout settings dialog - rename layouts, select columns to display, and set their order. * Information button showing available keyboard shortcuts. [Schema Editor] * Tabs with child lists in Tree mode. * Button to toggle the property inspector. [Query Editor] * Directional arrows on connection lines between joined tables indicating parent table direction. [Forms] * TabWidget properties and methods exposed for scripting. * Added ToolButton popupMode property (MenuButtonPopup, InstantPopup, DelayedPopup). * ToolButton QMenu support. [Valentina DB] * External aggregation functions (C, Python, JS) as extensions. * Aggregation User Defined Functions (UDF) in SQL, Python, JS. * CREATE AGGREGATE and DROP AGGREGATE SQL statements. * Any aggregation function may be used in window context. * Added column MethodDeterministicLevel in GET/SHOW properties of calculated fields. === IMPROVEMENTS === [Valentina Studio] * Updated PostgreSQL client libraries and dump utilities to version 18.0. * Translated helpful tips for all available interface languages. * HELP -> "Report issue" menu now selects "VStudio" project when opening Mantis web-page. [Connection Dialog] * Improved Valentina Server connection dialog - clearer labels for Embedded Server ("Signature" -> "Embedded Signature", placeholder "Optional" -> "Required for Embedded Server"). * Added tooltips for all controls. [Valentina DB] * All built-in and external aggregation functions can now be used in the WINDOW clause of SELECT statements. * Performance improvements. * Added diagnostics for table storage. * Improved unclear deterministic level warning in Diagnose. [Data Editor] * Automatic layout saving upon modification. * Reorganized layouts menu for improved usability. === FIXES === [Data Editor] * Ensured the current table is selected in the table selector drop-down on macOS. [Form Editor] * Corrected the behavior of 'Stretched' and 'Title' options for TableView fields in forms. * Fixed the setValue method of QSettings to correctly store values in forms. [Schema Editor] * Fixed sorting by column header click in tree mode. * Preserved original field order as returned by the server when updating the fields list. * Prevented collapsing of the property inspector panel. * Fixed slow reading of fields in MySQL tables caused by the correlated query used for JSON support detection. [Valentina DB] * Fixed potential VarChar data corruption issue. * Fixed weird result of aggr_func(distinct ...) - now correctly counts distinct values inside each group instead of producing new groups. * Fixed deterministic level for skipped optional function argument (Const instead of Volatile). * Fixed deterministic level for list_itemcount(), size(), IsNormalized() (Immutable instead of Volatile). === LIBRARY UPDATES === * DuckDB updated to 1.4.1 * PostgreSQL client libraries updated to 18.0

=== NEW === [Valentina DB] * Support for Extensions added (C, C++, Python, JavaScript) to create custom functions and procedures. * SQL 2003 aggregate functions for regression analysis added. * INSERT statements now support the RETURNING clause for efficient retrieval of inserted values. [Data Editor] * The Related Data Editor menu now includes "Create Virtual Link". * Connection icon added to the toolbar. * Yellow warning icon shown if a table has no primary key or unique field (also in the Create Table dialog). [SQL Editor] * Autocompletion now supports VIEW fields. * Three autocompletion modes are available: StartWith, Contains, Wide (configurable in Preferences or via the Autocompletion menu). [Start Page] * Progress bar displayed during the first Bonjour scan. * Buttons added to toggle filters in the columns. [Server Admin] * Application name displayed in the connection list for Valentina, SQLite, and DuckDB servers. === IMPROVEMENTS === [DuckDB] * Databases are now created with the default storage version if none is specified. * Use Parquet V2 for backups. [MariaDB] * JSON editor enabled. * Special connection icon displayed when connected. [Report Editor] * Line width menu now shows values in the current unit. [SQL Editor] * Improved behavior of the "Execute Current" action. * Autocompletion menu performance significantly improved (up to 100x faster for large schemas; max 1000 items displayed). [Start Page] * Tooltip added for the Bonjour Pane. [MySQL] * Use INFORMATION_SCHEMA.KEYWORDS for autocompletion if available. [PostgreSQL] * Added "Refresh Materialized View" action. * Support added for showing and creating indexes on materialized views. [Data Editor] * Improved tooltips and UI for transaction mode; separate transaction settings button added. * Further improvements to transaction mode tooltips and UI. [Query Editor] * Complete rewrite with visual redesign. === FIXES === [Data Editor] * Columns now resize to fit contents when switching layouts. [Form Editor] * Undo now works correctly after widget moves. [SQL Editor] * Fixed "Unsafe operation" popup for ON UPDATE ON CASCADE. * Corrected case change when copying query text. * Fixed parsing of '?' placeholders for PostgreSQL. * Autocompletion no longer adds extra parentheses. * ENUM values now display correctly in PostgreSQL query results. [Diagrams] * Fixed creation of new links. * Auto-growing of the table control when adding fields enabled. [PostgreSQL] * Infinity and -Infinity now display correctly in data grids. * "Infinity" date fixed in the Data Editor. [Valentina DB] * SUM and AVG now return SQL NULL for empty tables. [Server Admin] * Fixed sorting of multi-part Valentina Server log files. [Application] * Always opens a new main window when clicking the app icon if no windows are open. === LIBRARY UPDATES === * DuckDB updated to 1.3.1 * SQLite updated to 3.50.4

New Features [DuckDB] * Supported connection to Valentina DuckDB Server. * Supported connection to the MotherDuck service. * Added new options to Preferences: Number of Threads, Memory Limit, Pivot Limit. * Added Storage Version and Block Size parameters to the database creation dialog. [SQL Editor] Integrated advanced formatting tools: SQLGlot and SQLParse for SQL query formatting. [Form Editor] * Enabled programmatic management of ListView items. * Added the ability to retrieve scripts of a Form. * Introduced the preCreate property for the Form object, enabling flexible setup of data sources (e.g., creating a temporary table). * Added support for establishing signal connections within Scripts and Forms programmatically. [Report Editor] * Implemented report printing to OpenDocument Text (.odt) format. * Enabled report generation from any JSON data without using a database. * Allowed using Valentina DuckDB Server as a data source for reports. [Valentina DB] Non-SQL Stored Procedures (Python/JavaScript) can now return a cursor. [Data Editor] Added transactions mode. Improvements [Data Editor] * Disabled double-click for opening the advanced editor for text value cells. * Added a confirmation prompt for unlink actions. * Introduced a filter in the “Choose Shown Columns” dialog. * Reduced page size to 100,000 records. * Corrected button width when viewing BLOBs. * Enhanced Paste Records functionality - supported different separators for pasted data, added a preview of pasted records to ensure validity. [Diagram Editor] Cmd-W now closes the current diagram instead of the entire tab. [Form Editor] * Added methods to the QTableWidgetItem class for retrieving item information by index or from the selection. * Disabled the advanced editor from opening with Cmd/Ctrl when selection mode is set to ExtendedSelection for the table view control. * Remembered the last selected language and applied it to new scripts and slots. * Reorganized the controls palette. [Report Editor] Updated the chart control with a modern design. [DuckDB] Updated DuckDB library to version 1.2.1. [SQL Editor] Added an option to insert a space after functions during autocompletion. [Query Editor] * Displayed RowID in the list of fields for SQLite tables. * Ensured unique tab names are generated for each new query. [SQLite] Updated SQLite engine to version 3.47.0. [Scripting Documentation] Made the Help→Scripting Environment dialog non-modal, allowing easier switching between documentation and code. [Schema Editor] Implemented natural case-insensitive sorting in tree mode. Fixes [Data Editor] * Fixed buttons for editing documents in MongoDB collections. * Fixed errors when filtering PostgreSQL enum values. * Fixed processing of arrays with commas for PostgreSQL. * Fixed hangs when trying to view fields with long text. [Schema Editor] * Fixed issues with changing DuckDB field comments. * Fixed access to encrypted Valentina databases. * Fixed incorrect display of object properties by preventing cross-object property leaks. * Fixed updates after applying changes to diagrams for PostgreSQL and DuckDB. [DuckDB] Fixed opening of read-only DuckDB files. [PostgreSQL] Fixed an issue where a new link was incorrectly shown as real after applying changes to a diagram. [Form Editor] Fixed filtering of records for Valentina data sources. [Query Editor] * Removed the database name from the table/view control header. * Prevented automatic aliasing for the first instance of a table on the scene. [Workspaces] Showed the status of bookmarks. [Icons] Fixed display issues with two monitors of different DPI.

Unified JavaScript and Python engines are now used for Forms, Reports, and Valentina Database Stored Procedures. Previously, different JavaScript engines were used for Forms and Reports, which could lead to inconsistencies in how scripts were executed. With a unified engine, behavior is now consistent and reliable across all components. A new plugin has been added to work with DuckDB databases. This is a file-based database, similar to Valentina DB and SQLite in this aspect. === New Features === [DuckDB] * DuckDB support has been implemented in the following tools: * Schema Editor * Virtual Links * SQL Editor * Data Editor * Diagram Editor * Query Editor * Dump creation and loading * SQL file creation and loading * XML/JSON creation * CSV Export and Import * Preferences panel * Pre-connect and post-connect scripts for Bookmarks * Project Editor * Form Editor * Report Editor [Report Editor] New features of the reporting engine: * Table of contents generation * Justified text alignment added for text controls * Reorder report parts by dragging their tabs * Rename parts by double-clicking on their names at the bottom * Reports can be scripted with Python, in addition to JavaScript * Standalone scripts stored in the project can be loaded using the project.loadModule method in expressions and scripts executed during report generation (previously, this was only possible for forms) [Form Editor] Forms can now be scripted with Python, in addition to JavaScript. [Valentina DB] Stored procedures can now use JavaScript or Python. [Bookmarks] Pre-connect and post-connect scripts can now be implemented using Python or JavaScript. For example, a pre-connect script can retrieve a connection token, while a post-connect script can define parameters for an established connection === Improvements === [Report Editor] * Ability to delete the first part of the report * Clearer messages when a query fails during report generation from an SQL Server data source, helping users identify and resolve issues more effectively [Query Log] Ability to export only queries from the Query Log tab [SQL Editor][Data Editor] Use of schema-qualified table names when generating the INSERT command via context menu actions === Fixes === [Report Editor] Fixed issue with drawing EAN barcodes with an additional section [MySQL] Faster export of large MySQL cursors to CSV

New Features: [Report Editor] Added 'fetch' and 'fetchSynced' functions to JavaScript for asynchronous and synchronized execution. These functions facilitate: * Loading a local file. * Loading external data over HTTP protocol using the GET method. * Loading external data over HTTP protocol using the POST method. [Data Editor] Foreign Key Value Editor: * Introduces a window to select a Primary Key value for a Foreign Key cell. * Ability to open a popup using CMD+click or a button below the edited cell. * Dialog can be opened as a modal window using double-click or the content editor button below the table view. * Works for ObjectPtr in Valentina DB as well. * Implements layouts for the editor. [PRO] Virtual Links: * Designed for databases where Foreign Key-links between tables are not utilized for various reasons. * Virtual links are not stored in the database schema. * In the SchemaEditor, a database contextual menu now includes a 'Setup Virtual Links' item. * Allows users to choose from 2 predefined rules or create custom rules in the dialog. Multiple rules can function simultaneously. * Enables Valentina Studio to automatically recognize hundreds of such 'virtual links' via rules. * Users can manually create virtual links using the dialog. * Virtual Links are functional in Schema Editor, Data Editor, Diagrams, and SQL Autocompletion. * Virtual Links for a database can be synchronized using cloud services if this feature is enabled in the preferences. Improvements: [SQLite] Utilizes ALTER TABLE to rename columns. [Data Editor] Implements colorization of values based on the field type. [CSV Export] Auto-generates destination file name. [Sync] Adds a button with a cloud icon in the main toolbar to display synchronization status. Fixes: [Schema Editor] Fixed the issue of switching to Schema Editor and selecting the newly created/opened database on the Start Page. [Schema Editor][Valentina] Corrected the discrepancy in the Property Inspector where the "Temporary" checkbox did not correspond to an actual table property. [Data Editor][Valentina] Fixed the update issue of the related panel after linking. [Data Editor][SQLite] Fixed the display/editing of Boolean values. [Report Editor] Addressed the problem of formatting not being applied to NULL values. [SQL Editor] Fixed the problem with analyzing queries containing nested SELECT statements. [ODBC] Resolved an issue retrieving data with NULL values occurring with ODBC Drivers that do not support scrollable cursors. [MSSQL] Fixed the issue of displaying a list of databases when the user lacked permission to access backup information.

New: [Report Editor] Added the Python engine to Valentina Reports, additionally to JavaScript and SQL: * Can be used to write source queries for reports * Can be used for expressions in reports [Report Editor] A source query written using Python returns data for the report in one of three forms: * Cursor – a cursor returned by the datasource * Dictionary – a dictionary containing one row of data * Sequence – a list of dictionaries containing a set of rows of data Improvements: [SQL Editor] Enabled the 'Execute Current' button even for a single statement. [SQL Editor] Disabled auto-repeat for 'Execute' actions. [Schema Editor] Added the 'Refresh' action to the schema list context menu. [Schema Editor] Update the current list (in the tree mode) on refresh of the tab. [MongoDB] Restore tabs with collection/view editors. [SSH] Check and ask to add a folder with SSH private key to “Allowed Locations” if necessary. [SSH] When adding a private key to establish an SSH connection, open “~/.ssh” folder by default. Fixes: [SQL Editor] Fixed restoring selection after using the 'Execute Current' button. [Project] Don't run the start script on restoring state at app start. [Schema Editor] Fixed crash on an attempt to duplicate a table. [Data Editor] Fixed losing keyboard cell editing focus on moving the mouse over another view. [MongoDB][Data Editor] Fixed an issue when a document is not shown if added to an empty MongoDB collection in the Columns mode. [Server Admin] Auto-hide an error message.

New: * [Report Editor] Implemented reports for MongoDB databases. The source query can be defined in JSON or JavaScript forms. * [Report Editor] Source queries can be defined using JavaScript code. This allows JavaScript to build a set of data and produce a report. * [Report Editor] The content of text controls (text field, expression field, label) can be printed on multiple pages if it doesn't fit on one page. * [ValentinaDB] Deterministic levels for UDFs. * [MongoDB] JavaScript can be used to query databases; previously, only JSON was available. * Database Documentation Generator: a special project that produces a report with a description of all major DB objects. Based on Valentina Reports, it works for ValentinaDB, SQLite, MySQL, PostgreSQL and SQL Server. * [FREE] version users can adjust the datasource and generate predefined reports without modifications. * [PRO] owners can tune the .vsp project to their needs. * Valentina Studio can now show useful tips about its features. Improvements: * [Data Editor][PostgreSQL] The Data Editor filter is now case-insensitive by default (similar to other engines). * [Data Editor] Improved performance, especially for DateTime values. * [Data Editor] The Refresh button reapplies the filter if it was applied before. * [Schema Editor] Bookmarks are not shown in the left panel by default; this can be changed in the preferences. Bookmarks are now available in the main toolbar, in the new button with a menu. * [Schema Editor] When you connect to a DB Server and see a list of databases, there is no need to double-click a database to open it because Valentina Studio considers all databases always opened. * [Schema Editor] Sizes are shown in the Property Inspector as KiB, MiB, etc. * [Schema Editor] Column View: * On the right side of the column header, you can see the counter now. * For Databases/Schemas, you can see two counters to easily understand how many objects are hidden. * Each column now has “dynamic” buttons that are shown only when the mouse cursor is moved over the column header. * Different columns may have different sets of buttons. * Button “+” opens a dialog to create an object of the corresponding type. * Button “Search” - displays the SEARCH-FILTER in the column header. * Button “Options” - displays a dialog where you can choose which Database/Schema to display and which to hide. * [SQL Editor] 'Default Schemas' menu choices are saved to prefs and restored on the next start. * [SQL Editor] Implemented background reloading of identifiers when needed. * [SQL Editor] Ident Resolver now recognizes Valentina Report parameters $P() and $P!(). * [SQL Editor] Ident Resolver - PostgreSQL-style of type-casting 'ident::type' now is recognized. Affects PostgreSQL and ValentinaDB. * [SQL Editor] Ident Resolver - is refreshed on changes in the 'Default Schemas' menu. * [SQL Editor] Ident Resolver - added recognition of the query of type SELECT schema.funcName() for databases with schemas. Fixes: * [ValentinaDB] Fixed a crash in SHOW command in some cases. * [ValentinaDB] Fixed comparing the result of the LEFT function using '=' operator. * [MySQL] Skip adding precision and scale to SQL definition of the floating-point type fields if unnecessary. * [Query Editor] Fixed control duplication after dragging a table from the related tables list to the Query Editor scene. * [Dump][MySQL] Fixes for the option to disable and enable keys in the dump file. * [Report Editor] Fixed setting font size to 12 pt from the Report Editor toolbar. * [Report Editor] Fixed duplication of the subreport column header in some cases. * [Data Editor] Fixed row filter - entered values of the active filter are visible after leaving the cell. * [Data Editor][PostgreSQL] Fixed showing NULL values for the timestamp. * [Schema Editor][PostgreSQL] Fixed refresh of links and functions.

New: * [Report Editor] Reports now support watermarks. It can be either text or picture. * [Form Editor] Added an ability to set custom titles for the table view. Improvements: * [Form Editor] Added notification about changed selection on resetting a table view. * [Data Editor] Fixed adding a new record in some cases. * [Data Transfer] Fixed inactive Run button. Fixes: * [SQL Editor] Show snippets in alphabetical order. * [Query Editor] Fixed showing a message for failed link creation. * [Valentina DB] Fixed possible buffer overflows in some algorithms.

New: [Diagram Editor] Added the ability to create diagrams for MongoDB. [SQL Editor][Pro] Implemented editing the result for SQL Server databases. Show a warning if a cursor is Read-Only with a hint on how to make it writable (add FOR BROWSE or set the NO_BROWSETABLE option). [Workspace][Pro] Workspaces save the state of opened editors and will restore it the next time Valentina Studio Pro starts. It includes the automatic reopening of connections and databases. Improvements: [Data Editor] Show the field's custom color in the column header. [Diagram Editor] Extracted the editor as a separate tab. [Report Editor] Added the ability to close property editors with the CMD+Enter keyboard shortcut. [Schema Editor] Properties and other data are fetched in separate threads. [Schema Editor][Tree Mode] Filters in a tree mode are much faster now. [SQL Editor] Static Analyzer and Ident Resolver improvements. [SQL Editor] Added the 'Cancel' button to stop query execution for SQLite and MongoDB databases. [SQL Editor] Highlight syntax in multiline dollar-quoted string literals for PostgreSQL. [SQL Editor] 'Escape' key now closes the console (if shown). [PostgreSQL] Updated client and dump utilities to version 15. [SQL Server] Updated Compatibility Level database property - added newer server versions, including 2022. [SQLite] SQLite library updated to version 3.40.0. [SQLite] Optimized generated queries to add indexes. Fixes: [Dump Wizard] Fixed showing dump progress for tables with more than 2^31 records. [Form Editor] Fix saving the current splitter position/current pane for forms. [Query Editor] Fixed showing field names of a PostgreSQL view. [Schema Editor] Fixed showing field names in the Design Table dialog in some cases. [SQL Editor] Trackpad was not very responsive with option 'Wrap text' enabled. [Report Editor] Removed useless whitespace on wrapping a text. [Report Editor] Fixed wrapping of long text without punctuation and spaces. [SQL Server] Fixed showing user-defined types in the list of field types. [SQL Server] Show the correct tooltip for the Variant type column. [SQLite] Indexes on function do not show up in the table indexes list. [Valentina DB] SHOW VERRORS command missed some error items. [Valentina DB] Fixed testing Boolean fields with IS TRUE/IS NOT TRUE conditions. [Valentina DB] Fixed creating a Boolean column with a default value. [Valentina DB] Fixed diagnosis for hash indexes.

New: [Report Editor] Added the ability to use JavaScript in the expression of the Summary control. Now it is possible to reference non-datasource objects of the report. It allows calculating summaries for Expression controls, e.g.: report.controls.expression1.instance.source. Improvements: [Data Editor] Added predefined date&time formats to show them in the combobox field of the 'Set Format…' dialog. Remember the last entered format. [MySQL] Added 'Aria' to the list of engines (default engine for system tables in MariaDB). [MySQL] Added new keywords from MariaDB. Fixes: [Data Editor] Fixed applying the date format to new values for Valentina DB. [MySQL] Fixed update of Charset/Collation properties of the connection. [MSSQL] Enabled Schema and Start input fields in Create Sequence dialog. [MSSQL] Fixed wrong display of Sequence properties Start, Min Value, Max Value. [MSSQL] Fixed showing values of SQL_Variant fields in the SQL result.

Fixes: [Data Editor] Fixed crash on editing a cell if its right border is not visible. [Data Editor] Fixed a date format for a new row of the Valentina DB table. [SQL Editor] Fixed disabling zoom in the query area. [MySQL] Fixed creating and dumping a table with auto-incremented indexed field (non-PK, non-Unique).

New: * [SQL Editor][Pro] Placeholders in SQL text when: - auto-completion suggestion is inserted - auto-completion inserts a built-in or user-defined function with arguments as placeholders - a snippet is inserted - template of SQL command is inserted - 'Generate SQL' context menu action of the table provides placeholders in the values part of the INSERT command. * [Data Editor] Filter cell now can contain a few values as a comma-separated list. It will be used in SQL search as 'fld IN (value1, value2, ...)'. Improvements: * Apple Silicon native support. * [Data Editor] Supported 'IS TRUE', 'IS NOT TRUE', 'IS FALSE', 'IS NOT FALSE' conditions in filter. * [Valentina DB] The speed of the BLOB fields update improved. Fixes: * [Data Editor] Fixed use of 0/1 values in the filter cell for boolean fields for PostgreSQL. * [Data Editor] Fixed filtering by Date/Time fields. * [SQL Editor] Fixed incorrect syntax highlighting for comments where '–-' is not preceded by whitespace. * [SQL Editor] Fixed crash on editing the string literal with Unicode characters (e.g. cyrillic). * [Query Editor] Fixed update of the generated query on clicking the 'Select All' checkbox if some fields have already been selected. * [Schema Editor][SQLite] Pass the default value to CREATE TABLE query as defined, don't add brackets or quotes.

New: MongoDB plugin - the first non-SQL DB in Valentina Studio, it includes: * Schema Editor * Command Editor (similar to SQL Editor) * Collection Editor (Data Editor) * Server Admin (manage users, databases, etc) Workspaces [Pro] - this great feature for Pro-developers, which now get a clean isolated room for a project. You can create a new workspace, which will contain Bookmarks, Recent databases, Recent SQL queries and SQL snippets. Switching between workspaces moves you to this or that project context. * Menu 'Workspaces' in the application menu * Top-right button-menu 'Workspace' to visualize the current workspace and manage workspaces. [SQL Editor] * [Pro] Static Analyzer now reports errors about an incorrect number of arguments in a function call. * [Pro] New and improved 'smart suggestions' for some commands - shown at the top of the auto-completion menu. These suggestions have the 'bulb' icon. * [Pro] Auto-completion will display 'ON KEY DUPLICATE UPDATE SET' suggestion for command: INSERT … VALUES (…) ON * [Pro] Highlight the corresponding field in the fields-list while you typing or choosing a value in the values-list. Also over that field, you will see a tooltip with the field type. * [Pro] Auto-refresh for schema if specific DDL command (CREATE/DROP/ALTER) was executed in SQL Editor. * Auto-completion now is able to show the list of the second keywords after the first keyword is typed for such commands as 'CREATE TABLE', 'ALTER COLUMN', 'DROP CONSTRAINT' etc. * [Server Admin][Valentina Server] Added a new 'State' tab to see tasks inside a Valentina Server in live mode. Improvements: * [Valentina DB] Overall improvements. * [Start Page] Copy&paste command for a single bookmark. * [Dialogs] Dialogs to export bookmarks, snippets, etc, now suggest the default name of the file. [SQL Editor] * Show autocompletion for schema names. * Preference added to show system objects in the auto-completion menu. * User-defined functions (UDFs) now show a tooltip with its declaration and first lines. * Built-In functions now are shown in a more improved way and formatting. * Fields-list will show the fields of the specified table only. * More suggestions will be displayed in the auto-completion menu when you type at least 3 chars 'ins'. * Static Analyzer now is able to show the error for INSERT command if the number of items in the fields list and values list is not the same. * Auto-completion menu shows only possible keywords when you start typing the first word of command. * Auto-completion recognizes the first keyword of SQL command in all scenarios. * Auto-completion tooltip on the first show now is able to auto-update to display more info about symbol after loading from DB. * [PostgreSQL] Typing $$ adds another pair $$, to support dollar-quoted-literals. * [Report Editor] Few optimizations when the report contains subreports with large pictures. * [Form Editor] Allowed to use numbers to modify QLineEdit.text property Fixes: [Data Editor] * [PostgreSQL] Fixes for columns with time information. * [PostgreSQL] Fixed truncation of values of Integer type to 16 bit. * [MySQL] Fix for adding records to tables with an estimated record count. * [MySQL] Adding a new record does not consider an Unsigned toggle on a field in the MySQL table. [Schema Editor] * Fixed opening the second local SQLite database. * Fixed use of all width in toolbar for buttons. * [MySQL] Fixed showing the charsets list in Create Database dialog. [SQL Editor] * Skip showing auto-completion menu if the typed token contains only digits. * Fixed saving the list of default PostgreSQL schemas to the schema cache. * [Form Editor] NULL values of a Date field are now shown correctly in the Form field. Changes: * [SQL Editor] Now 'tblAlias.FldName' items in the auto-completion menu can be used in a FREE Valentina Studio.

Improvements: [Report Editor] Don't limit barcode data length to 256 characters. [PostgreSQL] Updated PostgreSQL client library and dump utilities to version 14. Fixes: [Report Editor] Fixed updating the report preview, in some cases, it didn't work as expected. [Report Editor] Fixed applying the best size for the multiline label. [Report Editor] Labels of EAN-13, UPC-A, UPC-B, ISBN barcodes are generated without the leading digit, GS1 DataBar label is cropped. [Data Editor][PostgreSQL] Fixed editing values of Timestamp With Timezone columns.

New: [Data Editor][Pro] Formatting of data of a column. Right-click a column header to see the contextual menu, where you can find the "Format" command. * For example, for a column with Integer type, you will see Format (Decimal, Hexadecimal, Binary, Octal). * You can also set a suffix to value, e.g. “mm” * Added formatting for native types, such as PostgreSQL's MacAddr, Point, etc * Added currency formatting for Float, Double, Decimal, Money fields. [PostgreSQL] Implemented support of METHOD FIELDS (generated columns), which was added in PostgreSQL v12. [PostgreSQL] Implemented support of identity fields. [Valentina DB] Compound Indexes now will be used much better in WHERE and ORDER BY clauses. Fixes: [MySQL] Fixed CSV import into MySQL table.

New: [Data Editor] Added specialized editors for date&time, enum, geometry, UUID fields. [Data Editor] Now the value editor can be shown in the popup below the edited cell. [Data Editor] Added visual editors for JSON and HTML content. [Data Editor] Added SQL_Variant editor for SQL Server. [Data Editor] Added highlighting for cells with JSON and HTML content. [Data Editor] Picture editor now has auto-scaling and drag&drop. [Data Editor] Added an ability to set a text alignment for cells in the grid. [Form Editor] Added an ability to pass default options to report.showPrintDialog called from JavaScript. [Form Editor] Allowed the recursive import of forms. [Diagrams] Added an ability to split diagram into pages for printing. [Diagrams] Added ability to set color/font for each subitem. [Diagrams] Added property to set the default font for the whole diagram. [Query Editor] Supported composite foreign keys in the Query Editor. [Query Editor] Supported drawing links on multiple columns. [Query Editor] Added a dialog to edit links. [SQL Editor] Autocompletion menu now has a bottom line where help is printed. [SQL Editor] Autocompletion menu now can be resized with mouse. [SQL Editor] Autocompletion menu shows more tooltips about items. [SQL Editor] 'Xcode Dark' theme for SQL Editor, use it by default for dark palettes. [SQL Editor][Pro/Single] Autocompletion now suggests all fields for "SELECT tblAlias.| FROM TBL tblAlis" [SQL Editor][Pro/Single] Autocompletion menu now suggests JOIN conditions. [SQL Editor] Autocompletion now supports command "CALL procName()". [PostgreSQL] Added extended parameters for SSL connections in the connect dialog. [PostgreSQL] Show PostgreSQL partitioned tables. [SQLite] Supported generated columns (referred to as "methods" within the Valentina Studio). [Valentina DB] Implemented JSON fields. [Valentina DB] Speed of UPSERT improved about 30%. Improvements: [SQL Editor] Tooltips for table and views are more informative now. [SQL Editor] Highlight instances of a word at the caret position. [SQL Editor] Autocompletion of JOIN for Valentina DB BinaryLink works now. [SQL Editor] Change selection background in Oblivion theme. [SQL Editor][MySQL] Getting the list of built-in functions from hosts where MySQL system tables are unavailable due to restricted permissions. [Report Editor] Supported recursive reports. [Report Editor] Improved removing space reserved for not printed controls. [Dialogs] Restore saved position and size of the dialog always on the current screen. [Shortcuts] Enabled shortcuts editing in Valentina Studio Single. [SSH] Added more detailed error messages for public-key authentication, with suggestions on how to fix them [SSH] Removed active waiting for SSH (it reduced CPU utilization). [PostgreSQL] Client libraries updated to 13.1. [SQL Server] Rebuilt SQL Server client libraries to fix failed connections [SQL Server] Added hints on how to fix SQL Server failed connection [SQL Server] Improved connect dialog, removed unused control. [SQLite][Valentina DB] SQLite to Valentina DB converter improved a lot. [SQLite] SQLite engine updated to 3.34.1 Fixes: [Report Editor] Fixed printing the last column of labels in some cases. [Report Editor] Fixed zoom in the label layout. [Report Editor] Fixed printing pictures from SQLite datasources. [Form Editor] Fixed copy&paste of ComboBox control. [Server Admin][PostgreSQL] Enable Apply button on change of the role properties. [SQL Dump] Fixed quoting MySQL default timestamp values. [SQL Dump] Fixed dumping values to SQL for MySQL, SQLite, SQL Server and ODBC. [Schema Editor] Fixed creation of field for new ObjectPtr link. [Schema Editor] Close Valentina project and database automatically before unregistering. [Schema Editor]Fixed delay after applying the schema changes – don't wait for internal tasks to finish. [PostgreSQL] Fixed generation of the query to create an index (supported INCLUDE clause).

New: Valentina Studio Single Edition. With this in-app purchase, you can get all PRO features for a single database engine, except for Valentina Project development functionality (reports, forms, JavaScript) and keyboard shortcuts management. [Form Editor] Startup script. You can define some script to be a startup, so when a Valentina Project is opened, this script will be executed automatically. [Form Editor] Allowed executing forms as non-modal dialogs. [Form Editor] Added/updated JavaScript code templates to import scripts and show modal and non-modal forms. [Form Editor] Improved drawing images on Retina screen. [SQL Editor][Pro] UNSAFE Commands. SQL Editor will warn you in case of the unsafe command. This is UPDATE or DELETE without WHERE clause, which can change the whole table. [SQL Editor] Added RegEx style of auto-completion, option to choose between RegEx style and the old StartWith style was added to preferences. [Schema Editor] Ability to add Bonjour services to the bookmarks. [Schema Editor] Ability to add established connections to the bookmarks. [Schema Editor] Added "Discover Localhost Servers" command to the bookmarks contextual menu to search for database servers running on the default ports. Improvements: [Form Editor] Allowed recursive imports of forms. [Form Editor] Dialog to load an image now allows zooming in and out. [Form Editor] Added 'editTriggers' property to TableView which allows redefining the default editing behavior (e.g. perform custom script on double-click on the cell). [Script Editor] Added autocompletion for imports. [Script Editor] Show code templates in scripts. [Report Editor] Set the maximal editor layout zoom to 4x. [Server Admin] Show full last query text in the tooltip. [SQLite] Enabled SQLite FTS5 extension. Fixes: [Data Editor][Valentina] Fixed showing NULL BLOBs/Pictures. [Data Editor] Fixed Slow vertical scrolling when a table contains a lot of fields. [SQL Editor] Fixed undo after autocompletion. [SSH] Fixed failed connection when password and then key file were defined for the SSH connection. [Report Editor] Fixed export of SVG images to HTML when scaling is ON. [Report Editor] Fixed rendering wrong pictures for empty/NULL field data. [Schema Editor] Fixed crash on parsing view definitions starting with multiline comments. [Schema Editor] Fixed updating PostgreSQL links properties.

New: [Report Editor] HTML rendering engine is used, which improves the rendering of HTML a lot. The most HTML/CSS features are supported now. Among them: text formatting, tables, floating elements, absolute positioning, anchors, embedded styles, CSS classes, most CSS selectors, etc. [Report Editor] Allowed to get the current value of control via 'control.instance.value' property in JavaScript. [Report Editor] Support for SVG images in the Picture control. [Project Window] The project window shows small previews of reports. [SQL Editor] Snippets now have Run button on the left, so you can click to copy snippet into SQL Editor and execute it immediately. [SQL Editor] Snippets panel now uses the "S" button to display the scope for each snippet - scope map. [Appearance] Supported the Dark Mode. [DataEditor][Pro] Export button, which allows you to export a visible set of rows from Data Editor to CVS, Excel, HTML, JSON formats or copy to clipboard. Improvements: [Schema Editor] Improved async loading of information from remote database servers. [Schema Editor] Increased speed of refresh command. [Dump Loading] Added an option to send multiple dump statements at once which speeds up performance for remote connections. [Dump Loading] Show the start and end time of the dump loading process. [Dump Loading] Supported loading and creation of SQL With External Data Valentina Database dump files. [Dump Loading] SQLite dump loading is up to x4 times faster with a new Valentina SQLite API command (PrepareAndExecuteAllCommandsEx). Local and with Valentina SQLite Server. [Dump Creation] Added options to limit the size of data and/or the number of records in a multi-row INSERT command. [Dump Creation] Added options to limit the size of data and number of records in the SQL Server dump batch. [Dump Creation] Supported dumping all SQL Server objects visible in the Schema Editor. [Server Admin] Removed the requirement to create adminpack extension to view log files on the PostgreSQL server. [Server Admin] Show a warning if log files creation is disabled on the PostgreSQL server with info on how to enable it. [Query Editor] Display RecID/OID fields for Valentina databases. [Report Editor] HTML control now by default produces HTML in the iframe tag, and you have an option to generate HTML as a picture. [Report Editor] Ability to set the opacity for text and borders. [Data Editor] Decreased the default width of columns. [Data Editor] Filter cell now can skip $ (used as a field name replacement) in the first expression. [Sql Editor] The query contextual menu now has more commands. Fixes: [SQL Editor] Fixed crash when a user switches SQL Editor to a connection (no database selected). [DataEditor] Fixed showing tooltip for text fields with HTML content. [Server Admin] Fixes for parsing MySQL slow logs, added support for reading slow logs produced by the latest MySQL and MariaDB server versions. [SQL Diff] Fixes for databases that have schemas and constraints with the same name in different schemas [Report Editor] Fixed an extra distance between rows of labels with the left-to-right layout.

New: [Bookmarks] Synchronization of bookmarks and SQL snippets via Cloud Storage folder (e.g. Dropbox, Google Drive). [SQL Editor] SQL Snippets now can be linked to one or more databases. [Schema Editor][Pro] Duplicate command in the contextual menu of a Table. [Schema Editor] Cmd+F keyboard shortcut moves focus to the search field on the top right. [Schema Editor] Added ability to filter the first column with databases in columns mode. [Form Editor][JavaScript] Added QCoreAppliction.processEvents() static method which can be used during long-running loops (for example, to show the progress, process button clicks). [Query Editor] Added an ability to duplicate a query of the Query Editor. Fixes: [Data Editor] Fixed adding a related record for a binary link. [Form Editor] Fixed adding a new record in a form. [Form Editor] Fixed applying a custom font for all widgets. [Form Editor] Fixed highlighting of JavaScript Template Strings (e.g. `some string`). [Report Editor] Fixed execution of reports with multiple JavaScript-based expressions. [SQL Editor] Fixed hiding of autocompletion menu when we type string longer than any existing. [Data Editor] Allowed the user to open SQL Editor, Query Editor, Server Admin for active database/connection, using toolbar buttons. [SSH] Fixed sending long packets via SSH. This makes the execution of long queries more stable. [Load Dump] Update dump loading progress more frequently. [Load Dump] Show the list of errors on the last page of the Load Dump wizard.

New: * [Report Editor] Added property column_layout with options "Down" and "Right", vertical and horizontal placement of records in columns respectively. Previously only "Down" layout was supported. * [Schema Editor] Supported uploading files (Valentina and SQLite databases, projects, licenses) to the Valentina Server. * [Server Admin] Added licenses tab which displays all licenses located in the licenses folder of the Valentina Server. Licenses have different colors depending on their status, Expired, Time Remaining and so on. * [Server Admin] Added backups tab which displays backups of databases and projects on the Valentina Server. * [Project Tab] Now you can edit a JavaScript file after a single click, instead of just viewing its preview. Double click still opens files in a separate window Improvements: * [Query Editor] Don't scroll the scene area if the list of fields was scrolled before and vice-versa. * [Query Editor] Enable toolbar buttons to open new Query Editor and SQL Editor for the current database. * [Query Editor] Hide related tables panel on double-clicking the splitter. * [Script Editor] Added the 'console' option to the auto-completion list. * [SQL Editor] Autocompletion improved to show a special list "All fields of TABLE", only if we have 0 or 1 tokens between SELECT and FROM. * [SQLite] Disabled getting an exact record count in big databases. Fixes: * [Application] Fixed slowness on dragging tabs. * [Query Editor] Fixed slowness on dragging items from the lists in big databases. * [Report Editor] Fixed a few memory leaks. * [Data Editor][SQL Server] Fixed sorting by NText/Text columns in the Data Editor. * [Data Editor][SQL Server] Fixed error on getting related records if they contain NText/Text column.

Improvements: * [Report Editor] Ability to copy/paste parameters, move/delete some parameters. * [PostgreSQL] PostgreSQL 12 support. * [SQL Editor] Always convert line endings of pasted text to LF. Fixes: * [SQLite] Fixed missing links on a change to table definition. * [Report Editor] Fixed use of underscore character in the items' names. * [Report Editor] Log error on unable to compile a JS script. * [Report Editor] Fixed rendering the text field control.