The professional SQL database administration and reports generation software.

 Valentina Studio Pro brings together the best database administration and design tool along with a powerful, visual Report Designer for use with Valentina Reports ADK for Xojo and Valentina Server.

All Major Databases Supported by Valentina Studio

You can work with all major databases, including:

• MS SQL Server & Microsoft Azure SQL DB
• MySQL
• PostgreSQL
• SQLite (including Valentina SQLite Server!)
• MariaDB
• Valentina DB

What's New in Valentina Studio Pro 9

Valentina Studio 9 now can check through a proxy connection to see if the newest version is available. Not listed here are hundreds of fixes and improvements of existing features and compatibility with supported databases. Several editors of Valentina Studio Pro 9 now include new toolbars with advanced editing tools.

• New in 9.2! EDIT RESULT records of a VIEW query for PostgreSQL, MySQL, ValentinaDB and SQLite
• New in 9.2! Form Editor EDIT records of a VIEW query for PostgreSQL, MySQL, ValentinaDB and SQLite
• New in 9.1.5! SqlEditor uses Cmd/Ctrl + ` to toggle recents/editor
• New in 9.1.5! SqlEditor uses Cmd/Ctrl + 1/2/3/4 to switch tabs in the left panel of SQL Editor
• New in 9.1.5! SqlEditor “Duplicate Line” command renamed to “Duplicate Line(s)” - select few lines and CMD+D will duplicate them
• New in 9.1.3! MariaDB upgraded to v3.1
• New in 9.1.1! Form Editor allows sorting records, added methods: addSort(), removeSort(), applySorts(), clearSorts()
• New in 9.1.1! Form Editor adds templates of JS code to sort records
• New in 9.1.1! Form Editor allows setup sorting via Property Inspector
• New in 9.1! Forms code templates for import of the forms and scripts
• New in 9.1! Forms Implement autocompletion for imported forms and scripts (partially).
• New in 9.1! Forms can call 'needUpdate' slots on click buttons, edit text etc., to update dialogs not linked to a datasource.
• New in 9.1! Forms add property “Mode” for the LineEdit-Field control.
• New in 9.1! Forms add 'application.sessionStorage' object to store and pass data during single session
• New in 9.0.7! Form Editor can use aliases in ComboBox and ListView and use the script as source data
• New in 9.0.7! Form Editor can fill lists from a query
• New in 9.0.7! Form Editor adds macro $P!(param) for parameter that shouldn't be quoted as literal (like SELECT * FROM $P!(table_name)) for Reports
• New in 9! Project Window now has ICON VIEW for project items in addition to LIST VIEW
• New in 9! Project Window displays previews of reports
• New in 9! SQL Editor Static Analyzer errors indicator and console panel where you can see all errors found by the analyzer
• New in 9! SQL Editor has menu Default Schemas for PostgreSQL and MSSQL to see which schema(s) currently the default, and allows change
• New in 9! Schema Editor has the ability to create events for Valentina Studio Projects
• New in 8.7.2! Report Editor Summary Controls (aggregate functions) can be used in both Footer Regions and Header Regions
• New in 8.7! Diagram Editor allows Show | Hide of some FK relations within a diagram
• New in 8.7! Diagram Editor creates diagrams with ALL tables of a database. In “Add Tables” select a checkbox [x] option: Add Existing Tables
• New in 8.7! Diagram Editor drag and drop multiple tables and other objects from the left-side panel to a diagram.
• New in 8.7! SQL Editor drag and drop objects of a schema from the left sidebar of SQL Editor into the edit area. On drop, a dialog appears, where you can choose which command you want to generate and additional options
• New in 8.7! SQL Editor underline Not Resolved Idents in major SQL commands Enable | Disable
• New in 8.7! SQL Editor fromCode operation. Removes quotes and escapes in the text copied from e.g. C# or PHP into SQL Editor, in order to get a clean SQL query ready for execution within Valentina Studio
• New in 8.7! SQL Editor adds Execute Current button, allows execution of only one SQL statement, where the text cursor is located
• New in 8.6.1! SQL Editor Find/Replace now have option 'In the selection'
• New in 8.6! Sql Editor can work with SQL commands that have BIND - PARAMETERS with Parameters Panel
• New in 8.6! Sql Editor supports UNDO | REDO
• New in 8.5.5! Advanced Sql Editor toolbar with buttons to do advanced formatting on SQL text
• New in 8.5! Script Editor auto-completion for JavaScript classes/objects
• New in 8.5! SQL Editor new commands to improve editing of complex SQL texts and commands
• New in 8.5! Data Editor Copy-paste from excel directly into a Table via clipboard
• New in 8.3.3! Form Editor 'currentRow' and 'currentColumn' properties for the TableView
• New in 8.3.3! Form Editor can create QStringListModel from JS
• New in 8.3.3! Form Editor change source records for forms/subforms/table views from scripts “this.records = this.dataSource.sqlSelect( …. )”
• New in 8.3.3! Form Editor ability to use the query with parameters for the form
• New in 8.3.3! Form Editor methods queryParameterValue/setQueryParameterValue to Form/SubForm/TableView
• New in 8.3.3! Report Editor ability to convert the controls to other types via the context menu, for example, it allowing converting a field control to the a checkbox control
• New in 8.3.2!Form Editor HyperLink control opens a default browser window with the specified URL or executes a custom script
• New in 8.3.2! Form Editor Image Field control displays an image stored in the BLOB/Picture field or loaded by the URL stored in the textual field
• New in 8.3! Valentina Forms can be based on an SQL Query
• New in 8.3! Valentina Forms Sub Forms for Table/View/Query
• New in 8.3! Valentina Forms can display related records in the TableView using the map of fields or map of parameters
• New in 8.2!SQL Editor displays progress of export to SQL, with the ability to stop the export
• New in 8.1! Form Editor adds actions to add/remove filter
• New in 8.1! Form Editor adds 'clearFilters' method for cursors
• New in 8.1! Form Editor adds 'returnPressed' slot for line editors
• New in 8.1! Form Editor 'key' argument for 'addFilter' now optional
• New in 8.1! PostgreSQL dump now uses pg_dump binaries as is (Before we compiled their sources inside of our vs_postgre_plugin)
• New in 8.1! PosgtreSQL download another version of pg_dump (newer or older) and set Valentina Studio to use it
• New in 8.1! PostgreSQL Valentina Studio can find and download newer binaries of pg_dump from Github
• New in 8.0.1!Form Editor use VIEWS as data sources in Valentina Forms
• New in 8! Form Editor visually create | execute | save Valentina Forms to Valentina Projects
• New in 8! Form Editor Drag-drop widgets, controls and layouts, resize layout canvas to visually create forms
• New in 8! Form Editor register and edit Valentina Projects with Valentina Forms to Valentina Server
• New in 8! Forms widgets, controls, and layouts in Valentina Forms scriptable with JavaScript
• New in 8! Forms Documentation for all classes, enums, global constants and more for use in JavaScript in Valentina Forms
• New in 8! Snippets library for often used code snippets and custom code snippets
• New in 8! FREE Valentina Studio acts as a runtime for local and server-registered Valentina Projects
• New in 8! Array Editor inside of Data Editor supports new ARRAY field type in ValentinaDB

Valentina Studio Pro is available for Windows, MacOS and Linux. Your order of Omegabundle for Xojo 2019 includes your choice of one operating system version.

Data Modeling

Model databases visually with the premier Database Schema Editor reverse and forward engineering tool. Generate diagrams automatically from existing databases. Add new elements visually with PRO.

Visual Report Builder

Transforms queries into visually stunning enterprise reports with full suite of design elements: charts, graphs, barcodes, grids, images, html objects, labels, text boxes and more. Reports are saved into Valentina Projects.

Query Builder

Build SQL queries visually with Query Builder. Work directly with tables and links that are a part of the query you want to create. Copy-Paste your generated queries with PRO.

Data Transfer

Copy records between two different databases. This feature is different from simply importing data. Use Data Transfer to choose one database as a Source. Then choose another database to be the target database. You can then specify mapping of source/target tables and fields and load records from db1 to db2.

SQL DIFF

Compare schemas of two databases and produce SQL scripts that can transform the first schema into the second. Apply changes directly to the first database.

System Requirements

These are the Valentina Studio System Requirements for Valentina Studio 6 or later.