Forms, Reports & Stored Procedures on Server gain unified Python and JS support.
This major release incorporates Python scripting across all major features of the Valentina product line, including Valentina Forms, Valentina Reports and also for ValentinaDB stored procedures. The support for Python includes use of third party libraries, including the 160+ that come with Python and incorporated into the Python implementation for Valentina.
In addition, previously different JS implementations in different products are now unified using a single JavaScript engine for the best consistency and reliability across all products.
Valentina Studio 14
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 14 adds several new and useful features, including:
- [New] – Reports Designer updated to support Python, in addition to JS
- New] – Forms Designer updated to support Python, in addition to JS
- [New] – Added Scripting Environment documentation, available from the menu Help. It describes classes and modules you can use for forms, scripts and reports.
- [New] – Updated car_catalog example and renamed to car_catalog_js. Added an online example, car_catalog_python, where all scripts are implemented using Python
- [Imp] – Added the ability to export only queries on the Query Log tab
Valentina Studio 14 for Windows, macOS and Linux is licensed but free. Valentina Studio Pro is $199 per OS license and includes 12 months of free updates. Valentina Studio UNIVERSAL 14 is a single license that works on all three operating systems and licensed on a user basis.
Valentina Reports (including ADKs)
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] Reports can be scripted with Python, in addition to JS
- [Imp] – Standalone scripts stored in the project can be loaded using theproject.loadModule method in expressions and scripts executed during report generation (previously supported in Valentina Forms only).
Valentina Database (including ADKs)
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] – Stored Procedures can use JavaScript or Python now.
- [New] language_clause : LANGUAGE { SQL | VALENTINA_PYTHON | VALENTINA_JS )
- [New][SQL] – character_string_literal now can be dollar-quoted: $$some’literal$$, yet with tag name: $tag$some’literal$tag$
- [Info] – VKERNEL.DLL contains: quickJS; python (v3.12) and libs required for it, including zip, z2, curl, readline, ffi.
Valentina 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 (x86, ARM64), macOS and Raspberry PI.
- [New] – Stored Procedures can use JavaScript or Python now.
Valentina 14 products are immediately available for download from the Paradigma Software website. You can also read the announcement on the Paradigma Software forum.
About Paradigma Software
Paradigma Software Incorporated was established in 1998 as an Oregon, USA based corporation. Paradigma Software launched its first product, the post-relational, columnar database technology Valentina, based on the groundbreaking work of Ruslan Zasukhin in advanced database research. Mr Zasukhin's research was to develop a database system that bypassed the severe constraints on traditional relational database systems as they grow in size and complexity. ValentinaDB maximizes available resources by making data based tasks extremely fast and efficient. Since then, it launched a suite of developer tools that include support for most popular database management systems, reporting and visual forms.