Valentina Release 14.5 adds DuckDB Support, ARM7 for Valentina Studio

Valentina Release 14.5 Adds DuckDB Support, Embedded XML in Reports PDF

Also, improvements for SQLite Server, Pre-Connect Scripts and more.

This release includes initial support for DuckDB on the Valentina Platform. More support is planned for future releases.

Valentina Studio FREE | Single | PRO

Valentina Studio is the free, all purpose database management 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.

  • [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. Other improvements are forthcoming in future releases.
  • [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 arm64-based system, such as Raspberry Pi. See folder “lin_arm_64” on the FTP.
  • [Imp][SQL Editor] Auto-scroll SQL Text to a placeholder and highlight it, when you choose it in the panel ‘Parameters’.
  • [Imp] Improvements for execution of the pre-connect scripts. Dynamically adjust settings like database name, username, password, host, port, and other connection attributes according to specific needs or runtime conditions.
  • [Imp] In the post-connect script of the bookmark, the connection and database objects are added to the result, allowing for initialization.
  • [Imp] Added code completion for pre-connect and post-connect script editors.
  • [Imp] Updated German and Ukrainian translations.
  • [Fix] SQL formatter has issue with !=
  • [Wiki] Added description of pre-connect and post-connect scripts

Valentina Reports

ADK or Valentina Application Developer Kits incorporate the runtime engines of Valentina technologies into your applications. Valentina Reports ADKs allow developers to embed reporting into their applications. ADKs are available for many native development systems including C/C++, Java, .NET, Swift, Xojo and more on Windows, macOS & Linux.

  • [New][Datasource] – DuckDB. Currently, only supported in Valentina Studio, but soon in all Valentina Report ADKs
  • [New] – Set up a Report to have embedded XML data inside of the generated PDF. For this use the option ‘xmp_data’ of the Report and its Report Controls.
  • [Imp] – Allowed to specify RAM SQLite database (:memory:) to use with JS queries from ADKs.

Valentina DB

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

  • [NEW] UTC SQL-functions have optional second param – TimeZone (String)

Valentina SQLite Server

Valentina Server incorporates Valentina Reports Server, Valentina Forms Server and two database servers: Valentina DB Server and Valentina SQLite Server. Available for Windows, Linux, macOS and Raspberry PI.

  • [NEW] Sub-folders for SQLite databases. Valentina Server INI now includes a variable SQLITESYSTEMCATALOG. Previously SQLite databases were stored in a single, specified directory. Sub-folders are now supported.

See the original announcement on the Paradigma Software forum.