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, ...

Valentina Studio:

New:

• Sql Editor (Pro) - Ability to work with SQL commands that have BIND - PARAMETERS
• When you type or copy paste SQL command with bind parameters (?, :n, $n - different for each DB), SQL Static Analysator recognizes parameters and show them in the new right-panel "Parameters"
• Use this panel to specify values for each parameter before executing the query
• Button "hide/show parameters panel"
• Checkbox "Use Parameters" - allows you to send SQL command that has parameters as a regular command. You may want to do this, e.g. for stored procedures
• Values of parameters are saved into Recent Queries
• Sql Editor - 2 buttons added UNDO / REDO

Improvements:

• Form Editor (Pro) - now you can select many controls and edit them together
• Sql Editor - notice on the picture above, tab-panel 'Templates' on the left. We have extracted templates from the 'Snippets' panel
• ValentinaDB - Data Editor did not show numeric values for some types

Fix:

• SqlAnalyzator - func_name() was not recognized correctly if func_name matched a keyword

Valentina Server:

Fix:

• Some MT issues with Locale class

Valentina for Xojo:

Fix:

• Fixed issue with Class Way + Server when db is modified on the vserver, not by app