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 ?

New Features

[DuckDB]
* Supported connection to Valentina DuckDB Server.
* Supported connection to the MotherDuck service.
* Added new options to Preferences: Number of Threads, Memory Limit, Pivot Limit.
* Added Storage Version and Block Size parameters to the database creation dialog.

[SQL Editor] Integrated advanced formatting tools: SQLGlot and SQLParse for SQL query formatting.

[Form Editor]
* Enabled programmatic management of ListView items.
* Added the ability to retrieve scripts of a Form.
* Introduced the preCreate property for the Form object, enabling flexible setup of data sources (e.g., creating a temporary table).
* Added support for establishing signal connections within Scripts and Forms programmatically.

[Report Editor]
* Implemented report printing to OpenDocument Text (.odt) format.
* Enabled report generation from any JSON data without using a database.
* Allowed using Valentina DuckDB Server as a data source for reports.

[Valentina DB] Non-SQL Stored Procedures (Python/JavaScript) can now return a cursor.
[Data Editor] Added transactions mode.

Improvements

[Data Editor]
* Disabled double-click for opening the advanced editor for text value cells.
* Added a confirmation prompt for unlink actions.
* Introduced a filter in the “Choose Shown Columns” dialog.
* Reduced page size to 100,000 records.
* Corrected button width when viewing BLOBs.
* Enhanced Paste Records functionality - supported different separators for pasted data, added a preview of pasted records to ensure validity.

[Diagram Editor] Cmd-W now closes the current diagram instead of the entire tab.

[Form Editor]
* Added methods to the QTableWidgetItem class for retrieving item information by index or from the selection.
* Disabled the advanced editor from opening with Cmd/Ctrl when selection mode is set to ExtendedSelection for the table view control.
* Remembered the last selected language and applied it to new scripts and slots.
* Reorganized the controls palette.

[Report Editor] Updated the chart control with a modern design.
[DuckDB] Updated DuckDB library to version 1.2.1.
[SQL Editor] Added an option to insert a space after functions during autocompletion.

[Query Editor]
* Displayed RowID in the list of fields for SQLite tables.
* Ensured unique tab names are generated for each new query.

[SQLite] Updated SQLite engine to version 3.47.0.
[Scripting Documentation] Made the Help→Scripting Environment dialog non-modal, allowing easier switching between documentation and code.
[Schema Editor] Implemented natural case-insensitive sorting in tree mode.

Fixes

[Data Editor]
* Fixed buttons for editing documents in MongoDB collections.
* Fixed errors when filtering PostgreSQL enum values.
* Fixed processing of arrays with commas for PostgreSQL.
* Fixed hangs when trying to view fields with long text.

[Schema Editor]
* Fixed issues with changing DuckDB field comments.
* Fixed access to encrypted Valentina databases.
* Fixed incorrect display of object properties by preventing cross-object property leaks.
* Fixed updates after applying changes to diagrams for PostgreSQL and DuckDB.

[DuckDB] Fixed opening of read-only DuckDB files.
[PostgreSQL] Fixed an issue where a new link was incorrectly shown as real after applying changes to a diagram.
[Form Editor] Fixed filtering of records for Valentina data sources.

[Query Editor]
* Removed the database name from the table/view control header.
* Prevented automatic aliasing for the first instance of a table on the scene.

[Workspaces] Showed the status of bookmarks.
[Icons] Fixed display issues with two monitors of different DPI.