Improvements to Query Editor, Forms and use of AI in SQL Editor
Valentina Studio
Valentina Studio is the free, all purpose database management tool suite. Valentina Studio PRO adds more powerful diagramming features, more powerful visual builder tools for databases, forms creation, reports designer and more. Improvements include:
- [New][SQL EDITOR][AI] Attach a query result as context to the SQL Editor AI chat window using the menu Attachment button > Query Result. The Query Result is what you get in the SQL Editor after successful execution of a query. The AI chat window sends the Query Result in the form of CSV text (which you could get by using the Export button). Tip: Avoid sending huge results (e.g. million records) to the AI as it will consume more tokens.
- [Imp][Query Editor] The Where and Having cells now display only the right portion of a condition to be more compact
- [Imp][Query Editor] Tooltips display the keyboard shortcuts of the Execute button based on Settings
- [Imp][Form Editor] Adds the text property to QLabel class definition
- [Imp][Form Editor] Adds the auto-completer only when a combo box is editable
- [Fix][Form Editor] Get CheckBox stateChanged signal parameter value – handle QVariant enums by converting them to int in a to_any function
- [Imp][Translations] Updated translations of Tips
Valentina Studio for Windows, macOS and Linux is licensed but free. Valentina Studio Pro is $199 per OS license and includes 12 months of free updates, but also with options to extend the license to up to three years. Valentina Studio Universal is a single license that works on all three operating systems and licensed on a per user basis.
ValentinaDB
ValentinaDB is Paradigma Software advanced, object relational database and that is available in ValentinaDB Server (a part of Valentina Server) and ValentinaDB ADKs (developer components for adding runtime database support to applications). Improvements include:
- [Imp] Journal truncates on Flush() to its minimal size, equal to its header (4Kb)
- [Fix] SUM/CASE aggregation on ENUM field always returning 0
- [Fix] Enum fields in IF/CASE clause producing incorrect results
All updated products are available on the Paradigma Software website. See the original announcement.