Valentina Studio Pro

Recognizes potential foreign keys based on field names using regular expression patterns.

Valentina Studio FREE | Single | PRO
Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines database management with diagramming, forms creation, reporting and database continuous integration. Available on Windows, Linux and macOS.

• [New][PRO] – ‘VIRTUAL LINKS’ by Rules. Useful for databases when Foreign Key links between tables are not used. Choose from predefined rules or create your own. A rule can recognize any number of such ‘Virtual Links’ automatically.

Virtual Links are not saved into the schema of a database. Virtual Links can appear within Valentina Studio PRO where a normal link can be used and this makes sense:

• Schema Editor
• Data Editor
• Diagrams
• SQL Auto-completion

https://valentina-db.com/en/discussions/9935-valentina-release-13-9-adds-powerful-virtual-links-feature-to-studio-pro

Valentina Studio FREE | Single | PRO
Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines database management with diagramming, forms creation, reporting and database continuous integration. Available on Windows, Linux and macOS.

• [New][Data Editor] – ‘Foreign Key Value Editor’ now has the layout switching menu.
• [Imp][SQL Editor] – Move “Use Parameters” checkbox to the top of the right panel.
• [Imp][DataEditor] – New Tooltip over ForeignKey cell
• [Imp][DataEditor] – New Tooltip over ForeignKey column
• [Fix][SQLite] – Fixed showing/editing Boolean values

https://valentina-db.com/en/discussions/9931-valentina-release-13-8-1-adds-data-editor-options-to-studio-and-more

Valentina Studio FREE | Single | PRO
Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines database management with diagramming, forms creation, reporting and database continuous integration. Available on Windows, Linux and macOS.

• [New][Data Editor] – new feature: Foreign Key Value Editor added to the Data Editor. Select a Primary Key value for a Foreign Key cell. Open a popup using CMD+click or a button below the edited cell. Open this dialog as a modal window using double-click or the content editor button below the table view. Also works for ObjectPtr in ValentinaDB
• [Fix] – switching to Schema Editor and selecting the new database created/opened on the Start Page.
• [Fix] [SQL ANALYZER] query with SELECT and 2 or more more sub-SELECTs deeper.

Learn more about this new editor on the Valentina WIKI.

https://valentina-db.com/en/discussions/9915-valentina-release-13-8-adds-foreign-key-value-editor-to-valentina-studio

Valentina Studio FREE | Single | PRO

Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines database management with diagramming, forms creation, reporting and database continuous integration. Available on Windows, Linux and macOS.

• [Imp][Prefs][Data Editor] – Add ‘Colorize Values’ setting to disable colors in the Data Editor.
• [Imp][Wizard][Create Dump] – Add button tooltip, replaced “Continue” with “Run”.
• [Imp][Wizard][Load Dump] – replaced “Continue” with “Run”.
• [Imp][Wizard][Export Text] – Auto-generate destination file name, replaced “Continue” with “Run”.
• [Imp][Schema Editor][Valentina DB] – Added “Register Database”, “Upload Database”, “Register Project”, and “Upload Project” to database and project lists on a VServer in the Schema Editor.
• [Fix][Data Editor][Valentina] – Fixed the update of the related panel after linking
• [Fix][SQL Editor][Valentina] – Fix to use the correct template for all “Insert Record” commands.
• [Fix][SQL Editor] – Fix collect identifiers with ‘StartsWith’ autocompletion mode.
• [Fix][PostgreSQL] – Fixed the connection over SSL on Windows.

https://valentina-db.com/en/discussions/9902-valentina-release-13-7-1-improves-studio-editors,-postgresql-support

Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines database management with diagramming, forms creation, reporting and database continuous integration. Available on Windows, Linux and macOS.

• [New][Win] – crash-logs now are in human-readable format thanks to C++23.
  [Imp][SQLITE PLUGIN] – Use ALTER TABLE to rename columns.
• [Fix]In the Object Inspector, the “Temporary” checkbox correspond to an actual table property
• [New] [JS] – Added ‘fetch’ and ‘fetchSynced’ functions to JavaScript[New][Win] – crash-logs now are in human-readable format thanks to C++23.
• [Imp][SQLITE PLUGIN] – Use ALTER TABLE to rename columns.
• [Fix]In the Object Inspector, the “Temporary” checkbox correspond to an actual table property
• [New] [JS] – Added ‘fetch’ and ‘fetchSynced’ functions to JavaScript

Valentina Studio for macOS, Windows & Linux is free. Valentina Studio PRO starts at $199.99, with academic discounting available.

https://valentina-db.com/en/discussions/9880-valentina-release-13-7-improves-sqlite-support,-new-javascript-feature-for-reports

Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines database management with diagramming, forms creation, reporting and database continuous integration. Available on Windows, Linux and macOS.

• [Imp][Mac App Store Version][SQLite] – Added check in SQLite Connection Handler if location is accessible for sandbox
• [Imp][Mac App Store Version ][SSH] – Check and ask to add a folder with SSH key to “Allowed Locations”
• [Imp][SSH] – When adding a private key to establish an SSH connection, open “~/.ssh” folder by default.
• [Fix][PROJECT PLUGIN] – Issue with opening of server projects (from 13.6)
• [Fix] Issue when trying to create a copy (duplicate) of a table

