Valentina Studio

Valentina Studio is the native cross-platform tool to manage the most popular RDBMS including Valentina DB, MySQL, MariaDB, PostgreSQL, SQLite, MS SQL Server... And MongoDB. 

Valentina Studio is a great choice for DB Admins, developers of applications that use databases, Students, and Business Offices. 

We provide a few Editions of Valentina Studio:

• Free  ($0) 
• Pro ($199/OS)
• Universal ($399 for 3 OS) - save $200 if you work on 3 OS;
• Single ($79/OS) - limited to 1 DB of your choice and Valentina Project excluded. 

Yes, even commercial companies can use FREE Valentina Studio. There are NO uncomfortable limits. Free Valentina Studio offers tools that you can find in other $20-90 products.

FREE Edition gives you forward engineering diagrams, and powerful Editors for managing DB Schema, Table Records, SQL Queries, DB Server Administration, Import/Export, Dumps, Backups, etc.:

• Diagram Editor - design your new db here then generate tables and other db objects from that diagram.
• Schema Editor (tree view and column view) - create/modify schema objects: Tables, Views, Fields, Enums, Links, Constraints, Triggers, Indexes, Stored Procedures, ... 
• Colorize different databases.
• Data Editor - easily browse table records in a grid, modify records, inline edit of values, sort, filter records and save favorite filters, preview images, hex editors for binary values, specify own named layouts, ...
• Related Data Editor - easily learn and manage linked records of two tables, link/unlink records by a mouse click, do set operations over linked records, ...
• SQL Editor - provides color syntax, auto-completion, recent and saved favorite queries, templates of queries, and a console with error/warning reporting, ...
• Query Editor - produce SQL queries visually in a few mouse clicks

FREE Tools:

• Import/Export Wizard -  to import/export DB data from/to XML, CSV, etc
• Server Admin - manage users, and learn logs and other parameters of a DB server.
• Documentation Generator - to generate a description of the database schema into a PDF file.
• Cloud Sync - share some of your VStudio data (bookmarks, SQL snippets virtual links, recent connections) between a few of your computers. 

RUNTIME 

• A very important feature of Free Edition is that it can open in read-only mode, but run a Valentina Project with Reports and Forms designed in the Pro Edition.

PRO Edition adds advanced Features, Editors, and Tools.  

• Valentina Project - contains Reports, Forms, and Scripts. (!) Valentina Project can be under a Valentina Server to allow multi-user work with Reports and Forms.
• Form Editor - Design Forms and script them using JSt/Python.
• Report Editor - Design Reports and script them using JSt/Python/SQL. These Reports can be printed or saved as PDFs/Pictures, directly from Valentina Studio or your Desktop/Web Applications.
• Workspaces - cool for developers who work on 2 or more projects. One-click - and all your windows, and connections to some DB servers are changed. 
• Data Transfer - transfer data from one database to another.
• SQL Diff - compare schemas of two databases.
• Schema Snapshot - allows the granulation of the schema representation.
• Source Control - provides an ability for database development using any VCS (GIT, ...)
• Documentation Generator - you can modify the style of the used report as you want.

Valentina Studio can be used around Valentina Server for multi-user work around Valentina Projects. Notice, that Valentina Server is a multi-Server (4 in 1):

• Valentina DB Server
• Valentina SQLite Server
• Valentina Report Server
• Valentina Form Server 

Reports developed in Valentina Studio can be integrated into your applications on all major programming languages (C/C++/C#/NET/Java/PHP/Xojo/LiveCode/Swift/...) via Valentina Report ADK. Still, 3 OS are supported for each ADK.