Valentina Studio

macOS / developpeurs

=== 100% Free - The Best Database Management GUI for ===
=== DuckDB, SQLite, MS SQL Server, MariaDB, MongoDB, MySQL, PostgreSQL and Valentina databases ===

Valentina Studio brings you powerful, visual editors for your data including:
* 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, ...
* Diagram Editor - design new diagrams or do reverse engineering, e.i explore existing databases visually.
* Data Editor - easily browse table records in the grid, modify records, an 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 and saved favorite queries, templates, console with error/warning reporting, ...
* Query Editor - build SQL queries visually using just a few mouse clicks
* Server Admin - where you can manage users, learn logs and other parameters of servers.

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

Valentina Studio uses iCloud to share bookmarks between your devices!


*** See also: Valentina Studio Pro ($199 only) ***

Get Valentina Studio Pro as an in-app purchase (pay only once) to get additional advanced pro-features such as:

* Report Editor - visual editor of Valentina Reports that can be saved into Valentina Project file (.vsp). Reports can use as datasource MS SQL, MySQL, PostgreSQL, SQLite, Valentina DB, ODBC.
* Form Editor - visual editor of Valentina Forms that can be saved into Valentina Project file (.vsp). Forms can use all supported databases as the datasource.
* Data Editor - enables go to parent record function.
* Data Editor Layouts - save columns and their order as a named layout
* Data Editor Multiple Update - update few records at once.
* Data Transfer - copy data between different databases
* Diagram Editor - enables forward engineering - i.e. generation of SQL scripts for new/changed database objects.
* Dump Wizard - enables filter for tables to select them for a dump.
* Error Lookup - search for error description by its code.
* Keyboard Shortcuts - enables the ability to redefine the shortcuts and create own shortcut sets.
* Object Colors - enables marking objects with specific colors.
* Query Editor - enables the ability to copy the generated query.
* Schema Cache - save and reuse the schema cache.
* Schema Editor - copy one or few schema objects using drag&drop mechanism.
* Schema Editor - expanding and collapsing the tree items with subitems using OPTION + click
* Schema Snapshot - save and load schema in structured format.
* Source Control - develop database using any VCS.
* SQLDiff - find differences between two states of a databases and generate SQL script to move between these states.
* SQL Search - search of schema objects.
* SQL Editor - format SQL queries.
* SQL Editor - edit the result of SQL queries.
* SQL Editor - use bind parameters in SQL queries.

*** See also: Valentina Studio Single ($79.99 only) ***

Get Valentina Studio Single as an in-app purchase (pay only once) to get additional advanced pro-features for a single database engine, except for Valentina Project development functionality (reports, forms, JavaScript).

Quoi de neuf dans la dernière version ?

Unified JavaScript and Python engines are now used for Forms, Reports, and Valentina Database Stored Procedures. Previously, different JavaScript engines were used for Forms and Reports, which could lead to inconsistencies in how scripts were executed. With a unified engine, behavior is now consistent and reliable across all components.

A new plugin has been added to work with DuckDB databases. This is a file-based database, similar to Valentina DB and SQLite in this aspect.

=== New Features ===

[DuckDB]
* DuckDB support has been implemented in the following tools:
* Schema Editor
* Virtual Links
* SQL Editor
* Data Editor
* Diagram Editor
* Query Editor
* Dump creation and loading
* SQL file creation and loading
* XML/JSON creation
* CSV Export and Import
* Preferences panel
* Pre-connect and post-connect scripts for Bookmarks
* Project Editor
* Form Editor
* Report Editor

[Report Editor]
New features of the reporting engine:
* Table of contents generation
* Justified text alignment added for text controls
* Reorder report parts by dragging their tabs
* Rename parts by double-clicking on their names at the bottom
* Reports can be scripted with Python, in addition to JavaScript
* Standalone scripts stored in the project can be loaded using the project.loadModule method in expressions and scripts executed during report generation (previously, this was only possible for forms)

[Form Editor] Forms can now be scripted with Python, in addition to JavaScript.
[Valentina DB] Stored procedures can now use JavaScript or Python.

[Bookmarks] Pre-connect and post-connect scripts can now be implemented using Python or JavaScript. For example, a pre-connect script can retrieve a connection token, while a post-connect script can define parameters for an established connection

=== Improvements ===

[Report Editor]
* Ability to delete the first part of the report
* Clearer messages when a query fails during report generation from an SQL Server data source, helping users identify and resolve issues more effectively

[Query Log] Ability to export only queries from the Query Log tab
[SQL Editor][Data Editor] Use of schema-qualified table names when generating the INSERT command via context menu actions

=== Fixes ===

[Report Editor] Fixed issue with drawing EAN barcodes with an additional section
[MySQL] Faster export of large MySQL cursors to CSV