Valentina Studio provides all the features of some commercial database management products at no cost. Valentina Studio Pro features provide advanced features and productivity tools, for data management, database design and reporting.

Compare Valentina Studio FREE | Valentina Studio Single | Valentina Studio PRO

Features marked with a ✓ are fully enabled. Features marked with an "L" are limited in some way. Features of Valentina Reports that are specific to Reports and not the Reports Viewer or Editor are not found on this document.

Valentina Studio Single supports a single database (MySQL, PostgreSQL, etc) on a single operating system and doesn't support Valentina Project (forms, JS scripts, reports etc) except in read only mode (as with Valentina Studio FREE).

You should always evaluate Studio first to ensure Valentina Studio Pro is the right solution for you.

  Studio vs Single vs Studio Pro
Studio Single Pro Added

GENERAL

Operating System

Windows 32 & 64 bit versions 1.0
Linux 64 bit version (32 bit dropped with 9.5) 2.0
macOS 64 version (32 bit dropped with 9.5) 1.0

Datasources

MS SQL Server 2000+ 6.5
MS Azure 6.5.10
MySQL 5.0.6+ 5.0
MariaDB 5.2
PostgreSQL 8.4+ 5.0
SQLite File 3.0.7+ 5.0
Valentina SQLite Server 3.0.7+ 5.0
Valentina DB File 2.X-5.X with Conversion 2.0
Valentina DB File 6.X + no conversion 6.0
Valentina DB Server 4.8
ODBC (Excel, Access, etc) 1.0

Database Continuous Integration

Schema Snapshot   7.0
SQLDIFF L 5.0
Source Control   7.0

Error Look Up

MS SQL Server   6.2
Valentina DB   6.2

SQL Search

Search via Open Connection | Bonjour | Bookmark   5.2.4
Search Filter Constructor   5.2.4
Advanced Pattern Matching   5.2.4
Result Object Browser   5.2.4
Result Path Browser   5.2.4
Open Found in Schema Editor   5.2.4

Utility

Data Transfer | ODBC Import   ✓  5.1
Save | Load Mapping of Import Wizard   ✓  10.4.12
SSH / SSL Secure Connection 5.1
CLI Print Reports via Terminal or Script 6.4
SQLite DB to Valentina DB Converter 7.0
ValentinaDB Diagnose | Clone | Compact | Defragment 6.0
SQLite DB Diagnose | Compact 6.0

Productivity

UI Toolbar | Tabs | Property Inspectors 2.0
Tooltips | Contextual Menus 2.0
Keyboard Shortcuts 2.0
Keyboard Shortcuts Sets / Warnings   ✓  7.0
Import / Export Bookmarks (Connections) 2.0
Synchronize Bookmarks & Snippets via Cloud (Google Drive, Dropbox)   ✓  10.0
Snippets can be associated with specific databases   ✓  10.0
Enable | Disable Examples from Prefs   ✓  10.0.1
Colorize Connection | Database | Table   ✓  7.4
macOS Dark Theme 10.4

SERVER MANAGEMENT

MySQL Server Administration

MySQL Add | Drop | Alter User 2.5.3
MySQL Server State 5.5
Disconnect User 2.5.3
Edit Server Parameters 5.5
View Logs 5.5
Filter-out command “DELIMITER delim” 9.7.3

PostgreSQL Server Administration

PostgreSQL Add | Drop | Alter User 5.5
PostgreSQL Server State 5.5
Disconnect User 5.5
Edit Server Parameters 5.5
View Logs 5.5
Notification Channels in Schema Editor 6.2
Domains in Schema Editor 6.3
User Defined Type (UDT) in Schema Editor 6.3
Use pg_dump binaries, Auto-Update pg_dump binaries 8.1
Edit RESULT of VIEW for PostgreSQL 9.2
Edit category property (FUNCTION or PROCEDURE) 9.7.3
Display readable function arguments in DROP confirmation dialog 9.7.3

Valentina Server Administration

Valentina DB Server Add | Drop | Alter User 2.0
Valentina SQLite Server Add | Drop | Alter User 6.0
Valentina Server State 2.0
Disconnect User 2.0
Edit Server Parameters 2.0
Browse | Remove | Observe (TAIL) Server Log 2.0
View | Register | Unregister Database 2.0
View | Register | Unregister Project 2.0
Notification Channels (Schema Editor) 6.2
Manage Valentina Server License, Status   ✓  9.7
Display list of backups from Valentina Server   ✓  9.8
Drop a backup from Valentina Server   ✓  9.8
Restore a backup to Valentina Server   ✓  9.8
Display, edit properties of the INI-file of Valentina Server   ✓  9.8

