Valentina Release 17.5.1 Improves Valentina Server Extensions Management

New Xojo examples, updated DuckDB support, Data Editor productivity & more.

The DuckDB engine updated in all products to v1.5.4.

Valentina Studio

Valentina Studio is the free, all purpose database management tool suite. Valentina Studio PRO adds more powerful diagramming features, more powerful visual builder tools for databases, forms creation, reports designer and more. Improvements include:

• [New][Start Page] Added Parquet cloud examples that are available for download from the Start Page.
• [Imp][Schema Editor][ValentinaDB] The database creation dialog now remembers the last used settings.
• [Imp][Data Editor] Large record counts are now formatted using locale-aware separators (e.g. 1,000,000).
• [Imp][Data Editor] Find Column is now available from the Records→Find Column… menu item and by shortcut: Cmd+Shift+K on macOS, Ctrl+Shift+K on Windows/Linux. The column lookup dialog now supports Up, Down, and Esc keys.
• [Imp][Schema Editor] Record counts are now formatted using locale-aware separators (e.g. 1,000,000) in the Property Inspector.
• [Imp][Form Editor] Improved error handling when adding or updating records.
• [Imp] Updated language translations.
• [Fix][Data Editor] Fixed paging after switching from a high page in one table to a smaller table. This prevents the grid from becoming empty after the switch.
• [Fix][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.
• [Fix][Data Editor] Fixed filtered record counts in the status bar when paging is used.
• [Fix][ValentinaDB] Fixed BLOB and Picture field handling when limited BLOB data is returned as text. This fixes the Picture control in related SubForms.
• [Fix][Data Editor][DuckDB] Fixed handling of DuckDB VARIANT Object, Array, and Geometry values in query results and record updates.
• [Fix][Query Editor] Adjusted the query panel width so buttons fit correctly in all UI languages.

Valentina Server

Valentina Server is a powerful platform for building network or cloud based client-server or server-only solutions that integrates with 30+ developer platforms. Valentina Server includes three built in database servers: ValentinaDB Server, Valentina SQLite Server and Valentina DuckDB Server. With support for both internal data sources as well as external data sources (including MySQL, MariaDB, PostgreSQL, MS SQL Server, MongoDB and more), it also includes two other servers that can leverage all supported data sources: Valentina Reports Server and Valentina Forms Server.

• [New] Added server INI settings for user extension folders: Extensions_VDB, Extensions_DuckDB, and Extensions_SQLite. Default folders are extensions_vdb, extensions_duckdb, and extensions_sqlite. Valentina Server creates these folders automatically at startup if they do not exist. Relative paths are created relative to the Valentina Server application folder. Absolute paths can point outside the Valentina Server folder and are created as specified, if the server process has permission. These folders are intended for user-installed extensions. ValentinaDB system extensions remain in the vcomponents folder. DuckDB Server now installs extensions in the Extensions_DuckDB folder, when you use INSTALL command. Additionally, for DuckDB, there are `DuckDBHomeFolder`, `DuckDBSecretFolder` and DuckDBTempFolder` INI variables for DuckDB home-folder, secret-folder, and temp-folder respectfully. For SQLite, Extensions_SQLite is a convenience folder setting. When loading SQLite extensions, the full extension path still must be specified.

ValentinaDB

ValentinaDB is Paradigma Software advanced, object relational database and available in ValentinaDB Server (a part of Valentina Server) and ValentinaDB ADKs (developer components for adding runtime database support to applications).

• [New][API] Added Valentina.SetUserExtensionsLocation( ) API for setting the user extensions folder before extension discovery.
• [Fix] Fixed a rare issue during import of very large CSV files (>70GB)

This release is immediately available on the Paradigma Software website. See the original announcement on the Paradigma Software forum.