Valentina Studio 4+
Paradigma Software
-
- 免费
- 提供 App 内购买项目
截屏
简介
=== 100% Free - The Best Database Management GUI for ===
=== 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).
新内容
版本 13.9.1
New Features:
[Report Editor] Added 'fetch' and 'fetchSynced' functions to JavaScript for asynchronous and synchronized execution. These functions facilitate:
* Loading a local file.
* Loading external data over HTTP protocol using the GET method.
* Loading external data over HTTP protocol using the POST method.
[Data Editor] Foreign Key Value Editor:
* Introduces a window to select a Primary Key value for a Foreign Key cell.
* Ability to open a popup using CMD+click or a button below the edited cell.
* Dialog can be opened as a modal window using double-click or the content editor button below the table view.
* Works for ObjectPtr in Valentina DB as well.
* Implements layouts for the editor.
[PRO] Virtual Links:
* Designed for databases where Foreign Key-links between tables are not utilized for various reasons.
* Virtual links are not stored in the database schema.
* In the SchemaEditor, a database contextual menu now includes a 'Setup Virtual Links' item.
* Allows users to choose from 2 predefined rules or create custom rules in the dialog. Multiple rules can function simultaneously.
* Enables Valentina Studio to automatically recognize hundreds of such 'virtual links' via rules.
* Users can manually create virtual links using the dialog.
* Virtual Links are functional in Schema Editor, Data Editor, Diagrams, and SQL Autocompletion.
* Virtual Links for a database can be synchronized using cloud services if this feature is enabled in the preferences.
Improvements:
[SQLite] Utilizes ALTER TABLE to rename columns.
[Data Editor] Implements colorization of values based on the field type.
[CSV Export] Auto-generates destination file name.
[Sync] Adds a button with a cloud icon in the main toolbar to display synchronization status.
Fixes:
[Schema Editor] Fixed the issue of switching to Schema Editor and selecting the newly created/opened database on the Start Page.
[Schema Editor][Valentina] Corrected the discrepancy in the Property Inspector where the "Temporary" checkbox did not correspond to an actual table property.
[Data Editor][Valentina] Fixed the update issue of the related panel after linking.
[Data Editor][SQLite] Fixed the display/editing of Boolean values.
[Report Editor] Addressed the problem of formatting not being applied to NULL values.
[SQL Editor] Fixed the problem with analyzing queries containing nested SELECT statements.
[ODBC] Resolved an issue retrieving data with NULL values occurring with ODBC Drivers that do not support scrollable cursors.
[MSSQL] Fixed the issue of displaying a list of databases when the user lacked permission to access backup information.
评分及评论
看起来不支持retina屏幕
it seems not yet support the retina screen
开发人员回复 ,
Retina was added in v6.0 at 15 Sept 2015.
Generally good
It will be better if there is second confirmation alert for modifying or delete data
闪退太严重了
都不知道好不好用,因为就没打开过
这个软件闪退如此严重
我都没来得及欣赏下 啧
删了删了
差评
App 隐私
开发者“Paradigma Software”已表明该 App 的隐私规范可能包括了下述的数据处理方式。有关更多信息,请参阅开发者隐私政策。
未与你关联的数据
开发者可能会收集以下数据,但数据不会关联你的身份:
- 标识符
- 使用数据
隐私处理规范可能基于你使用的功能或你的年龄等因素而有所不同。了解更多
信息
- 提供者
- Paradigma Software
- 大小
- 169.3 MB
- 类別
- 软件开发工具
- 兼容性
-
- Mac
- 设备需装有 macOS 10.14.0 或更高版本。
- 语言
-
英语
- 年龄分级
- 4+
- Copyright
- © 2024 Paradigma Software Inc.
- 价格
- 免费
- App 内购买项目
-
- VStudio Single (MySQL) ¥598.00
- VStudio Single (Valentina) ¥598.00
- VStudio Single (SQLite) ¥598.00
- VStudio Single (PostgreSQL) ¥598.00
- VStudio Single (MS SQL) ¥598.00
- Valentina Studio Pro ¥1,298.00