Screenshots

Description

=== 100% Free - The Best Database Management GUI for ===
=== SQLite, MS SQL Server, MariaDB, 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, Reindex, ...

MAS version of 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 - enables autocompletion for table aliases.
* SQL Editor - format SQL queries.
* SQL Editor - edit the result of SQL queries.

What's New

Version 8.0.1

**Valentina Forms is a brand new feature and visual paradigm in the Valentina Studio.**

New:
[PRO] Valentina Forms - the most requested feature in Valentina Studio
[Data Editor] Array Editor to support a new ARRAY field type in Valentina DB.
[Data Editor] Editor for text fields now has the SEARCH field for searching inside of the big texts.
[SQL Editor] Ability to switch the source connection of the SQL Editor.
[Start Page] Show recent local deleted databases and projects with strikeout font.
[Start Page] Recent databases and projects can be sorted by date now.
[PostgreSQL] Support of Event Trigger.

Improvements:
[Data Editor] Column has the auto-size contextual menu, and button Auto-Resize similar to SQL Editor.
[Diagrams][Schema Editor] Design dialog gets the ability to change the order of children objects in NEW objects.
[Report Editor] Now the images are inserted in the original resolution (for the printer, PDF, HTML, SVG).
[Report Editor] Now shows the size of fonts in points instead of pixels.
[Report Editor] Save and restore the size of the Edit Query dialog.
[Report Editor] Fixed showing the image returned by the SQL Server.
[SQL Editor] File menu now has a new item "Open File…" for .sql files to open them directly in the SQL Editor.

Fixes:
[Data Editor] When switching to another table the current filter is removed because it has no sense for another table.
[Data Editor] Fixed Data Editor Layout saving for tables in schemas.
[Query Editor] Fixed crash when Query Editor is opened for the closed database.
[Query Editor] Add the schema name for the tables when generating the JOIN.
[Query Editor] Generate JOIN operation when the alias is set for one of the linked tables.
[Report Editor] Sorting dialog can set the order for all fields now.
[SQL Editor] Table alias auto-completion now shows RecID and OID fields.
[SQLite] Table definition parser fixed - underscore is allowed at any place of a non-quoted identifier.
[SQLite] Fixed creation of the second foreign key in the SQLite table.
[SQLite] Add newly created SQLite link as a child to the table, not only to the database.
[SQLite][Data Editor] - Fixed work with big integer values in SQLite table.
[PostgreSQL] Fixed Schema Editor hangs on big tables.
[PostgreSQL] Fixed reindex action of PostgreSQL table.
[PostgreSQL] Fixed error on getting PostgreSQL 10 sequence properties.
[PostgreSQL] SQL Dump updated to support all recent releases of PostgreSQL 10.x,
[SQL Server][Data Editor] Escape single quotation marks in entered text.

Ratings and Reviews

Best SQL Client for Mac

Richard Haussmann

Like most of the people reviewing this product, I’ve cycled through most of the other Mac clients in and out of the iTunes store. I’ve always had to fall back to Valentina. Valentina Studio is packed with features, so the GUI takes some getting used to. The free version has enough features to make this a primary tool for pulling queries. The pro features (which I haven’t tried) are mostly time savers and focus more on managing databases and reports. There are some other clients with a simpler interface that “feel” better but none of them seem to be able to handle the different types of databases I need to access.

Developer Response

Richard, thank you for the nice review. About simple GUI in other tools. We always open to hear:
Look guys, this action in this tool takes 3 clicks in vstudio 5 clicks. We will check and think if we can improve that action also.

Once again, thank you :)

tab cycling

putorel

I find it very productive to have the result of a query open up in a new tab; however it will be great if you can provide a combination of keys to be able to cycle through those tabs ( you already have that for the first row of tabs, like when a new sql editor opens up).

also, now that I am here, it would be useful to be enable sql script formatting when creating a view or a function script

Reponsive developer!

ironiridis

5.6.2 does not support PostgreSQL materialized views, but 5.7 will. Filed an issue (#6972) with the developer and they addressed it in 4 days. Amazing. Any app with developers that pay attention is worth using.

Per my original (negative) review, there’s still some frankly clumsy support for SSH Public Key authentication. But that’s easy to work around, and Valentia Studio may now become my preferred SQL IDE on OS X.

Information

Seller
Paradigma Software
Size
60.1 MB
Category
Developer Tools
Compatibility
Languages
English
Age Rating
Rated 4+
Copyright
© 2018 Paradigma Software Inc.
Price
Free

Supports

  • Family Sharing

    With Family Sharing set up, up to six family members can use this app.

More By This Developer