Switch to: V12V11V10V9V8V7V6V5

Valentina Release 12.0 Notes

Release 12.0.0

2022-02-14

Valentina Studio

[New] MongoDB

  • [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)

[New] Workspaces

  • [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.

Others

  • [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.

Valentina DB

  • [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.

Release 12.0.1

2022-02-15

Valentina Studio

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

Release 12.0.2

2022-02-19

Valentina Studio

  • [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.

Release 12.0.4

2022-03-05

Valentina Studio

  • [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.

Release 12.0.5

2022-03-10

Valentina Server

  • [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.

Valentina for Python

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

Release 12.0.7

2022-03-14

Valentina Studio

  • [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.