Valentina Studio

Valentina Studio is a cross-tool for database architects, developers, DBAs and even end users to work with the most popular RDBMS such as MySQL, PostgreSQL, SQLite, SQL Server and ValentinaDB. You can do data modeling using different diagrams, work with database schema and records, do SQL development, do server administration, etc.

In PRO Edition ($199) you can develop a Valentina Project where design Reports and Forms automating them using JavaScript. This project can be used in multi-user way if you put it under Valentina Server.

In PRO Edition ($199) you can develop a Valentina Project where design Reports and Forms automating them using JavaScript. This project can be used in multi-user way if you put it under Valentina Server.

FREE Edition brings you powerful, visual editors including:

• 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 and modify all schema objects of supported databases: Tables, Views, Fields, Enums, Links, Constraints, Triggers, Indexes, Stored Procedures, ...
• 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, ...
• 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 - with color syntax, auto-completion, recent an saved favorite queries, templates, console with error/warning reporting, ...
• Query Builder - build SQL queries visually using just a few mouse clicks.
• Server Admin - where you can manage users, learn logs and other parameters of servers.

PRO Edition adds more tools:

• Valentina Project - keep here reports, forms, javascripts
• Form Editor - design forms
• Report Editor - design reports

Open as many editors as you like at the same time for different databases/servers opened in tab-panels. You also get different DB related utilities, including Import/Export, Dumps, Diagnose, Clone, Reindex, ...

Note: Now requires OS X 10.12 or later

New:

• [Form Editor] Added code templates for import of the forms and scripts.
• [Form Editor] Implemented autocompletion for imported forms and scripts (partially).
• [Form Editor] Call "needUpdate" slots on click buttons, edit text etc., to update dialogs not linked to a datasource.
• [Form Editor] Added property "Mode" for the LineEdit-Field control.
• [Form Editor] Added "application.sessionStorage" object to store and pass data during a single session.
• [Form Editor] Allowed sorting records, added methods: addSort(), removeSort(), applySorts(), clearSorts().
• [Form Editor] Added templates of JavaScript code to sort records.
• [Form Editor] Allow to setup sorting via Property Inspector.
• [Schema Editor] Add button to toggle preview panel in Schema Editor for tree mode.

Improvements:

• [SQL Editor] Opt-Click on an object name now select this object in the tree, instead of open another Schema Editor.
• [SQL Editor] Ability to display non-printable characters in SQL Editor.

Fixes:

• [Data Editor] Fixed pasting tabular data to the database with schemas.
• [SQL Editor] Fixed renaming a SQL Snippet.
• [Form Editor] NULL values are not handled in the ComboBox.
• [Schema Editor] Rightmost column sometimes is not visible.
• [Data Transfer] Transfer of a database with schemas.
• [Data Editor] Limit auto width of columns to parent table width.
• [Diagram Editor] Fixed rendering the tab titles of the object editors.