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 Studio FREE | Studio Single | 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 |
|||||
Linux 64 bit version x86 (32 bit dropped with 9.5) | ✓ | ✓ | ✓ | 2.0 | |
Linux 64 bit version ARM64 | ✓ | ✓ | ✓ | 14.5 | |
macOS 64 version x86 (32 bit dropped with 9.5) | ✓ | ✓ | ✓ | 1.0 | |
macOS 64 version ARM | ✓ | ✓ | ✓ | 12.5 | |
Windows 32 & 64 bit versions | ✓ | ✓ | ✓ | 1.0 | |
Datasources |
|||||
DuckDB | ✓ | ✓ | ✓ | 14.5 | |
MariaDB | ✓ | ✓ | ✓ | 7.4.1 | |
MongoDB | ✓ | ✓ | ✓ | 12.0 | |
MS SQL Server 2000+ | ✓ | ✓ | ✓ | 6.5 | |
MS Azure | ✓ | ✓ | ✓ | 6.5.10 | |
MySQL 5.0.6+ | ✓ | ✓ | ✓ | 5.0 | |
PostgreSQL 8.4+ | ✓ | ✓ | ✓ | 5.0 | |
SQLite File 3.0.7+ | ✓ | ✓ | ✓ | 5.0 | |
Valentina SQLite Server 3.0.7+ | ✓ | ✓ | ✓ | 5.0 | |
ValentinaDB File 2.X-5.X with Conversion | ✓ | ✓ | ✓ | 2.0 | |
ValentinaDB File 6.X + no conversion | ✓ | ✓ | ✓ | 6.0 | |
ValentinaDB Server | ✓ | ✓ | ✓ | 4.8 | |
ODBC (Excel, Access, etc) | ✓ | ✓ | ✓ | 1.0 | |
Database Continuous Integration |
|||||
Schema Snapshot | ✓ | ✓ | 7.0 | ||
SQLDIFF | L | ✓ | ✓ | 5.0 | |
Source Control | ✓ | ✓ | 7.0 | ||
Database Dump / Load |
|||||
Create / Load Dump (DuckDB) | L | L | ✓ | 14.5 | |
Create / Load Dump (MS SQL Server) | L | L | ✓ | 5.0 | |
Create / Load Dump (MySQL) | L | L | ✓ | 5.0 | |
Create / Load Dump (PostgreSQL) | L | L | ✓ | 5.0 | |
Create / Load Dump (SQLite) | L | L | ✓ | 5.0 | |
Create / Load Dump (ValentinaDB) | L | L | ✓ | 2.5.4 | |
Dump List Filter | ✓ | 6.0 | |||
Error Look Up |
|||||
MS SQL Server | ✓ | ✓ | 6.2 | ||
ValentinaDB | ✓ | ✓ | 6.2 | ||
SQL Search |
|||||
Advanced Pattern Matching | ✓ | ✓ | 5.2.4 | ||
Open Found in Schema Editor | ✓ | ✓ | 5.2.4 | ||
Result Object Browser | ✓ | ✓ | 5.2.4 | ||
Result Path Browser | ✓ | ✓ | 5.2.4 | ||
Search via Open Connection | Bonjour | Bookmark | ✓ | ✓ | 5.2.4 | ||
Search Filter Constructor | ✓ | ✓ | 5.2.4 | ||
Utility |
|||||
CLI Print Reports via Terminal or Script | ✓ | ✓ | ✓ | 6.4 | |
Data Transfer | ODBC Import | ✓ | ✓ | 5.1 | ||
Save | Load Mapping of Import Wizard | ✓ | ✓ | 10.4.12 | ||
SQLite DB Diagnose | Compact | ✓ | ✓ | ✓ | 6.0 | |
SQLite DB to Valentina DB Converter | ✓ | ✓ | ✓ | 7.0 | |
SSH / SSL Secure Connection | ✓ | ✓ | ✓ | 5.1 | |
ValentinaDB Diagnose | Clone | Compact | Defragment | ✓ | ✓ | ✓ | 6.0 | |
Virtual Links | ✓ | 13.9 | |||
Generate Database Documentation (MSSQL, MYSQL, PostgreSQL, SQLite, ValentinaDB) | ✓ | ✓ | ✓ | 13.6 | |
Productivity |
|||||
Bookmarks |
|||||
Auto-sort by Name on Start Page | ✓ | ✓ | ✓ | 13.0 | |
Add To Bookmarks… sub-menu on Bonjour Discovered Items | ✓ | ✓ | ✓ | 10.5.1 | |
Add To Bookmarks… sub-menu on Live Connection in Schema Editor | ✓ | ✓ | ✓ | 10.5.1 | |
“Discover Localhost Servers” Option on Start Page Column | ✓ | ✓ | ✓ | 10.5.1 | |
Import / Export (Connections) | ✓ | ✓ | ✓ | 2.0 | |
Synchronize via Cloud (Google Drive, Dropbox) | ✓ | ✓ | 10.0 | ||
Tips | Tooltips |
|||||
Tips on Start Up | ✓ | ✓ | ✓ | 13.3 | |
Tooltips | ✓ | ✓ | ✓ | 2.0 | |
Tooltips: Styled for Links | ✓ | ✓ | ✓ | 11.2.3 | |
Tooltips: Warn about broken ObjectPtr-links (ValentinaDB) | ✓ | ✓ | ✓ | 11.2.3 | |
Keyboard |
|||||
Keyboard Shortcuts | ✓ | ✓ | ✓ | 2.0 | |
Keyboard Shortcuts Sets / Warnings | ✓ | ✓ | 7.0 | ||
Prefs: Enable | Disable Examples | ✓ | ✓ | 10.0.1 | ||
Snippets |
|||||
Snippets: Associate with Specific Databases | ✓ | ✓ | 10.0 | ||
Snippets: Display Number of Hidden Snippets | ✓ | ✓ | 11.2.3 | ||
Snippets: Synchronize via Cloud (Google Drive, Dropbox) | ✓ | ✓ | 10.0 | ||
Workspaces |
|||||
Save Bookmarks to Workspace | ✓ | 12.0 | |||
Save Open Tabs to Workspace | ✓ | 13.0 | |||
Save Open Windows to Workspace | ✓ | 13.0 | |||
Save Recent Databases to Workspace | ✓ | 12.0 | |||
Save Recent SQL Queries to Workspace | ✓ | 12.0 | |||
Save SQL Snippets to Workspace | ✓ | 12.0 | |||
Other |
|||||
UI Toolbar | Tabs | Property Inspectors | ✓ | ✓ | ✓ | 2.0 | |
Contextual Menus | ✓ | ✓ | ✓ | 2.0 | |
macOS Dark Theme | ✓ | ✓ | ✓ | 10.4 | |
SERVER MANAGEMENT |
|||||
Microsoft SQL Server Administration |
|||||
SQL Server Add | Drop | Alter User | ✓ | ✓ | ✓ | 6.0 | |
SQL Server State | ✓ | ✓ | ✓ | 6.0 | |
Disconnect User | ✓ | ✓ | ✓ | 6.0 | |
Edit Server Parameters | ✓ | ✓ | ✓ | 6.0 | |
Field Type: RowVersion | ✓ | ✓ | ✓ | 11.2.5 | |
Preferences: NO_BROWSETABLE option | ✓ | ✓ | ✓ | 12.7 | |
SQL Editor: Edit the result records | ✓ | ✓ | ✓ | 12.7 | |
View Logs | ✓ | ✓ | ✓ | 6.0 | |
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 | |
MariaDB Server Administration |
|||||
MariaDB Server (Connect via MySQL) | ✓ | ✓ | ✓ | 7.4.1 | |
MariaDB Keywords (52) | ✓ | ✓ | ✓ | 12.5.5 | |
MongoDB Administration |
|||||
MongoDB Schema Editor | ✓ | ✓ | ✓ | 12.0 | |
Command Editor (similar to SQL Editor) | ✓ | ✓ | ✓ | 12.0 | |
Command Editor Templates (Basic) | ✓ | ✓ | ✓ | 12.0.2 | |
Command Editor Templates (Aggregation, Query and Write Operation) | ✓ | ✓ | ✓ | 12.0.4 | |
Collection Editor (Data Editor) | ✓ | ✓ | ✓ | 12.0 | |
Collection Editor (Data Editor) - Restore Last Selected View Mode (List or Columns) | ✓ | ✓ | ✓ | 12.2 | |
MongoDB Diagramming | L | ✓ | ✓ | 13.0 | |
Server Admin (manage users, databases, etc) | ✓ | ✓ | ✓ | 12.0 | |
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 | |
Extended SSL Parameters in Connect Dialog | ✓ | ✓ | ✓ | 10.5.3 | |
Display Default paths to SSL keys | ✓ | ✓ | ✓ | 10.5.3 | |
Method Fields (generated columns) Support (added in PostgreSQL 12) | ✓ | ✓ | ✓ | 11.4.5 | |
Identity Fields Support | ✓ | ✓ | ✓ | 11.4.5 | |
SQL Editor: Typing $$ adds another pair $$, to support dollar-quoted-literals of PostgreSQL | ✓ | ✓ | ✓ | 12.4.4 | |
ValentinaDB Server Administration |
|||||
ValentinaDB Server Add | Drop | Alter User | ✓ | ✓ | ✓ | 2.0 | |
Valentina SQLite Server Add | Drop | Alter User | ✓ | ✓ | ✓ | 6.0 | |
Valentina Server State | ✓ | ✓ | ✓ | 2.0 | |
Valentina Server State Live Mode Tab | ✓ | ✓ | ✓ | 12.1 | |
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 | ||
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 | |
Auto-complete Smart Suggestions include keywords of lower priority, ie symbols within a keyword | L | ✓ | ✓ | 12.3.1 | |
Auto-complete Smart Suggestions suggests afields for “SELECT tblAlias.| FROM TBL tblAlis | L | ✓ | 11.4 | ||
Auto-complete Smart Suggestions with Lamp icon | L | ✓ | ✓ | 12.3.1 | |
Auto-complete Smart Suggestions for SET within an INSERT | L | ✓ | 12.4 | ||
Auto-refresh schema if SQL Editor executes some DDL command (CREATE/DROP/ALTER) | L | ✓ | ✓ | 12.3.6 | |
Cancel long query execution | ✓ | ✓ | ✓ | 7.1.4 | |
Copy Snippet Code to Editor and Execute | ✓ | ✓ | 10.2 | ||
Default Schema Menu: MySQL | ✓ | ✓ | 9.0 | ||
Default Schema Menu: MS SQL Server | ✓ | ✓ | 9.0 | ||
Drag | Drop Multiple SQL Objects with Selector Panel | ✓ | ✓ | 8.7 | ||
Edit RESULT of VIEW for PostgreSQL, MySQL, ValentinaDB & SQLite | ✓ | ✓ | ✓ | 9.2 | |
Edit Query Result, then Update Records | L | ✓ | ✓ | 7.5 | |
Enable | Disable Unresolved Line Indents on Import | ✓ | ✓ | 8.7 | ||
Execute (only) Selected SQL Code | ✓ | ✓ | 8.7 | ||
Expanded Command Keys for Recent | Tabs | Duplicating | ✓ | ✓ | ✓ | 9.2 | |
Export to Excel XLSX with Images | ✓ | ✓ | 7.1 | ||
Find | Replace in Selection Option | ✓ | ✓ | 8.6.1 | ||
Formatting: SQL All | Selected | L | ✓ | ✓ | 1.0 | |
From Code Quotes and Escapes Clean Up | L | ✓ | ✓ | 8.7 | |
Highlight | Tooltip Value-List corresponded field in FIELD-list, while type or choose a value in VALUE-list | ✓ | 12.3.3 | |||
Highlight syntax in multiline dollar-string literals | ✓ | ✓ | ✓ | 12.6.1 | |
SQL Function Browser | ✓ | ✓ | 5.0 | ||
Placeholders in SQL Text | L | ✓ | ✓ | 12.5 | |
Theme Support | ✓ | ✓ | ✓ | 11.2.3 | |
View Query Result | ✓ | ✓ | ✓ | 1.0 | |
Log | Output | Warnings | Tune Tabs | ✓ | ✓ | ✓ | 4.6 | |
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 | ||
Display INSERT error if the # of items in FIELD-list and VALUE-list not the same | ✓ | ✓ | ✓ | 12.3.4 | |
Virtual Links Supported in Auto-Completion | ✓ | 13.9 | |||
DATA EDITOR |
|||||
Data Editor | ✓ | ✓ | ✓ | 1.0 | |
Data Editor Layouts | L | L | ✓ | 7.0 | |
Data Formatting Options | ✓ | 11.4.3 | |||
Data Formatting Options: Currency Formatting for float, double, decimal, money | ✓ | 11.4.5 | |||
Display current range with pop-up menu to navigate between data pages | ✓ | ✓ | ✓ | 13.0.2 | |
Filter / Search for multiple values in a column | ✓ | ✓ | ✓ | 12.5 | |
View | Create | Modify | Delete | Search | Sort Records | ✓ | ✓ | ✓ | 1.0 | |
Related Table Editor Link Kind | Cardinality | Set | Mode | ✓ | ✓ | ✓ | 3.5 | |
Text Extended Editor | ✓ | ✓ | ✓ | 1.0 | |
Text Alignment in Grid | ✓ | ✓ | ✓ | 11.2.1 | |
Value Editor Pop Up Option in Cell | ✓ | ✓ | ✓ | 11.2 | |
JSON Editor (via Metadata Editor) with cell detection highlighting | ✓ | ✓ | ✓ | 11.2 | |
HTML Editor (via Metadata Editor) with cell detection highlighting | ✓ | ✓ | ✓ | 11.2 | |
Image Extended Editor | ✓ | ✓ | ✓ | 1.0 | |
Preview | Drag / Drop Images | ✓ | ✓ | ✓ | 2.1 | |
Go to Parent Record | ✓ | ✓ | ✓ | 7.0 | |
Update Multiple Rows | L | L | ✓ | 6.5 | |
Set for All | Filtered Records | ✓ | ✓ | 7.1 | ||
Text Editor Search for long texts in a text field | ✓ | ✓ | 7.4.3 | ||
Microsoft Excel: Copy From Data Editor in Excel 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 | ||
Virtual Links in Data Editor | ✓ | 13.9 | |||
Database Specific Data Editors |
|||||
Array (PostgreSQL) | ✓ | ✓ | ✓ | 11.3 | |
Array (ValentinaDB) | ✓ | ✓ | ✓ | 8.0 | |
Binary (MS SQL Server) | ✓ | ✓ | ✓ | 11.2.5 | |
Date (ValentinaDB, MySQL) | ✓ | ✓ | ✓ | 11.2 | |
Date (MS SQL Server) | ✓ | ✓ | ✓ | 11.2.5 | |
Date (PostgreSQL) | ✓ | ✓ | ✓ | 11.3 | |
DateTime (MS SQL Server) | ✓ | ✓ | ✓ | 11.2.5 | |
DateTime2 (MS SQL Server) | ✓ | ✓ | ✓ | 11.2.5 | |
DateTimeOffset (MS SQL Server) | ✓ | ✓ | ✓ | 11.2.5 | |
Enum (PostgreSQL) | ✓ | ✓ | ✓ | 11.3 | |
Geometry (PostgreSQL) | ✓ | ✓ | ✓ | 11.3 | |
Image (MS SQL Server) | ✓ | ✓ | ✓ | 11.2.5 | |
KeyValue (ValentinaDB) | ✓ | ✓ | ✓ | 7.1 | |
SmallDateTime (MS SQL Server) | ✓ | ✓ | ✓ | 11.2.5 | |
SmallDateTime (MS SQL Server) | ✓ | ✓ | ✓ | 11.2.5 | |
SQL_Variant (ValentinaDB, MySQL) | ✓ | ✓ | ✓ | 11.2.5 | |
Time (ValentinaDB, MySQL) | ✓ | ✓ | ✓ | 11.2 | |
Time (MS SQL Server) | ✓ | ✓ | ✓ | 11.2.5 | |
Time Stamp (PostgreSQL) | ✓ | ✓ | ✓ | 11.3 | |
UniqueIdentifier (MS SQL Server) | ✓ | ✓ | ✓ | 11.2.5 | |
VarBinary (MS SQL Server) | ✓ | ✓ | ✓ | 11.2.5 | |
SCHEMA EDITOR & DIAGRAMMING |
|||||
Column View: Number of Databases | Create, Search, Options Gizmos | ✓ | ✓ | ✓ | 13.3 | |
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 | ||
Property Inspector: Set color and font for each sub item | ✓ | ✓ | 10.5.6 | ||
Property Inspector: Set default font for diagram | ✓ | ✓ | 10.5.6 | ||
Property Inspector: Paper format and orientation for PDF export | ✓ | ✓ | 10.5.6 | ||
Property Inspector: Link Count property for links w number of relations between rows of linked tables | ✓ | ✓ | 11.2.4 | ||
Virtual Links in Schema Editor | ✓ | 13.9 | |||
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 | |
Composite foreign keys in the Query Editor | ✓ | ✓ | ✓ | 10.5.6 | |
Virtual Links in Query Editor | ✓ | 13.9 | |||
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 | |
Prefs: Options to manage click behavior for Reports and Forms | ✓ | ✓ | ✓ | 10.5.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 | |
Display Report Preview with Datasources connected via SSH with Key Authentication | ✓ | ✓ | ✓ | 12.1.1 | |
Reports Editor |
|||||
Report Visual Designer | L | L | ✓ | 4.0 | |
Query Editor for Reports (MongoDB): JSON & JavaScript | ✓ | 13.5 | |||
Watermarks for Reports | L | L | ✓ | 13.1 | |
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 | |
Controls: Convert Report Control Type to different Type via Context Menu | ✓ | 8.3.3 | |||
Controls: Background & Foreground in Control Instance | ✓ | 8.1 | |||
Controls: Rotation | ✓ | 9.6 | |||
Controls: Text Controls Support Justified Alignment | ✓ | 13.10 | |||
Controls: Text Controls "fill_in" Property | ✓ | 13.10 | |||
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 | |||
Script: Create / Run / Log Script - Javascript | L | L | ✓ | 7.0 | |
Script: Create / Run / Log Script - SQL | L | L | ✓ | 7.0 | |
Script: Create / Run / Log Script - Python | L | L | ✓ | 13.6 | |
Script: Create / Run / Log Script - Python - Built in Modules | L | L | ✓ | 14 | |
Script: Create / Run / Log Script - Python - Custom and Third Party Modules | L | L | ✓ | 14 | |
Conditional Formatting | ✓ | ✓ | ✓ | 4.2 | |
Log Printer Name and Options | ✓ | 7.3.1 | |||
Styles: Conditional Equal To, Less Than and Greater Than | ✓ | 8.1 | |||
Parts: Last Page Footer Editor | ✓ | 8.6.2 | |||
Parts: Multi-Part Reports Editing | ✓ | 9.5 | |||
Parts: Reorder by Dragging Tabs | ✓ | 13.10 | |||
Labels: 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 | |||
Script: Create / Run / Log Script - Python | ✓ | 14 | |||
Script: Create / Run / Log Script - Python - Built in Modules | ✓ | 14 | |||
Script: Create / Run / Log Script - Python - Custom and Third Party Modules | ✓ | 14 | |||
Code Templates: Importing Forms | ✓ | 9.1 | |||
Code Templates: Importing Scripts | ✓ | 9.1 | |||
Code Templates: Sort Records using Javascript | ✓ | 9.1.1 | |||
Custom Titles for the table view | ✓ | 13.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 | |||
Printing: Get | Set Parameters programmatically for printing using Windows default print dialog | ✓ | 11.2.7 | |||
Specify a Field to sort data from a Field | ✓ | 10.4.14 | |||
Generate Reports from JavaScript (VProject, VReport) | ✓ | 8.5 | |||
Generate Reports from Python (VProject, VReport) | ✓ | 14 | |||
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 | |||
Methods: project.getItemByName() to change the datasource definition in code | ✓ | 10.5.6 | |||
Property: report.showPrintDialog add ability to pass default options | ✓ | 10.5.6 |