Development
Valentina Studio Pro
Paradigma Software
About
Valentina Studio provides powerful visual editors for your data including:
* Schema editor (in the form of a tree or columns) - create and edit all schema objects of supported databases: Tables, Views, Fields, Enumerations, Relationships, Constraints, Triggers, Indexes, Stored Procedures, ...
* Diagram editor - draw new diagrams or do reverse engineering, that is, study the existing database visually.
* Data editor - easily view table records in a table, change records, edit values directly in cells, sort, filter and save frequently used filters, image viewer, hex editor for binary values, etc.
* Linked Data Editor - explore and manage records in linked two tables.
* SQL editor - with syntax highlighting, autocompletion, query history and saved queries, templates, error/warning console, and query analytics.
* Query Editor - Create SQL queries visually with just a few clicks.
* Server admin - where you can manage users, view logs and other parameters of database servers.
Open as many editors as you need for different databases and servers in TAB panels. You will also receive various utilities such as: Import/Export, Dump, Diagnosis, Cloning, Reindex, ...
Valentina Studio allows you to sync bookmarks and snippets between your devices using iCloud or by saving to a cloud storage folder.
*** See also: Valentina Studio Pro ($199) ***
* Report Editor - a visual editor of Reports that can be saved to a Valentina project file (.vsp). Reports can use the following databases as a data source: MS SQL, mySQL, PostgreSQL, SQLite, Valentina DB, ODBC.
* Form Editor - a visual editor of Forms that can be saved to a Valentina project file (.vsp). Reports can use all supported databases as a source.
* Data Editor - gets a jump to the parent record.
* Data Editor - Layouts - save columns and their order as a named layout.
* Data editor - Multiple update - update multiple records.
* Data transfer - copy data between different databases.
* Diagram editor - receives forward design, i.e. generation of SQL scripts for new/changed database objects.
* Dump Wizard - Gets a filter of tables to select them for dump.
* Search for errors - search for error descriptions by their number.
* Keyboard shortcuts - allows you to override shortcuts and create your own sets of shortcuts.
* Query editor - gets the ability to copy a generated query.
* Schema caching - saves and uses the database schema to increase the speed of working with remote servers.
* Snapshot of the diagram - you can save and load the diagram in a structured format.
* Version control - develop your database using version control.
* SQL difference - searches for the difference between two database states and generates an SQL script for the transition between these states.
* SQL search - searches through schema objects.
* Schematic editor - copy one or more schematic objects using drag and drop.
* SQL editor - autocompletion for table aliases.
* SQL editor - formatting SQL queries.
* SQL editor - editing the result of SQL queries
* Object colors - the ability to mark an object with a specific color.