The Most Innovative Database Management GUI 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, ...
Absolutely FREE (was $99)
Valentina Studio is a free multi-connection Database Administration tool that allows you to connect to PostgreSQL, Valentina Server and mySQL, and work with local database files of Valentina DB and SQLite. Why pay for less, or a bunch of individual utilities that only handle one database format?
Valentina Studio brings you powerful, visual editors for your data including:
Diagram Editor - design new diagrams or do reverse engineering, e.i explore existing databases visually.
Data Editor - easily browse table records in 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.
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 and recent connections between your devices!
See also: Valentina Studio Pro (only $199)
Get Valentina Studio Pro as an in-app purchase (pay only once) to get several advanced professional features such as:
Report Editor - visual editor of Valentina Reports that can be saved into Valentina Project file (.vsp). Reports can use as datasource mySQL, PostgreSQL, SQLite, Valentina DB, ODBC.
Diagram Editor - enables forward engineering - i.e. generation of SQL scripts for new/changed database objects.
SQLDiff - find differences between two states of a databases and generate SQL script to move between these states.
Data Transfer - copy records of few/all tables of db1 to corresponded tables of db2.
Import from xCode model to assist in coverting CoreData into other SQL schemas.
New:SQL Editor is able to show all results of a few SELECTs, executed at once. Each in separate TAB-panel. Works for SQLite, MySQL and PostgreSQL.
Search in SQL Editor result grid.
Added JSON format for dumps of databases, tables and results of SQL queries.
Show list of built-in extensions for SQLite.
Added print_if_empty property for sub-reports in Report Editor.
Sync tree of databases in Diagram Editor with a selected database in Columns/Tree view mode.
Server Admin is working better with errors from connection now.
Improved autocompletion in SQL Editor: show light grey prediction, more info, cmd+. shortcut, as in Xcode.
Improved work with Favorite Queries of SQL Editor. Can be changed order, renamed, changed text, ...
Improved search in SQL Editor.
Speed of SSH connection improved.
Client library for MySQL connections switched from Drizzle to MariaDB.
Autoincrement property of a table is shown and can be edited in the Inspector.
Dump loading improvements for MySQL, PostgreSQL, SQLite.
Fixed connection to MySQL servers with old-format passwords.
Fixed issue, when setting NULL directly into cell of FK field in Data Editor does not hide linked record automatically.
Fixed editing of field type in the Inspector of Diagram Editor.
Fixed work with Oracle ODBC connection.
Fixed work with FileMaker ODBC connection.
Fixed crash on change of cardinality of SQLite FK link.
Fixed work with Open/Save file dialogs in OS X 10.8.3.
Valentina Studio (com.paradigmasoft.vstudio) is a Mac software application that has been discovered and submitted by users of Software.com.
The latest version that our users have reported running on their systems is Valentina Studio 5.2. The most popular version of this application used by our users is Valentina Studio 6.6.4.
Operating System: Mac
Default Install Path: /Applications/Valentina Studio.app
Bundle Information: Valentina Studio 5, (c) 1998-2013 Paradigma Software, Inc.
Copyright: Copyright 1998-2013 Paradigma Software, Inc.