We stand with Ukraine to help keep people safe. Join us
Valentina Studio
Valentina Studio
4.4
0.0
Valentina Studio free download for Mac

Valentina Studio

Version 13.0.3

Free database manager for many databases.

4.4
Based on 11 user ratesRead reviews & comments
Free
In-app purchases

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

Downloads

15038

App requirements

  • Intel 64
  • Apple Silicon
  • macOS 10.14 or later
Try our new feature and write a detailed review about Valentina Studio. All reviews will be posted soon.

Write your thoughts in our old-fashioned comment

MacUpdate Comment Policy. We strongly recommend leaving comments, however comments with abusive words, bullying, personal attacks of any type will be moderated.
0.0

(0 Reviews of )

There are no reviews yet
  • Comments

  • User Ratings

Michael Frankel
Michael Frankel
Aug 30 2021
11.4.2
0.0
Aug 30 2021
0.0
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
ray-brooks
Jun 10 2018
8.3.1
5.0
Jun 10 2018
5.0
Version: 8.3.1
Saves me hours and hours of job time.
adamius222
adamius222
Jun 5 2018
8.3.1
5.0
Jun 5 2018
5.0
Version: 8.3.1
just impressive
korunova-irina
korunova-irina
Apr 9 2017
7.0.3
5.0
Apr 9 2017
5.0
Version: 7.0.3
+++++
ggt667
ggt667
Jul 29 2016
6.5.6
3.0
Jul 29 2016
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
Matteodefelice
Feb 24 2016
6.3.2
4.5
Feb 24 2016
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
Moxiesozo
Nov 18 2015
6.0
0.0
Nov 18 2015
0.0
Version: 6.0
Current version is 6.1.2
lichtenauer
lichtenauer
Mar 25 2013
5.1
5.0
Mar 25 2013
5.0
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.
ray-brooks
ray-brooks
Jun 10 2018
5.0
Jun 10 2018
5.0
Version: null
adamius222
adamius222
Jun 5 2018
5.0
Jun 5 2018
5.0
Version: null
korunova-irina
korunova-irina
Apr 9 2017
5.0
Apr 9 2017
5.0
Version: null
rz192072
rz192072
Apr 6 2017
5.0
Apr 6 2017
5.0
Version: null
ggt667
ggt667
Jul 29 2016
3.0
Jul 29 2016
3.0
Version: null
Matteodefelice
Matteodefelice
Feb 24 2016
4.5
Feb 24 2016
4.5
Version: null
Ededed
Ededed
Apr 22 2014
4.0
Apr 22 2014
4.0
Version: null
ErikMH
ErikMH
Apr 16 2013
4.5
Apr 16 2013
4.5
Version: null
lichtenauer
lichtenauer
Mar 25 2013
5.0
Mar 25 2013
5.0
Version: null
emi14
emi14
Mar 23 2013
2.0
Mar 23 2013
2.0
Version: null
Jda
Jda
Mar 22 2013
5.0
Mar 22 2013
5.0
Version: null
Free
In-app purchases
How would you rate Valentina Studio?
Similar apps
SQLPro for SQLite
Advanced SQL editor.
Is this app is similar to SQLPro for SQLite? Vote to improve the quality of this list.
Vote results
0
Upvotes
6
Total score
0
Downvotes
SQLiteManager
Database manager for SQLite databases.
Is this app is similar to SQLiteManager? Vote to improve the quality of this list.
Vote results
2
Upvotes
2
Total score
0
Downvotes
Sequel Pro
Manage MySQL databases.
Is this app is similar to Sequel Pro? Vote to improve the quality of this list.
Vote results
1
Upvotes
1
Total score
0
Downvotes
DB Browser for SQLite
Create database files compatible with SQLite (was SQLite Database Browser).
Is this app is similar to DB Browser for SQLite? Vote to improve the quality of this list.
Vote results
1
Upvotes
1
Total score
0
Downvotes
Navicat for SQL Server
Graphically manage SQL Server databases.
Is this app is similar to Navicat for SQL Server? Vote to improve the quality of this list.
Vote results
0
Upvotes
1
Total score
0
Downvotes