Extensibility for ultra-fast data platform, encryption and client-integration for iOS among improvements.
Paradigma Software announces the immediate availability of Valentina Release 16, the best, all purpose data management suite of tools and developer data platform solutions for deployment on Windows, Linux, macOS, iOS and the cloud.
Valentina Technology Update 16
Most Valentina products natively incorporate three internal database systems: ValentinaDB, SQLite and DuckDB. ValentinaDB is Paradigma Software’s flagship high performance database system with over 25 years of updates and improvements.
- ValentinaDB Extensions. You can build custom extensions for the ValentinaDB database system using C, C++, Python or JavaScript. These can include scalar functions, aggregate functions and procedurals that can provide access to external data sources and file formats.
- Regression Analysis. SQL 2003 aggregate functions for regression analysis are added to ValentinaDB (REGR_SLOPE, REGR_INTERCEPT, REGR_COUNT, REGR_R2, REGR_AVGX, REGR_AVGY, REGR_SXX, REGR_SYY, REGR_SXY).
- SQL Improvements. The RETURNING clause can now be used with the INSERT statement in ValentinaDB
- SQLCipher Encryption for SQLite. Encrypt, modify and decrypt SQLite databases using this popular, open source 256 bit AES encryption of database files and other security features
- Architectural improvements. Third party engines become extensions. JavaScript, Python, DuckDB and SQLite are re-engineered as extensions. This makes it possible to remove the engines if they are not needed for deployment
Valentina Technology Update is included across all Paradigma Software products including: Valentina Studio (Free Version), Valentina Studio PRO, standalone versions of Valentina Server, and Valentina Developer Network, an OEM developer product that allows developers to deploy copies of Valentina Server to their customers, royalty free and no limits on numbers of deployment.
Valentina Studio 16
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. Studio 16 and Studio PRO 16 adds several new and useful features, including:
- Improved Query Editor. Query Builder was completely rewritten. Create and edit queries without any knowledge of SQL. You can also immediately execute the SQL that you generate and display the results.
- SQLCipher Encryption Tools for SQLite. Visual tools for encrypting and decrypting SQLite databases using this popular, open source 256 bit AES encryption of database files and other security features.
Valentina Studio 16 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 16 is a single license that works on all three operating systems and licensed on a user basis.
Valentina Server 16
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. These include:
- Valentina Reports Server. Serve visually compelling reports with charts, graphs, bar/QR codes, images and more from the supported data sources as images, html or PDF. Deliver them using the built in email services and scheduler. You can allow customers to view them on a network using the free Report Viewer. Reports support two scripting systems: Python and JavaScript.
- Valentina Forms Server. Serve custom, visual forms (similar to Microsoft® Access or Claris® FileMaker Pro) from Valentina Server (on macOS, Windows or Linux) to anyone using the free form hosting system built into free Valentina Studio.
It is available on Linux, macOS and Windows. Valentina Server 16 adds all of the Valentina Technology Release 16 features, including:
- ValentinaDB Extensions. Valentina Server supports ValentinaDB extensions built with C, C++, Python and JavaScript.
- SQLCipher Encryption Tools. Valentina SQLite Server supports SQLCipher security for encrypting and decrypting SQLite databases using this popular, open source 256 bit AES encryption of database files.
- Improved Client integration for iOS. Build Cocoa Touch applications using Swift that integrate with ValentinaDB Server, Reports Server, Valentina SQLite Server and Valentina DuckDB Server
- Improved Client integration for macOS. Build Cocoa applications that integrate with ValentinaDB Server, Reports Server, Valentina SQLite Server and Valentina DuckDB Server
You can use Valentina Server with five simultaneous connections for free on macOS, Windows and Linux. Standalone, commercial versions start at $299. Valentina Developer Network starts at $599.
In addition, Paradigma Software offers:
- Valentina Database ADK. Developers can add Valentina database runtime engines and storage to their local applications. 30+ platforms available. Valentina Database ADK starts at $199.
- Valentina Reports ADK. Developers can add report generation runtime engines to their local applications. 30+ platforms available. Valentina Reports ADK starts at $199.
Valentina 16 products are immediately available for download from the Paradigma Software website.