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, and more.
* Diagram Editor - design new diagrams or do reverse engineering, i.e., explore existing databases visually.
* Data Editor - easily browse table records in the grid, modify records, inline editing of values, sort, filter records and save favorite filters, preview images, hex editors for binary values, and more.
* Related Data Editor - easily learn and manage linked records of two tables, link/unlink records by a mouse click, perform set operations over linked records, and more.
* SQL Editor - with color syntax, auto-completion, recent and saved favorite queries, templates, console with error/warning reporting, and more.
* 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, and more.

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 multiple 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 schema cache.
* Schema Editor - copy one or multiple 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 databases and generate SQL script to move between these states.
* SQL Search - search of schema objects.
* SQL Editor - integrated AI Chat with ASK and AGENT modes.
* 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 (reports, forms, JavaScript) and AI functionality.

Quoi de neuf dans la dernière version ?

=== New ===

* [Query Editor] Added the Nulls column to control the ORDER BY fld [NULLS FIRST | LAST] clause.
* [Data Editor] Added Sort Ascending, Sort Descending, and Clear Sorting actions to the column context menu. The active sorting direction is indicated in the menu.
* [Report Editor] Added the evaluation_time property to Bar Code, Chart, Ellipse, HTML, Label, Line, Picture, Rectangle, and Shape controls. It can delay evaluation until the Region, Page, Report, or Group is complete; for example, a group header can display the final number of items in its group.
* [Report Editor][MongoDB] Added support for complex MongoDB reports with grouping, sorting, and SQL expressions.

=== Improvements ===

* [Query Editor] Added an empty-scene placeholder that guides users to add tables, views, or links, and adjusted the grid-line color for better visual clarity.
* [Data Editor] Renamed Find Column to Go to Column in menus, tooltips, and the shortcut reference.
* [SQL Editor] Improved static analysis and identifier resolution for UNION, UNION DISTINCT, and EXCEPT queries.
* [Report Editor] Count summaries now use the configured value formatting.
* [MongoDB] Added support for fetching additional batches from aggregate cursors in the Report Editor and MongoDB Command Editor.
* [Report Editor][ODBC] Added support for reading BLOB fields.
* [Scripts][JavaScript] Enabled the fetch function in the JavaScript extension, allowing Forms, Reports, and scripts to retrieve data from HTTP/REST services.

=== Fixes ===

* [Allowed Locations] Fixed a loop in the Preferences workflow when opening or creating a file outside the permitted directories.
* [Report Editor] Hid the expression editor button for Equal To, Less Than, and Greater Than conditional expressions. Added input validation, a placeholder, and tooltips for these conditions.
* [Query Editor] Fixed cleanup for empty SQL.
* [Query Editor] Fixed query cleanup when removing tables from the diagram.
* [Query Editor] Fixed an issue that prevented adding more than five fields to the grid.
* [Query Editor] Fixed scene refresh when the diagram becomes empty or non-empty, so the placement hint is shown correctly.
* [Report Editor][MongoDB] New MongoDB report queries now show MongoDB Command instead of SQL as the query type.
* [Data Editor][Parquet] Fixed viewing BLOB field data.
* [Report Editor][MongoDB] Fixed preservation of binary values during report processing and sorting.
* [Report Editor][MongoDB] Fixed integer query parameter substitution in JSON queries.
* [Report Editor][ODBC] Fixed identifier quoting.
* [Report Editor][DuckDB] Fixed displaying pictures stored in BLOB fields.
* [Scripts][JavaScript] Fixed fetch HTTP response handling. Response.status, Response.statusText, and Response.ok now reflect the HTTP response correctly, while transport failures are reported as errors.