Valentina Studio 12
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 (Intel and ARM) in four versions: Free, Single, Pro and Universal. Valentina Studio Free is available at no cost, but licensed. Valentina Studio Single ($79) supports a single database type, selecting from MySQL / MariaDB, MS SQL Server, PostgreSQL and SQLite. Valentina Studio Pro ($199) supports all databases including with Valentina Studio 12, MongoDB, plus adds project based features including Forms, Reports, Diagramming and more. Valentina Studio Universal ($399) has all of the features of Valentina Studio Pro plus a flexible license that allows a single user to use it on macOS, Windows and Linux. Valentina Studio 12 includes two powerful new features:
- [New] MongoDB Support. The first NON-SQL database in Valentina Studio includes support for the document-centric database, including: MongoDB Schema Editor, MongoDB Command Editor, MongoDB Collection Editor and MongoDB Server Administrator. YouTube Video
- [New] [PRO Only] Workspaces. Custom, “clean room” management of collections of tools, connections, settings and more, including Bookmarks, SQL Snippets, Recent databases, Recent projects, Open connections, Open local databases and Query log. All Workspaces can be synchronized with the cloud storage (e.g. iCloud, Dropbox, etc) if you have enabled this option in the preferences.
MongoDB from Mongo Inc is a source-available cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with optional schemas. MongoDB stores documents that can have varied structures and does not require a schema, so you do not have to define the structure of your database first. You can add new fields at any time and use any type of value. Related data can be stored together to improve speed of queries.
All versions of Valentina Studio include several other improvements, including improvements to bookmarks, tool tips, and exporting bookmarks and snippets.
Valentina DB is Paradigma Software advanced, object-relational database and is available in Valentina DB Server (a part of Valentina Server) and Valentina DB ADKs (developer components for adding runtime database support to applications). ValentinaDB includes two technology advances:
- [New][SQL] Create JOINs between two different databases
- [New][SQL] Triggers on Links. You can CREATE TRIGGER, which will work on LINK / UNLINK commands – events
Support for these features are also included in working with other Paradigma Software technologies including Valentina Reports and Valentina Forms.
ValentinaDB ADK 12 (starting at $199) for embedding a reporting system into applications with support for C, C++, Java, Python, ODBC, Xojo, LiveCode and more. Some versions are also available for Raspbian on the ARM7 Raspberry PI platform.