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 ===

* [SQL Editor][AI] Query results can be attached to the AI chat context using the Attachment button. Results are sent as CSV text; avoid sending very large result sets to conserve tokens.

[Query Editor]
* New expressions in SELECT automatically receive an alias in the form ExprN.
* Added the ability to edit query text directly and apply changes to the diagram. You can paste a full SELECT query into the right panel or edit the query generated by Query Editor, then click Apply Changes.

* [Form Editor] Added DuckDB client and local factories, accessible from scripts.
* [Valentina DB] Added the GROUPING aggregative function.
* [Report Editor] Added support for inheritable report parameters. It is now possible to define whether a subreport parameter value is inherited from the parent report.

=== IMPROVEMENTS ===

* [DuckDB] DuckDB engine updated to v1.4.3.
* [SQL Editor][AI Chat] Switching between dark and light themes now works more correctly.
* [Tips] Updated tips translations.

[Valentina DB]
* Improved performance of UDF and scalar built-in functions.
* Journal is now always truncated on Flush() to its minimal size (4 KB header).

[Query Editor]
* The Select tab has been updated: the Function column is renamed to Aggr Function, the Filter column is renamed to Where, and Where/Having columns now accept conditions starting directly with an operator (e.g. = 'PG' instead of rating = 'PG').
* Where and Having cells now display only the condition value (right-hand side) for a more compact view.
* Tooltips on the Execute button now reflect the keyboard shortcut configured in Settings.

[Form Editor]
* Added a text property to the QLabel class definition.
* Auto-completer is now added only when a combo box is editable.

* [Form Editor] Improved defining signal handlers dynamically. The preferred way to create dynamic signal–slot connections is to use a signal member variable, e.g.: this.tabWidget.currentChanged.connect.
* [Data Transfer] Now supports transferring records in batches, providing a significant speedup over network connections. Configurable records-per-batch count, with optional multi-row binds for Valentina DB, DuckDB, and SQLite. Batch configuration is saved in the mapping file.

=== FIXES ===

* [Dump] BOM is now added only for UTF-16/32 encodings and only at the beginning of the file.
* [Form Editor] Fixed getting the CheckBox stateChanged signal parameter value.
* [Report Editor] Fixed printing reports to ODT format.

[Valentina DB]
* SUM/CASE aggregation on an ENUM field no longer always returns 0.
* ENUM fields in IF/CASE clauses now produce correct results.
* Fixed: only one journal file was created when opening two databases with a shared journal folder.
* Fixed: a DATE field was incorrectly affecting an unrelated foreign key.
* Fixed journal file location when cloning a database.
* Fixed: HAVING no longer prevents use of a column that appears in GROUP BY but is absent from the SELECT list.
* Fixed incorrect sorting when using ORDER BY over an aggregative result.
* Fixed: a multi-column unique key was incorrectly preventing UPDATE operations.