Valentina Studio

Valentina Studio

By Paradigma Software

  • Category: Developer Tools
  • Release Date: 2013-03-22
  • Current Version: 13.9.1
  • Adult Rating: 4+
  • File Size: 161.50 MB
  • Developer: Paradigma Software
  • Compatibility: Requires iOS 10.14.0 or later.

Description

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

Screenshots

Reviews

  • Amazingly easy to use

    5
    By coruus
    Wow, wish I’d found this a long time ago. Been using Workbench and it’s always been a fight. Not so with Valentina. Thanks!
  • Just as good or even better than the paid-for alternatives

    5
    By Hansaplastique
    I've been using Valentina Studio for quite a while now, and although not perfect, it most certainly gives the paid-for alternatives a run for their money. Highly recommend this one!
  • Best SQL Client for Mac

    5
    By 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.
  • First impression: fantastic

    5
    By Nori Shohara
    I have straightforward need to interact with a Mariadb databases on a remote host. VSS opened my databases and let me edit tables and content in seconds. Couldn’t ask for anything more and the price is unbeatable.
  • no, paid in app purchases mean it is not 100% free

    1
    By HealingOintment
    First line of app description says "=== 100% Free - [...]" The $200 in app purchase contradicts the app description. I don't know if the developer intended this contradiction or if it was an oversight.
  • to dvandusen

    5
    By rz_cpp
    It is not clear why you blame developers. It is obiouse trouble with your MAS. Please note that MAS have strong testing of apps before they are published. Ask support from Apple, may be try to google solution for your issue. Restart computer at last of end.
  • Functional app with delays and bugs

    2
    By Matt1134306
    This app was always "mediocre" but was at least "functionally" working, the latest UI update makes my eyes bleed, I'm sitting in a "pinwheel" 50% of my time using this app, and is the only app on my entire system that triggers the pinwheel. Not sure why time was spent on this gross new theme instead fix all the UX lag/bugs & pinwheels 3/5 stars
  • I use it every day.

    5
    By DeepCover
    User-friendly database management and visualization. Excellent for testing out your SQL queries.
  • Best GUI Postgres Client

    4
    By Matt Hines
    I’ve tried all GUI clients I’ve found on the internet and keep coming back to this one. I will agree that getting up and going is not perfectly clear and easy but once you figure it out, it makes since. The editor is the best part. I’m a fan of colored code and Valentina Studio does the best job with it.
  • developer

    5
    By manklar
    It is free and we know if it is free you can’t ask that much. I think it does the magic. It worked very well and got the job done. I didnt encounter any problem/error so…. 5 starts! Thank you for your work.

keyboard_arrow_up