Valentina Release 17.5.2 Improves Valentina Studio Query Editor

Extends support for DuckDB in Valentina ADK for C++ and Xojo.

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][Query Editor] Added column ‘Nulls’ to control “ORDER BY fld [NULLS FIRST | LAST]” clause.
• [Imp][Query Editor] Added an empty-scene placeholder with a message guiding users to add tables, views, or links. Adjusted the grid-line color for improved visual clarity.
• [Fix][Report Editor] Hid the expression editor button for Equal To, Less Than, and Greater Than conditional expressions. Added input validation and a placeholder for these conditions, and added tooltips.
• [Fix][Query Editor] Query editor cleanup for empty SQL.
• [Fix][Query Editor] Query cleanup when removing tables from the diagram.
• [Fix][Query Editor] Issue preventing the addition of more than 5 fields in the grid.

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.

• [Imp][Docker] Added the tzdata package and set UTC as the default timezone in the Valentina Server Docker image. You can specify a different timezone using the TZ environment variable

docker run -d \
  --name vserver-tz \
  -e TZ=Europe/Berlin \
  -p 25435:15432 \
  paradigmasoft/valentina-server:latest

Valentina C++ ADK

Valentina Database and Reports ADKs are available for C++ development as standalone solutions for developers, and include a free CLIENT component for native integration with Valentina Server. Improvements include:

• [New] Implemented I_DuckDBStatement::Bind_* methods for all DuckDB-supported data types, including Date, Time, DateTime, HugeInt, and more

Valentina for Xojo

The Xojo development environment supports multiple compile targets, including macOS, Windows, Linux, iOS and more. Valentina Database and Reports ADKs are available for Xojo as standalone solutions for developers, and include a free CLIENT component for native integration with Valentina Server. Improvements include:

• [New] Native bind methods in VDuckDBPreparedStatement.
• [Imp] stability after Shutdown() method call.
• [Imp] Added the SelectSQLEx method, allowing the cursor location to be specified for ValentinaDB, SQLite, and DuckDB RBDB prepared statements (Xojo Database API).
• [Fix] Fixed client-mode operation with Valentina Server when initialized using Valentina.InitClient without calling Valentina.Init.

This release is immediately available on the Paradigma Software website. Find the original announcement on the Paradigma Software Forum.