Valentina Studio

説明

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

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

情報

販売元

Paradigma Software

カテゴリ

Developer Tools

バージョン

17.5.3

対応OS

iOS 12.0.0+

サイズ

145.3 MB

年齢制限

4+