Captures d’écran


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


Version 8.0.1

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

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

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

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

Notes et avis

bonne app. et un rapport qualité/prix imbattable (c’est gratuit et ça marche !)


tout est dit dans le sujet...

Excellent !


Excellent complément à phpmyadmin
Découverte fortuite et très heureuse !
superbe 1ere impression.


Paradigma Software
60.1 Mo
Classé 4+
© 2018 Paradigma Software Inc.

Prend en charge

  • Partage familial

    Jusqu’à six membres de la famille peuvent utiliser cette app lorsque le partage familial est activé.

Du même développeur