EDITORS

SQL Editor

Auto-complete objects and types 2.0
Auto-complete table aliases   7.5
Auto-complete list of fields, list of bindings   9.3
Auto-complete REGEX style 10.5
Default Schema Menu: MySQL   9.0
Default Schema Menu: MS SQL Server   9.0
Expanded Command Keys for Recent | Tabs | Duplicating   9.1.5
Edit RESULT of VIEW for PostgreSQL, MySQL, ValentinaDB & SQLite 9.2
SQL formatting: All | Selected L ✓  1.0
View Query Result 1.0
Edit Query Result, then Update Records   ✓  7.5
Find | Replace in Selection Option   ✓  8.6.1
Drag | Drop Multiple SQL Objects with Selector Panel   ✓  8.7
Enable | Disable Unresolved Line Indents on Import   ✓  8.7
From Code Quotes and Escapes Clean Up   ✓  8.7
Execute (only) Selected SQL Code   ✓  8.7
Copy Snippet Code to Editor and Execute   ✓  10.2
Log | Output | Warnings | Tune Tabs 4.6
Export to Excel XLSX with Images   ✓  7.1
Cancel long query execution 7.1.4
Display Progress | Cancel SQL Export 8.2
Advanced Edit Commands Move Line | Statement | Element   ✓  8.5
Visual SQL Format Bar   ✓  8.5.5
Visual SQL Parameters Panel   ✓  8.6
Errors Console Panel   ✓  9.0
Warning Unsafe Commands   ✓  10.5

Data Editor

View | Create | Modify | Delete | Search | Sort Records 1.0
Related Table Editor Link Kind | Cardinality | Set | Mode 3.5
Text Extended Editor 1.0
Image Extended Editor 1.0
Preview | Drag / Drop Images 2.1
Go to Parent Record 7.0
Data Editor Layouts L L 7.0
Update Multiple Rows L L 6.5
Set for All | Filtered Records   ✓  7.1
Edit Valentina DB KeyValue Data 7.1
Text Editor Search for long texts in a text field   ✓  7.4.3
Array Editor 8.0
Microsoft Excel: Copy From Data Editor in Excell Format   8.5
Microsoft Excel: Paste Table Data into Data Editor 8.5
Export Button: visible set of rows to CSV...   10.4.3
Export Button: visible set of rows to Excel...   10.4.3
Export Button: visible set of rows to HTML...   10.4.3
Export Button: visible set of rows to JSON...   10.4.3
Export Button: visible set of rows to SQL...   10.4.3

Schema Editor & Diagramming

Tree | Column | Diagram View 5.0
Tree View: Open | Close Preview Panel 9.1
Diagram links have tooltips 9.6
Show | Hide Some | All Foreign Key Relations 8.7
Add All Existing Tables to Diagram Option 8.7
Drag | Drop Add Multiple Table and Other Objects 8.7
Diagrams: Reverse Engineering 5.0
Diagrams: Forward Engineering (Generate Scripts)   5.0
Drag-create objects in & between databases L 7.2
Save / Restore Schema Cache   ✓  7.0
Import: Import Diagrams MySQL Workbench 7.3
Create Events for Projects   ✓  9.0
Upload files (license, Valentina DB, SQLite, Project) to Valentina Server   ✓  9.7
Create Tab: Generate Query for Temporary or RAM based Table *   ✓  10.1.0

Query Editor & Visual Query Builder

Drag Create Queries w Visual Builder L 2.4
Save / Copy+Paste Queries   ✓  2.4
Execute SQL / Display Results L 2.4
Open Query in SQL Editor L 2.4
Duplicate Queries L 10.1.1

Script Editor

JavaScript Editor     8.0
Auto-complete for JavaScript classes and objects     8.5
Recursive Imports     10.5
Auto-completion for Imports     10.5
Show Code Templates in Scripts     10.5

PROJECT MANAGEMENT

Project Manager

Project Manager List View 6.3
Project Manager Icon View 9.0
Project Manager Preview Report 10.4
Project Manager Preview Form 10.4.16
Single Click Edit of JavaScript L L 9.7
Create | Edit | Share | Delete Local Project L L 6.3
Create | Edit | Share | Delete Project on Valentina Server L L 6.3
Create | Edit | Delete Datasource L L 6.0
Create | Edit | Delete Report L L 4.0
Preview Report (General) L L 9.0
Create | Edit | Delete Resource L L 6.0
Create | Edit | Delete | Execute | Log Script L L 6.3

