Valentina Studio 4+

Paradigma Software

    • 5,0 • 2 betyg
    • Gratis
    • Erbjuder Köp inuti app

Skärmavbilder

Beskrivning

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

Nyheter

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

Betyg och recensioner

5,0 av 5
2 betyg

2 betyg

__Daniel__ ,

A bad out of the box experience

The first thing I noticed was that the application doesn’t have retina support. In 2015 that feels really weird, making it look subpar on most current OS X devices. I realized in that moment that I probably wouldn’t use this app, but I was curious on the feature set so I tried to connect to a database anyway.

I opened a ”Connect to”-window and it defaulted to my least likely database choice: ”Valentina”. I can understand that they want to promote their own db, but it was a small annoyance. And before I noticed, I had started to fill out some connection details like SSH tunneling. When I switched to MySQL those details were lost.

At the first connection attempt I made an error on my part (didn’t connect to my VPN), and when the application tried to connect the app became unresponsive (spinning beach ball) until the connection attempt timed out.

On the second attempt I found out that it didn’t pick up my SSH-config, but I had to select a key manually. Doable, but an annoyance. And when I picked my key it would of course want me to enter the passphrase in the app and wouldn’t use my SSH-agent and keychain. I don’t want to enter my passphrase in any random app so instead I created my own tunnel ...

When I finnaly connected it worked like expected and is probably quite powerful. But it has an old or non-native feel to it that was amplified by the non-retina look. Windows can only be resized in the lower right corner, there are nested tabs that don’t feel like they belong in OS X, and there is a floppy disk icon! A floppy disk icon by itself wouldn’t stop me from using an app, but it is a big sign that tells that the developers hasn’t put enough effort in making this feel like a Mac app.

This feels like a Java desktop app that snuck into the App Store. It might be a good tool, but it isn’t the native client I’ve been looking for.

Svar från utvecklaren ,

Retina was added in 6.0 at 15 Sept 2015. Also we have switch to QT with a lots of improvements. Will be interesting to see your results with latest 7.0.x

Appintegritet

Utvecklaren Paradigma Software har angett att appens integritetsrutiner kan inkludera hantering av data enligt beskrivningen nedan. Det finns mer information i utvecklarens integritetspolicy.

Data som inte kopplas till dig

Följande data kan samlas in men den kopplas inte till din identitet:

  • Identifierare
  • Användnings­data

Sekretessriktlinjer kan variera, till exempel utifrån de funktioner du använder eller din ålder. Läs mer