Featured Products
Omegabundle for Xojo 2025 Products

Valentina Studio Pro

The professional SQL database administration, reporting and forms platform

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.

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

Highlights of Valentina Studio PRO

Database Management Universal database management tool for all major databases.
SQL Editor Full featured SQL Editor for writing, testing and executing queries with all supported databases.
Visual Query Builder Build, test and execute SQL queries visually, drag-drop with Query Builder.
Data Editor Clean data editor with high productivity tools for working with tables, records and fields.
Schema Editor Work with databases using diagrams, tree or column view.
Data Transfer Specify mapping of source/target tables and fields and load records from db1 to db2.
SQL DIFF Compare schemas of two databases and  transform the first schema into the second.
Continuous Integration Continuous Integration (CI) tools for better software practices for databases.
Report Designer

Transforms queries into visually stunning enterprise reports with full suite of design elements.

 
Valentina Forms Designer Create and add forms visually, and then your users can work with them in free Valentina Studio.
Workspaces Organize your tools, preferences, lists of recent datasources and more for individual projects.
Virtual Links Create virtual links where you need the functionality of foreign keys without creating foreign keys.

Databases Supported by Valentina Studio

Valentina Studio Pro supports most popular databases in use.

  • NEW: DuckDB
  • MS SQL Server & Microsoft Azure SQL DB
  • MySQL
  • PostgreSQL
  • SQLite (Local)  / Valentina SQLite Server
  • MariaDB
  • ValentinaDB Local / ValentinaDB Server
  • MongoDB*

* Currently, MongoDB is not supported in Valentina Forms.

 

