Valentina Studio, Administrator Edition is the first of a new family of products from Paradigma Software.

Valentina Studio is a software that exemplifies ease of use in the creation and management of Valentina databases of any kind: desktop, network and internet.

Here are some key features of "Valentina Studio":

Architecture and Design:
· Plugin Architecture Valentina Studio is designed as executable with set of plugins. Each plugin adds own functionality, can be enabled/disabled at any time with help of plugin Manager.
· TAB Windows Valentina Studio offer you main window which can contains set of TAB-windows.
· Dockable Views Valentina Studio has windows which are dockable, i.e. you can make them floating, or stick into any location of main window.
· Toolbars Valentina Studio have the set of toolbars, which you can show/hide to get the best configuration for your needs.
· Prompt Tooltips Valentina Studio tends to show a tooltip in any place, where some string is not shown completely.
· Information Tooltips often Valentina Studio is able to show for some objects a tooltip that has additional information, not visible from this place.
· Contextual Menus in a lots of places and for a lots of objects you can use contextual menu to see actions that this object is able to do now.

Schema Editor:
· Diagram Editor You can create few diagrams for a database. Each diagram can keep one, few or all tables of database. Working with Diagram you can completely manage Schema of database in graphical way.
· List and Column Views Valentina Studio provides two ways to browse a database schema: the first is a traditional hierarchical tree, the second is 4 columns similar to MAC OS X Finder.
· Multi-Object Operations You can select, for example, several tables or fields and do some action for this group, e.g. drop them, or change some settings.
· Multi-Table Browsing you can select few tables, and get list of all their fields in single column then filter it. This simplify work with databases that have big number of tables and fields.
· Create/Drop/Alter/View Tables you can create a new table or drop existed one using GUI.
· Create/Drop/Alter/View Fields you can create/drop/modify fields, specify type, name and any other required parameters.
· Create/Drop/Alter/View Methods you can create/drop Table Methods (aka Calculation Fields) and specify the same parameters as for fields plus formula of method.
· Create/Drop/View Links you can create/drop links of any kind: Foreign Key, ObjectPtr, Binary Link.
· Create/Drop/Alter/View Constraints you can create/drop constraints such as PK, FK, Unique, ...
· Create/Drop/Alter/View Indexes you can create indexes
· Create/Drop/Alter/View VIEWS you can manage VIEWs in database.
· Create/Drop/Alter/View Triggers you can manage triggers of the database.
· Create/Drop/Alter/View Stored Procedures you can manage stored procedures of the database.
· Create/Drop/Alter/View Scheduler Events you can manage events of Valentina Server Scheduler.
· Encrypt/Decrypt Objects you can encrypt/decrypt a database, table or field.
· Warning Mode If Valentina Studio recognize something wrong in database schema then it display an object with warning sign.

Inspector:
· Inspector Window allows you see and change parmaters of the selected object. Inspector mostly is used in the Schema Editor, but can be used with Data Editor also to display picture previews and link diagram.

Data Editor:
· Browsing Records of a Table you can browse records of a table in the spread-sheet style.
· Inline Editing you can enter into the edit mode for a cell (field) by mouse double click.
· Inline Picture Preview you can set option to see preview of pictures right in the spreadsheet. Usually in this mode its good idea increase height of a row.
· Inspector Picture Preview Inspector show middle-size preview for all picture fields that present in the table. You can close/open preview for one or few fields.
· Picture Extended Editor by double click on a cell you can open Extended Editor for this cell. If this is a Picture field you will get Picture Extended Editor, where you can resize picture as you want, save/load picture from file, see info about picture.
· Text Extended Editor by double click on a cell you can open Extended Editor for this cell. If this is a TEXT field you will get Text Extended Editor, where you can see and edit multi-line text.
· RecID/OID Fields View you can hide/show these fields of a Valentina Table.
· Table Methods View you can hide/show Table Methods (aka calculation fields). IF they are shown you see them in light grey color, what means you cannot modify them.
· Filter of Records powerful feature which allow easy filter records of the Table without SQL query. You add green filter line, then type into its cell one or few conditions to be applied as filter. Rules and syntax the same as in SQL query, e.g. f1 > 25.
· Sorting Records you can easy sort records of the Table by single column by click on its header. Next click will change direction of sorting from Ascending to Descending, and next click remove sorting by this column at all. First 2 states are indecated by small triangle icon in the column header.

Related Data Editor:
· Unique Revolutinary feature, introduced by Valentina Studio. It allows to browse linked records of 2 tables, link/unlink one or even many records by a single mouse click, do SET operations on linked records.
· Any Link kind Related Data Editor is able work with two tables linked by any kind of Link: Foreign Key, ObjectPtr, BinaryLink.
· Any Cardinality The Link can have any cardinalty: 1:1, 1:M, M:M
· SET Operations You can very easy do SET operations such as Union, Intersect, Difference, Symmetric Difference on group of records of T2 linked to records of T1.
· Link-Mode View You can easy switch between different modes to see all records of T2, only T2 records linked to selected records of T1, unlinked records...

SQL Builder:
· SQL Builders allows visually using drag and drop, mouse clicks and typing into spread sheet build quite complex SQL queries.

SQL Editor:
· SQL Editor allows to execute any SQL query against your database (locale or remote) and see results in the spread sheet.
· Auto completion while you type SQL command, Valentina Studio will show you list of possible completions.
· Syntax Coloring SQL Editor will use colors for your SQL command.
· TABs Windows Result of SQL command is opened in a new TAB window. You can return back to first table, modify SQL command and open new result in a new TAB.
· Console View display information about execution of SQL command: time, errors, ...
· Controls for Cursor Mode you have 3 popup menus to choose between client-side or server-side cursor, as well as lock types for server-side cursor, and if it should allow Forward Only or Random navigation.
· Menu of Recent Queries contains list of previous successful SQL commands.

Limitations:

· Unregistered version is time-restricted to function only 10 minutes per launch.

What's New in This Release: [ read full changelog ]

· Adds a significant, new feature to Valentina SQL, plus several minor features and many customer requested fixes and improvements.