Valentina Studio

Name: Valentina Studio
Rating: 4.3636 (8 reviews)

Version 13.0.3

Follow this app Developer website

Free

In-app purchases

Download (159 MB)

Valentina Studio overview

Valentina Studio is a cross-tool for database architects, developers, DBAs and even end users to work with the most popular RDBMS such as MySQL, PostgreSQL, SQLite, SQL Server and ValentinaDB. You can do data modeling using different diagrams, work with database schema and records, do SQL development, do server administration, etc.

In PRO Edition ($199) you can develop a Valentina Project where design Reports and Forms automating them using JavaScript. This project can be used in multi-user way if you put it under Valentina Server.

FREE Edition brings you powerful, visual editors including:

Diagram Editor - design your new db here then generate tables and other db objects from that diagram.
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, ...
Data Editor - easily browse table records in a grid, modify records, 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 an saved favorite queries, templates, console with error/warning reporting, ...
Query Builder - build SQL queries visually using just a few mouse clicks.
Server Admin - where you can manage users, learn logs and other parameters of servers.

PRO Edition adds more tools:

Valentina Project - keep here reports, forms, javascripts
Form Editor - design forms
Report Editor - design reports

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

What’s new in version 13.0.3

Updated on Mar 10 2023

New:

[Diagram Editor] Added the ability to create diagrams for MongoDB.
[SQL Editor][Pro] Implemented editing the result for SQL Server databases. Show a warning if a cursor is Read-Only with
a hint on how to make it writable (add FOR BROWSE or set the NO_BROWSETABLE option).
[Workspace][Pro] Workspaces save the state of opened editors and will restore it the next time Valentina Studio Pro
starts. It includes the automatic reopening of connections and databases.

Improvements:

[Data Editor] Show the field's custom color in the column header.
[Diagram Editor] Extracted the editor as a separate tab.
[Report Editor] Added the ability to close property editors with the CMD+Enter keyboard shortcut.
[Schema Editor] Properties and other data are fetched in separate threads.
[Schema Editor][Tree Mode] Filters in a tree mode are much faster now.
[SQL Editor] Static Analyzer and Ident Resolver improvements.
[SQL Editor] Added the 'Cancel' button to stop query execution for SQLite and MongoDB databases.
[SQL Editor] Highlight syntax in multiline dollar-quoted string literals for PostgreSQL.
[SQL Editor] 'Escape' key now closes the console (if shown).
[PostgreSQL] Updated client and dump utilities to version 15.
[SQL Server] Updated Compatibility Level database property - added newer server versions, including 2022.
[SQLite] SQLite library updated to version 3.40.0.
[SQLite] Optimized generated queries to add indexes.

Fixes:

[Dump Wizard] Fixed showing dump progress for tables with more than 2^31 records.
[Form Editor] Fix saving the current splitter position/current pane for forms.
[Query Editor] Fixed showing field names of a PostgreSQL view.
[Schema Editor] Fixed showing field names in the Design Table dialog in some cases.
[SQL Editor] Trackpad was not very responsive with option 'Wrap text' enabled.
[Report Editor] Removed useless whitespace on wrapping a text.
[Report Editor] Fixed wrapping of long text without punctuation and spaces.
[SQL Server] Fixed showing user-defined types in the list of field types.
[SQL Server] Show the correct tooltip for the Variant type column.
[SQLite] Indexes on function do not show up in the table indexes list.
[Valentina DB] SHOW VERRORS command missed some error items.
[Valentina DB] Fixed testing Boolean fields with IS TRUE/IS NOT TRUE conditions.
[Valentina DB] Fixed creating a Boolean column with a default value.
[Valentina DB] Fixed diagnosis for hash indexes.

Information

License

Free

Size

159 MB

Developer’s website

https://www.valentina-db.com/en/valentina-studio-overview

Downloads

14971

App requirements

Intel 64
Apple Silicon
macOS 10.14 or later

0.0

(0 Reviews of )

There are no reviews yet

Comments
User Ratings

Michael Frankel

Aug 30 2021

11.4.2

Version: 11.4.2

I went to their Web Store, "purchased" their software, then attempted to log-in to their web portal. WHAT A TOTAL DISASTER. I set up an account, which they require, and then attempted to log-in, MANY, MANY TIMES. It failed every time and now I'm locked out of an account I JUST CREATED. Is it so difficult to do this?? This entire process was created by a crazy person. If the software is this unfriendly it will be a VERY short-lived relationship. AND NO, I WILL NOT REQUEST HELP or SUPPORT ON SOCIAL MEDIA!!

ray-brooks

Jun 10 2018

8.3.1

5.0

Version: 8.3.1

Saves me hours and hours of job time.

adamius222

Jun 5 2018

just impressive

korunova-irina

Apr 9 2017

7.0.3

Version: 7.0.3

+++++

ggt667

Jul 29 2016

6.5.6

3.0

Version: 6.5.6

Really nice browser to do drill down on your database, yet this is nagware. If you can survive nagging, this may or may not be the best drill down interface to explore your SQL database.

Matteodefelice

Feb 24 2016

6.3.2

4.5

Version: 6.3.2

It seems nice you need to register to use it freely but it's ok! I tried similar softwares but this one looks great, it connected to a remote database easily and very quickly...

Moxiesozo

Nov 18 2015

6.0

Version: 6.0

Current version is 6.1.2

lichtenauer

Mar 25 2013

5.1

Version: 5.1

great release. We are using valentina since many years now. it replaced mysql server in our applications. It's always a pleasure to see how great support works from these guys and version 5 is a really great and feature rich release.