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

[Valentina DB]
* Support for Extensions added (C, C++, Python, JavaScript) to create custom functions and procedures.
* SQL 2003 aggregate functions for regression analysis added.
* INSERT statements now support the RETURNING clause for efficient retrieval of inserted values.

[Data Editor]
* The Related Data Editor menu now includes "Create Virtual Link".
* Connection icon added to the toolbar.
* Yellow warning icon shown if a table has no primary key or unique field (also in the Create Table dialog).

[SQL Editor]
* Autocompletion now supports VIEW fields.
* Three autocompletion modes are available: StartWith, Contains, Wide (configurable in Preferences or via the Autocompletion menu).

[Start Page]
* Progress bar displayed during the first Bonjour scan.
* Buttons added to toggle filters in the columns.

[Server Admin]
* Application name displayed in the connection list for Valentina, SQLite, and DuckDB servers.

=== IMPROVEMENTS ===

[DuckDB]
* Databases are now created with the default storage version if none is specified.
* Use Parquet V2 for backups.

[MariaDB]
* JSON editor enabled.
* Special connection icon displayed when connected.

[Report Editor]
* Line width menu now shows values in the current unit.

[SQL Editor]
* Improved behavior of the "Execute Current" action.
* Autocompletion menu performance significantly improved (up to 100x faster for large schemas; max 1000 items displayed).

[Start Page]
* Tooltip added for the Bonjour Pane.

[MySQL]
* Use INFORMATION_SCHEMA.KEYWORDS for autocompletion if available.

[PostgreSQL]
* Added "Refresh Materialized View" action.
* Support added for showing and creating indexes on materialized views.

[Data Editor]
* Improved tooltips and UI for transaction mode; separate transaction settings button added.
* Further improvements to transaction mode tooltips and UI.

[Query Editor]
* Complete rewrite with visual redesign.

=== FIXES ===

[Data Editor]
* Columns now resize to fit contents when switching layouts.

[Form Editor]
* Undo now works correctly after widget moves.

[SQL Editor]
* Fixed "Unsafe operation" popup for ON UPDATE ON CASCADE.
* Corrected case change when copying query text.
* Fixed parsing of '?' placeholders for PostgreSQL.
* Autocompletion no longer adds extra parentheses.
* ENUM values now display correctly in PostgreSQL query results.

[Diagrams]
* Fixed creation of new links.
* Auto-growing of the table control when adding fields enabled.

[PostgreSQL]
* Infinity and -Infinity now display correctly in data grids.
* "Infinity" date fixed in the Data Editor.

[Valentina DB]
* SUM and AVG now return SQL NULL for empty tables.

[Server Admin]
* Fixed sorting of multi-part Valentina Server log files.

[Application]
* Always opens a new main window when clicking the app icon if no windows are open.

=== LIBRARY UPDATES ===

* DuckDB updated to 1.3.1
* SQLite updated to 3.50.4