Valentina Release 18.1.1 adds CLI, Query Editor Improvements

Release also includes improved Valentina Server set up & security, DuckDB support and more.

Release 18.1.1 follows a major update to the Valentina Platform with Release 18. Release 18 added full-text search to ValentinaDB, introduced a new Chart control to Valentina Reports and Valentina Forms, expanded the Valentina Forms toolbox, enhanced productivity features of Valentina Studio SQL Editor and Data Editor and the ability to use AI Ask and Agent modes with Valentina Forms.

Valentina Studio

Valentina Studio is the popular, free database and data source management suite of tools from Paradigma Software. Valentina Studio PRO adds advanced features to the Studio toolbox, including Report Designer and Forms Designer. Valentina Forms is your solution for building and deploying desktop-based database management systems for custom data-tracking applications with graphical user interfaces with free, royalty free local and server based deployment. Users can work with Forms projects on Linux, macOS and Windows. This release includes:

  • [New] [VCLI] Valentina Studio packages include the first release of the vcli command-line SQL client.
  • [New][Form Editor] Added automatic navigation-button creation for SubForms, using the standard first, previous, next, and last-record icons.
  • [New][Form Editor][TableView] Added scrollToTop() and scrollToBottom() methods for scripted table navigation.
  • [Imp][Query Editor] Added sorting and pagination to nested queries.
  • [Imp][Query Editor] Added database-specific pagination for SQL set operations.
  • [Imp][Query Editor][DML] Nested Query layers always use SELECT mode, including below an INSERT, UPDATE, or DELETE main query.
  • [Imp][Form Editor][Scripts] Event-handler templates now generate Python self or JavaScript this according to the form’s scripting languages
  • [Imp] Updated translations.

Valentina Studio is free. Valentina Studio PRO costs $199. Available on Linux, macOS and Windows.

Valentina Server

Valentina Server is a 5-in-1 solution that includes Valentina Reports Server and Valentina Forms Server, as well as three internal database servers: ValentinaDB Server, Valentina DuckDB Server and Valentina SQLite Server. Valentina Reports Server and Valentina Forms Server work with all major data sources, such as PostgreSQL, MySQL, Microsoft SQL Server and others, as well as the internal database servers. Valentina Server is available as a standalone, single deployment solution, or as a developer OEM solution that allows developers to redeploy unlimited copies of Valentina Server to their customers.

  • [VCLI] Valentina Studio packages include the first release of the vcli command-line SQL client.
  • [Chg][Security] Added an explicit two-stage administrator bootstrap flow for new installations.
  • [Imp][Security] Administrator credentials can be supplied through VSERVER_ADMIN_USER and VSERVER_ADMIN_PASSWORD or through the [SETUP] section of vserver.ini.
  • [Imp][Installers][Docker] Linux, macOS, and Windows installers and Linux and Windows container entrypoints now bootstrap the administrator before starting the normal service.

Valentina Server is available in a free evaluation version, a single deployment version (starting at $299.99) and through the OEM developer program Valentina Developer Network (starting at $599.99). Available on Linux, macOS and Windows.

ValentinaDB

ValentinaDB is the advanced, post‑relational, extensible columnar database system deployed by ISVs, SaaS, cross-platform developers and vertical solution providers for over 20 years, that require an extremely fast data platform. ValentinaDB 18 introduced powerful, elastic-search-like full-text search as well as other improvements. This update includes:

  • [Imp][Schema] Schema object names can now begin with a digit

ValentinaDB is available in several products. Database ADK (starting at $199.99)  is the database engine that developers can embed into their applications and deploy royalty free and available for all major development environments including: C, C++, Objective-C, .net (C#), Java, Python, Ruby and others. Some versions of Database ADK may also support DuckDB and SQLite. ValentinaDB Server is a part of Valentina Server, available as a single deployment ($299.99) or in the OEM redistribution Valentina Developer Network (starting at $599.99).

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:

  • [Chg][Prepared Statements] Prepared-statement bind methods use zero-based value indexes again for ValentinaDB, SQLite, and DuckDB

All products are immediately available for download from the Paradigma Software website.

About Paradigma Software

Paradigma Software, Incorporated is an advanced data technology company founded in the late 1990s with the introduction of ValentinaDB, a post‑relational, columnar database engine. The company delivers high‑performance, developer‑focused tools for building modern data‑driven applications. Its products are used by developers, DBAs, and data professionals who need powerful and flexible database and reporting solutions. Valentina Studio provides database administration, reporting, and visual forms with support for Python and JavaScript, while Valentina Server offers a deployment platform supporting ValentinaDB, SQLite, and DuckDB. Together, these technologies enable organizations to design and manage sophisticated data solutions across desktop, server, and embedded environments.