Valentina Release 15.4 improves Valentina Studio productivity, Valentina Server

DuckDB updated to 1.3.1, SQLite to 3.50.1 and more.

This release offers more updates and improvements for Valentina 15.x.

Valentina Studio FREE | Single | PRO

Valentina Studio is the free, all purpose database management, reports and forms client tool. Valentina Studio Pro combines database management with diagramming, forms creation, reporting and database continuous integration. Available on Windows, Linux and macOS.

• [Imp] [DuckDB] Updated to support version 1.3.1
• [Imp][SQLite] – Updated to support version 3.50.1
• [New][Start Page] – Progress bar is now displayed during the first Bonjour connection scan (in the Bonjour column)
• [New][Start Page] – Added buttons to toggle filters in the Start Page columns
• [New][Data Editor] – Added connection icon to the toolbar
• [New][Data Editor] – A yellow warning icon is now shown at the bottom of the editor, with a tooltip if the table has no primary key or unique field. This feature is also available in the “Create Table” dialog.
• [Fix][Diagrams] Fixed the creation of new links on diagrams.
• [Fix][Diagrams] Enabled auto-growing of the table control when adding fields.
• [Fix][PostgreSQL] “Infinity” date was not working correctly in the PostgreSQL Data Editor
• [Fix] ENUM values were not displaying as a dropdown
• [Fix][Tip] [x] Show on startup

Valentina Server

Valentina Server incorporates Valentina Reports Server, Valentina Forms Server and three database servers: Valentina DuckDB Server, ValentinaDB Server and Valentina SQLite Server. Available for Windows, Linux (x86, ARM64), macOS and Raspberry PI.

• [New] Introduced support for setting an “application name” for client connections, visible in the server’s connection list and logs.
• [Imp] [DuckDB Server] Updated to support version 1.3.1
• [Imp][SQLite Server] – Updated to support version 3.50.1

Valentina Database ADK

Valentina Database ADK connects to Valentina DB Server (a part of Valentina Server) and incorporates both ValentinaDB and, on selected platforms, DuckDB for local database storage. A local storage option is available.

• [New] [ADK] Added the “AppName” property to the VClientInfo class. You can use this with Valentina Server to identify the application name in the server logs
• [Imp] [Selected ADKs][DuckDB] Updated to support version 1.3.1

ValentinaDB

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

• [Fix] Indexed word searches were not functioning correctly
• [New] Added standard SQL aggregate functions: VAR_POP(), VAR_SAMP(), COVAR_POP(), COVAR_SAMP()
• [Chg] Renamed STDDEV() function to STDDEV_SAMP() for consistency with the SQL standard

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