https://valentina-db.com/en/discussions/9865-valentina-release-13-6-1-improves-valentina-studio,-valentinadb

Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines database management with diagramming, forms creation, reporting and database continuous integration. Available on Windows, Linux and macOS.

• [Imp][SQL Editor] – Enable ‘Execute Current’ even for single statement.
• [Imp][SQL Editor] – Restore selection after ‘Execute Current’.
• [Imp][SQL Editor] – Disable auto repeat for ‘Execute’ actions.
• [Imp][Schema Editor] – Add ‘Refresh’ action to ‘schema lists’ menu.
• [Imp][Schema Editor] – Update current list (in the tree mode) on refresh of TAB-panel
• [Imp][Schema Editor] – Added ‘Generate Docs’ action in the contextual menu of Database object to all supported databases (MSSQL, MYSQL, PostgreSQL, SQLite). [Note] – for ValentinaDB it was added in the 13.5.3 build.
• [Imp][Project] – Don’t run start script on restoring state at app start.
• [Imp][MONGODB PLUGIN] – Restore tabs with collection/view editors
• [NEW][Report Designer] – Use Python queries & expressions in reports (joining SQL, JavaScript)
• [Fix] Database view keyboard cell focus using scroll wheel on mouseover other view
• [Fix]Document display if added to empty MongoDB collection in Column mode
• [Fix] Server Admin, popup error message

https://valentina-db.com/en/discussions/9824-valentina-release-13-6-adds-python-queries-expressions-to-reports,-improves-mongodb-support

Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines database management with diagramming, forms creation, reporting and database continuous integration. Available on Windows, Linux and macOS.

• [Imp][Mac] UPDATED LIBS: SSH to 1.11.1, OpenSSL to 1.1.1w, CURL to 8.4
• [Imp][Win Intel] UPDATED LIBS: SSH to 1.11.1, OpenSSL to 1.1.1w, CURL to 8.4
• [Imp][Win][Mac] Updated PostgreSQL Client library and dump utility to 16.0.
• [Fix][Start Page][Win][Mac] Error during load and opening of Project Examples
• [Fix][Mac] Sending crash-logs. Resolved with updated SSL library
• [Fix][SQLDiff] Issue on found differences.
• [Fix][GUI][SCHEMA EDITOR] Whole space on show long text in bottom pane.
• [Fix][Diagrams] Fixed saving diagram with non-English language chosen in the Preferences.

https://valentina-db.com/en/discussions/9808-valentina-release-13-5-1-improves-ssl,-postgresql-support

Valentina Studio FREE | Single | PRO
Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines database management with diagramming, forms creation, reporting and database continuous integration. Available on Windows, Linux and macOS.

• [New] [Report Editor] Edit Query Dialog for MongoDB. Define source query in one of the following forms (controlled by the Language option of the query) using JSON and JavaScript
• [New] [Query Editor] Support for MongoDB. Supports both JSON and JavaScript
• [New] Deterministic levels for UDFs. Deterministic Characteristic for ValentinaDB added at the kernel level.

SQL Editor is now renamed and referred to as Query Editor.

https://valentina-db.com/en/discussions/9773-valentina-release-13-5-adds-valentina-reports-for-mongodb,-database-documention-project

Cumulative update of Valentina Studio series with 13.3.x, 13.3.1 & 13.3.3

Valentina Studio FREE | Single | PRO
Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines database management with diagramming, forms creation, reporting and database continuous integration. Available on Windows, Linux and macOS.

• [Imp] More Tips added
• [Fix][Report Editor] - Fixed setting font size = 12 pt from the report editor toolbar
• [Imp][Data Editor]- Button REFRESH in the main toolbar now re-apply filter if it was applied before.
• [Fix][Data Editor] - VStudio-DataEditor-FilterRow: Entered values of active filter are not visible after leaving the cell
• [Imp][Sql Editor] - 'Default Schemas' menu choices now is saved to prefs and restored on the next start of VStudio.
• [Imp][Sql Editor] - Implemented background async re-loading of idents when needed.
• [Imp][Sql Editor] - Autocompletion - TAB-key did work wrongly if applied to a “<Smart Suggestion>” item. Now it works correctly, as ENTER-key.
• [Imp][Sql Editor] - Autocompletion - ESC pressing now refreshes wrong idents. This fixes a very rare issue.
• [Imp][Sql Editor] - IdentResolver - now recognizes Valentina Report parameters $P() and $P!(), to not underline them as 2 wrong idents.
• [Imp][Sql Editor] - IdentResolver - PostgreSQL-style of type-casting 'ident::type' now is recognized. Affects PostgreSQL and ValentinaDB.
• [Fix][Sql Editor] - IdentResolver - is refreshed on changes in the 'Default Schemas' menu.
• [Fix][Sql Editor] - IdentResolver - for databases with schemas - the query of type SELECT schema.funcName()
• [Fix]Duplication of the sub-report column header (preceding control has size_type=Relative To Region option)
• [Fix][SQLite] – Can’t open SQLite databases via Open Database
• [Fix][PostgreSQL][Data Editor] – Display NULL values for timestamp in Data Editor.
• [Fix][PostgreSQL][Data Editor] – Refresh of links and functions

https://valentina-db.com/en/discussions/9617-valentina-release-13-3-improves-studio-productivity,-server#reply-9662