Paradigma Software announces the release of the next  generation of database, database management and reporting tools for database management and data visualization.

The company announces updates and improvements across all tools, servers and developer solutions as well as the introduction of Valentina for Python ADK.

Valentina Studio 10

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. Valentina Studio Pro 10 adds several new and useful features, including:

  • Synchronization of server bookmarks and SQL snippets via Cloud Storage (Dropbox, GoogleDrive). Prefs Panel lets you can specify the folder on an HDD where Valentina Studio will generate these two files
  • SQL Snippets now can be linked to specific database(s) you are working on. Select snippets using a contextual menu based on the database

Valentina Studio 10 for Windows, macOS and Linux is licensed but free. Valentina Studio Pro 10 is $199 per OS license and includes 12 months of free updates. Valentina Studio UNIVERSAL 10 is a single license that works on all three operating systems and licensed on a user basis.

Valentina Server 10

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. Valentina Server is licensed as a single deployment product. It is also available as a part of Valentina Developer Network, an OEM solution for software developers to deploy copies of Valentina Server to their customers at no additional cost.

Valentina Reports 10

Valentina Reports cross platform reports system is available in Valentina Reports Server, Valentina Reports ADK for embedding a reporting system into applications and Valentina Studio as a reports authoring, testing and deployment platform. Valentina Reports ADK works with all major databases including MySQL, MariaDB, PostgreSQL, MS SQL Server, SQLite and Paradigma Software's own Valentina DB, with deployment options for all major development environments on macOS, Windows and Linux. Some versions are also available for Raspbian on the ARM7 Raspberry PI platform.

Valentina Database 10

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

  • [Imp] Improved speed of non-indexed-scan algorithms between 10 to 20 times
  • New][SQL] Window Functions, a part of SQL Standard 2003-2008

Window function examples include SELECT SUM(f2) OVER ( [PARTITION BY flds] [ORDER BY flds] ), RowNumber(), Rank(), Dens_Rank(), Percent_Rank(), Cum_Dist() SUM() OVER …. This feature works over a single table, JOINs, UNIONs and more.

Valentina for Python ADK

Valentina Database ADK and Valentina Reports ADK are available on Windows, Linux and macOS (with Raspberry PI support coming soon) for Python development. The Valentina ADK Client for Python also works with Valentina Server. When available, the Linux version license will also work for the Raspberry PI components. Features include:

  • 64 bit editions for Windows, Linux and macOS (32 bit for ARM7 Raspbian coming soon)
  • Valentina Client licensing included free with Valentina Server

Valentina 10 products are immediately available for download from the Paradigma Software website. You can also read the announcement on the Paradigma Software forum.