REPORTS

Report Viewer

Export Reports to PDF 6.3
Export Reports to HTML 6.3
Print Reports to Local Printer 6.3
Print Reports via Valentina Server attached Printer 6.3

Reports Editor

Report Visual Designer L L 4.0
Visual Drag | Drop Controls & Fields Tabs L L 4.0
Select Alpha | Opacity Text L L 10.4.2
Select Alpha | Opacity Borders L L 10.4.2
All Report Controls Support Rotation     9.6
All Report Objects Support JavaScript     9.6
Copy | Paste | Delete Multiple Report Parameters     9.6.2
Report Parameters L L 7.0
Report Profiling for Region Splitting L L 6.5.3
Save Report to Disk     4.0
Create / Run / Log Script - Javascript L L 7.0
Create / Run / Log Script - SQL L L 7.0
Conditional Formatting 4.2
Log Printer Name and Options     7.3.1
Equal To, Less Than and Greater Than Conditional Styles     8.1
Background & Foreground in Control Instance     8.1
Convert Report Control Type to different Type via Context Menu     8.3.3
Region: Last Page Footer Editor     8.6.2
Multi-Part Reports Editing     9.5
Double-sided Labels Editing     9.5
Horizontal & Vertical Options for Column and Label Editing     9.7

Forms & Layouts

Form Entry

Open | Data Entry Forms in Local Projects 8.0
Open | Data Entry Forms on Valentina Server 8.0
EDIT records of a VIEW for PostgreSQL, MySQL, ValentinaDB & SQLite 9.2

Form Editor

Form Visual Designer L L 8.0
Form Object Dictionary (Enums, Globals, etc) 8.0
Navigate Form Objects in a Form using keyboard     10.4.16
Visual Drag | Drop Controls     8.0
Visual Drag | Drop Layouts     8.0
Save Forms to Local Projects     8.0
Run Forms from a command line     9.3
Aliases can use scripts as source data     9.0.7
Select / Edit / Modify Multiple Controls     8.6
Save Forms to Server Registered Projects     8.0
Create / Attach / Execute JavaScript to Controls     8.0
Create / Attach / Execute JavaScript to Layouts     8.0
Code Templates: Importing Forms     9.1
Code Templates: Importing Scripts     9.1
Code Templates: Sort Records using Javascript     9.1.1
Importing Forms: Code Completion (partial)     9.1
Importing Scripts: Code Completion (partial)     9.1
Start Up Scripts Start on opening Project     10.5
Non-Modal Forms     10.5
Log Unhandled Exceptions     10.4.16
Form / Subform / TableView change records by script     8.3.3
Actions on Add / Remove Filter     8.1
Forms based on SQL Query     8.3
Forms use Query with Parameters     8.3.3
Fill Lists from Queries     9.0.7
Sub Forms based on Table / View / Query     8.3
Display Related Records using Map of Fields     8.3
Display Related Records using Map of Parameters     8.3
"Records" Property for Form / Subform /TableView     8.3.1
TableView 'currentRow' and 'currentColumn' properties     8.3.3
"Reload Records" Action     8.3.1
Controls: Hyperlink Control     8.3.2
Controls: Image Field Control     8.3.2
Controls: Line Edit Control "Mode" Property (specialized inputs)     9.1
Controls: "Need Update" Slot for Dialogs not linked to Datasource     9.1
Controls: "returnedPress" Slot for Line Editors     8.1
Controls: TextEdit widget property 'Accept Rich Text'     10.4.16
Methods: Clear Filters Method for Cursors     8.1
Methods: Form / Subform / TableView queryParameterValue     8.3.3
Methods: Form / Subform / TableView setQueryParameterValue     8.3.3
Objects: 'application.sessionStorage' to store, pass data in single session     9.1
Specify a Field to sort data from a Field     10.4.14
Generate Reports from JavaScript (VProject, VReport)     8.5
QProcess: Execute bash scripts     10.1
QProcess: Execute AppleScript scripts (macOS)     10.1
QProcess: Execute Python scripts     10.1
QProcess: Execute JavaScript     10.1
QProcess: Execute Powershell scripts (Windows)     10.1
QProcess: Execute Command Line Applications     10.1
QSysInfo: Return OS, Version of OS     10.1.1
QProcess Signals: Control asynchronous applications     10.1.1
QCoreAppliction.processEvents() static method for loops (show the progress, process button clicks)     10.1.1