Improvements Since Omegabundle 2024

  • 14.1.3 [Imp][Diagrams] - Controls without model are now deleted, instead showing as an empty space.
  • 14.1.3 [Imp][SQLite][Win] Single plugin file for LOCAL and CLIENT to VSERVER
  • 14.1.3 [Imp][ValentinaDB][Win] Single plugin file for LOCAL and CLIENT to VSERVER
  • 14.1.3 [Imp]Use the schema-qualified table name, if possible, when generating the INSERT command for the “Copy Record As SQL” actions in the SQL Editor and Data Editor.
  • 14.5 [New][DuckDB] Now supports DuckDB
  • 14.5 [New] [DuckDB]DuckDB project example projects
  • 14.5 [New] [Linux]Now Available on Linux ARM64
  • 14.5 [Imp][SQL Editor]Auto-scroll SQL Text to a placeholder and highlight it, when you choose it in the panel 'Parameters'.
  • 14.5 [Imp] Improvements for execution of pre-connect scripts
  • 14.5 [Imp] In the post-connect script of the bookmark, the connection and database objects are added to the result, allowing for initialization, such as changing DuckDB database connection setting
  • 14.5.2 [Imp][Diagram Editor] - Ctrl-W now closes a current diagram, not a whole Tab.
  • 14.5.2 [Imp][Data Editor] - Don't use double click to open an advanced editor of a cell.
  • 14.6 [New][SQL Editor] - User selectable either  SQL GLOT  or  SQL Parse tools to format SQL queries
  • 14.6 [Imp]DuckDB] - Updated the DuckDB library to version 1.1.2
  • 14.6 [Imp][Report Editor] - The Chart Control now features an updated design
  • 14.6 [Imp][SQL Editor] When you drag from the left panel a Db Object (Table, Field, etc) and drop it into the Text Area of SQL Editor, the dialog is opened. Now this dialog has the checkbox “Quote Identifiers”.
  • 14.6 [Imp][Data Editor] Added a confirmation prompt for unlink actions.
  • 14.6 [Imp][Data Editor] Reduced a page size to 100 000
  • 14.6.1 [Imp][Query Editor] Ensures unique tab names are generated for each new query
  • 14.6.1 [Imp][Query Editor] Display RowID in the list of fields for SQLite tables
  • 14.6.1 [Imp] [Linux] Optional menu button to the toolbar, which is displayed by default in the GNOME desktop environment on Linux
  • 14.6.1 [Imp][SQL Editor] Added a separate option to insert a space after functions during auto-completion
  • 14.6.1 [Imp][Data Editor] Added a filter to Choose Shown Columns dialog
  • 14.6.1 [Imp][Form Editor] Remember the last selected language and apply it to new scripts and slots.
  • 14.6.1 [Imp][SQLite] Updated SQLite engine to version 3.47.0
  • 14.6.1 [Imp][Scripting Documentation] The Help→Scripting Environment dialog now operates in non-modal mode, allowing for easier switching between documentation and code
  • 14.6.2 [New][Forms]  Enabled programmatic management of ListView items.
  • 14.6.2 [New][Forms] Added the ability to get scripts of a Form
  • 14.6.2 [New] [Reports]Export reports to OpenDocument Text (.odt) format
  • 14.6.3 [New][Forms] New preCreate property to the Form object, enabling flexible setup of a data source for a Form (e.g., creating a temporary table)
  • 14.6.3 [Imp][Schema Editor] Implemented natural case-insensitive sorting in the Schema Editor's tree mode
  • 14.6.3 [Imp][Form Editor] Save and restore the current tab of the Property Inspector (Properties or Slots)
  • 14.6.3 [Imp][macOS] The local and client parts of SQLite and Valentina database plugins have been unified to avoid duplication and reduce the application size
  • 14.7 [New][Form Editor] Added the ability to establish signal connections within Scripts and Forms programmatically
  • 14.7 [Imp][Form Editor] The Property Inspector in the Form Editor now has collapsible sections
  • 14.7 [Imp][Scripting Environment] Added documentation for all properties and methods of the Form Item class
  • 14.7 [Imp][MySQL] Added a confirmation for changing the Engine property of the table (it may lead to data loss)
  • 14.7 [Imp][PostgreSQL] Dump utilities and connection client are updated to version 17.2
  • 14.7 [Imp][Load Dump] Execute multiple queries in a single batch only for data insertion, simplifying error tracking during schema dump loading
  • 14.7 [Imp][SQL Editor] Use plain thick lines to highlight wrong identifiers
  • 14.7.1 [Imp][Diagram Editor] Now works zoom with the wheel in diagrams
  • 14.7.1 [Imp][Diagram Editor] Move the current position in diagrams by the middle button of the mouse
  • 14.7.1 [Imp][Data Editor] Change the tooltip on hover to remove column name (redundant) and include field comment
  • 15 [New] [DuckDB]DuckDB Plugin now supports connections to Valentina DuckDB Server
  • 15 [New][Report Editor] Added the ability to create reports based on JSON data without requiring a predefined datasource
  • 15 [New][Report Editor] Added the ability to specify a query inside a report (Built-in query), so there is no need to create a separate object
  • 15 [New][Data Editor] Adds Transactions Manager for the following databases: DuckDB (local or via Valentina Server), MySQL, MS SQL, PostgreSQL and SQLite (local or via Valentina Server)
  • 15 [Imp][Form Editor] Forms Object Palette reorganized and improved for greater productivity
  • 15 [Imp][Form Editor] Display more detailed information about controls in tooltips
  • 15 [Imp][Form Editor] Show custom Valentina Studio signals ('created', 'needUpdate', 'preCreate') in a separate group 'FormItem' in the Property Inspector
  • 15 [Imp][Project Tab] Renamed the menu button 'Produce' to 'Export As'
  • 15 [Imp][Data Editor] Paste Records improvements
  • 15.0.1 [Imp][SQL/Data Editor] - Renamed columns auto-sizing options “Check All Rows” → “Using All Rows”, etc
  • 15.1 [Imp][DuckDB] Added Storage Version and Block Size parameters to the database creation dialog
  • 15.1.1 [Imp][DuckDB] DuckDB library updated to 1.2.1
  • 15.1.4 [Imp][MariaDB] Enabled JSON editor for MariaDB
  • 15.1.4 [Imp][MariaDB] Show a special connection icon when a connection is established to a MariaDB server
  • 15.2 [Imp][Report Editor] Use the current unit to show values in the line width menu
  • 15.2 [Imp][SQL Editor] Improved the algorithm of the “Execute Current” action: if the cursor is on the same line right after a semicolon before the next statement, the previous statement is executed
  • 15.2 [Imp][Start Page] Added Tooltip for Bonjour Pane on the Start Page
  • 15.2 [Imp][MySQL] Use the 'INFORMATION_SCHEMA.KEYWORDS' system table for auto-completion, if available
  • 15.2 [Imp][PostgreSQL] Added the 'Refresh Materialized View' action for materialized views
  • 15.2 [Imp][PostgreSQL] Supported showing and creation of indexes for materialized views
  • 15.3.1 [Imp][Data Editor] Improved tooltips and UI for transaction mode to make it clearer. Added a separate button with transaction settings
  • 15.3.2 [Imp][Data Editor] Even more improved tooltips and UI for transaction mode to make it clearer.
  • 15.3.2 [Imp][ValentinaDB] In the 'Create Database Dialog' removed out of date option to choose BigEndian
  • 15.3.5 [New][Data Editor] The Related Data Editor menu of available links now includes the “Create Virtual Link” option
  • 15.3.5 [New][SQL Editor] Auto-completion now retrieves information about VIEW fields, enabling suggestions for them as well
  • 15.3.5 [New][SQL Editor] Three modes are now available for collecting auto-completion items: { StartWith, Contains, Wide }
  • 15.3.5 [Imp][SQL Editor] Auto-completion menu performance significantly improved — up to 100x faster for large schemas
  • 15.4 [New][Start Page] Progress bar is now displayed during the first Bonjour connection scan (in the Bonjour column)
  • 15.4 [New][Start Page] Added buttons to toggle filters in the Start Page columns
  • 15.4 [New][Data Editor] Added connection icon to the toolbar
  • 15.4 [New][Data Editor] A yellow warning icon is now shown at the bottom of the editor, with a tooltip if the table has no primary key or unique field
  • 15.4 [Imp][DuckDB]DuckDB updated to 1.3.1
  • 15.4 [Imp][SQLite]SQLite updated to 3.50.1