Other productivity improvements to Valentina Studio and working with ValentinaDB files.
Valentina Studio
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. Improvements include:
- [New][SQL Editor][Pro] Visual EXPLAIN (of SQL). Works with all databases that support this feature (not available for MongoDB or SQLite). You can try it in Studio Free Edition up to 3 times per launch.
- [New][Data Editor] New button to easy locate a Field you need. Helps when a table has many fields.
- [New][Schema Editor] Link objects of all types now have the contextual menu item: “Open Data Editor”. Double clicking a Link also automatically opens it in the Data Editor, similar to Table objects.
- [Imp][Schema Editor] For ValentinaDB, adds a confirmation dialog, related to the ‘Compressed’ checkbox in the Inspector panel.
Valentina Server
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: Valentina Reports Server and Valentina Forms Server.
- [Imp] [DuckDB Server] [SQLite Server] On start, Valentina Server creates empty directories ‘databases_duckdb’ and ‘databases_sqlite’, so that user can drag and drop databases into those directories.
Valentina Reports
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 many more on Windows, macOS & Linux. Valentina Reports Server is a part of Valentina Server.
- [New][VReport] Export Reports to ODS format. ODS file ( Open Document Spreadsheet) is an open-source spreadsheet format used to store, organize, and analyze data in rows and columns.
ValentinaDB
ValentinaDB is Paradigma Software advanced, object relational database and available in ValentinaDB Server (a part of Valentina Server) and ValentinaDB ADKs (developer components for adding runtime database support to applications).
- [Imp] Optimized opening of files to do less work.
This release is now available on the Paradigma Software download site. See the original announcement in the Paradigma Software forum.