Valentina Release 12.0 Notes

2022-02-14

• [New] MongoDB plugin - the first NON-SQL DB in Valentina Studio.
  • Schema Editor
  • Command Editor (similar to SQL Editor)
  • Collection Editor (Data editor)
  • Server Admin (manage users, databases, etc)

• youtube video (2 min) - Valentina Studio with MongoDB Overview.

• [New][Pro] Workspaces - this great feature for PRO-developers, which now get a clean isolated room for a project.
  • You can create a new workspace, which will collect Bookmarks, Recent databases, Recent SQL queries, SQL snippets, opened TAB panels (soon)
  • Switching between workspaces moves you to this or that project context.
  • [New] Menu 'Workspaces' in the main menu
  • [New] Top-Right button-menu workspaces to visualize the current workspace and manage workspaces.

• [Imp][Start Page] - COPY/PASTE a single bookmark

• [Imp][SQL Editor] - Tooltip of a snippet now shows database(s) to which it belongs.
• [Imp][SQL Editor] - Tooltip about hidden snippets.

• [Imp][Dialogs] - Dialogs to export bookmarks, snippets, etc, now suggest the default name of the file.

• [New][SQL] JOIN between 2 different databases.

• [New][SQL] Triggers on Links.
  • This allows you to CREATE TRIGGER, which will work on LINK / UNLINK commands - events.

2022-02-15

• [Fix][MongoDB] fix processing errors from the SORT option in Data Editor.
• [Fix][MongoDB] detach views before 'drop database' operation.

2022-02-19

• [New][SQL Editor] Autocomplete will display 'ON KEY DUPLICATE UPDATE SET' suggestion for command: INSERT … VALUES (…) ON

• [New][MongoDB][Command Editor] - dozen TEMPLATEs of commands to MongoDB Server. Choose - click - run.

2022-03-05

• [New][MongoDB] - Added aggregation and query and write operation commands templates

• [Imp][SQL Editor] - improve Auto-complete for special list 'ON KEY DUPLICATE UPDATE SET ',

• [Fix][SQL Editor] - Fixed crash on SQL formatting on macOS (reverted recent change to formatting library)
• [Fix][MSSQL] - fix connection to Azure for VStudio WIN.

2022-03-10

• [New] - Each job for a client inside of VServer now is able to answer which SQL command it executes.
  • [New][C++] - I_VServer interface now has method virtual I_Cursor_Ptr GetState( void ); which returns cursor with 2 columns: “client-id” and “state”.
  • [New][V4RB] - also get analog method VServer.GetState() as VCursor.
  • [New][Wiki] - VServer.GetState() method description.
  • [Todo] - this feature will be used in Valentina Studio soon to display such states.

• [New] - method report.printToLocalPrinter
• [New] - method report.printToServerPrinter

2022-03-14

• [New][SQL Editor] Static Analyzer now reports errors about an incorrect number of arguments in a function call.
  • For example SELECT sin(); or SELECT sin(2,3) will produce error now from Static Analyzer.

• [Fix] critical issue for users of Single-DB-serials.