Subject explains all.
Will be available for the next 5.0b40 build.
Category: Valentina Studio
[NEW] VStudio + iValentina now sync bookmarks using iCloud
We have made first step to support iCloud technology from Apple.
Now Valentina Studio for MAC OS X (and only one, which is download from MacAppStore) will have iCloud prefs pane, that allows you to specify what to synch in the iCloud. For now this is bookmarks and resent connections to db servers.
Continue reading [NEW] VStudio + iValentina now sync bookmarks using iCloud
Valentina Studio gets redesigned Server Admin tool
This tool now can work with Valentina Server, PostgreSQL and mySQL.
This is the central place where you can:
- manage databases: create, drop; register/unregister, …
- manage valentina projects: create/drop, register/unregister, …
- manage users, groups and roles
- view server-side log files
- view and edit ini-file parameters of a server
[NEW] Valentina Studio – Postgre plugin – now can dump/load using pg_dump engine
We was able embed into Valentina Studio plugin the pg_dump engine to dump a database into different formats of text files and load these text files back into database.
You can access these dump/load commands from the File menu of Valentina Studio application or from the contextual menu of a database object.
Continue reading [NEW] Valentina Studio – Postgre plugin – now can dump/load using pg_dump engine
Valentina Studio now is able sync Column and Tree views on switching
This feature can be turned on/off in the preferences of Valentina Studio application. By default it is ON, because this provides natural behavior of schema editor.
VStudio – improve of keyboard shortcuts
We have made last days many polish of keyboard shortcuts in the SQL Editor and in the Schema Editor.
Schema Editor – its shortcuts correspond to Apple Safari:
| Back | cmd + [ |
|---|---|
| Forward | cmd + ] |
| Previous TAB | cmd + shift + { |
| Next TAB | cmd + shift + } |
SQL Editor also adopts its shortcuts to use standards of corresponded OS.
VStudio now can show warnings from operation
Valentina Engine far ago produce warnings in the ‘Warning.log’ for Import of Text operation. For example, record is not added if the primary key is not unique.
This warning.log is created near to application. And if this is a remote Valentina Server then user of Valentina Studio cannot easy see that warnings. Now this is improved. In Valentina engine, in Valentina Server and in Valentina Studio. Snapshot below demonstrate this.
VStudio – QueryBuilder make up and improvements
In 5.0b30 we have return back QueryBulder after few months.
* new – it works now for all supported engines: Valentina, PostgreSQL, mySQL, SQLite.
* new – we have simplify interface removing few visible areas, replacing them on TAB panels. Note that you can switch by main panels using such shortcuts as cmd+1 and cmd+2.
* new – you can specify expressions to be used in the SELECT clause.
* note that you can specify inner and left/right/full outer joins using right-click on a link on the diagram.
* note that if you will click SQL panel and then continue develop diagramm then you will see live changes in the generated SQL.
[NEW] SHOW [VSERVER] LOG command
We have added a new SQL command that works with VServer only to show tail of VServer.log file. (5.0b30)
TODO Valentina Studio now have a special panel where user can easy see this log using new command.
All together this simplify a lots work with remote VServer, especially if you do not have SSH access to its file system.
[NEW] VServer + VStudio now can show NOT registered dbs
We have extend SHOW DATABASES command to show also not registered databases located in the VServer/databases folder. To implement this VServer now is able iterate this folder to see files with .vdb extension.
Valentina Studio now take this in attention and show such not registered databases with a special icon. Also you get contextual menu with command “Register database”.
Refresh button of VStudio is able issue SHOW DATABASE command to check folder for new files if needed.
[NEW] VStudio Linux 64 bit Version
We are glad to inform you, that for 4.9.1 version we will introduce Valentina Studio for Linux 64 bit version.
In the nearest 1-2 days we should upload 4.9.1 beta build of VStudio linux 32 and 64 bits.
vClient becomes thread-safe (!)
Now you should not synch vClient API calls – vClient do it self and you are free to access and operates with vClient’s remote objects from different threads similiangly.
In particular, vStudio operates with remote connections via multiple threads and it was a source of some glitches and unexpected errors especially with a long queries. Now there are no more errors like “EOF reached…” or “Broken packet received…” which were result of incorrect thread synch.
NEW Function Browser in the SQL Editor of VStudio!
Thanks to new SHOW PROCEDURES ALL, we was able implement Function Browser in the SQL Editor of Valentina Studio.
This Function Browser contains a list of system function and used defined stored procedures and functions listed by categories such as:
Continue reading NEW Function Browser in the SQL Editor of VStudio!
NEW Left Side Bar in Schema Editor of Valentina Studio
We have added the left side bar into Schema Editor.
It looks similar to what have OS X Finder and Windows 7. This sidebar allows you easy jump to the most common and/or recent places of your job. For example, you can by single click open recent database or connection or your bookmark to a Valentina Server. Your login and password can be stored, so no need to retype them each time.
Continue reading NEW Left Side Bar in Schema Editor of Valentina Studio
NEW Tab-Panels in SQL Editor to Display Logs/Output/Warnings/Tune
We have added to SQL Editor of Valentina Studio great new feature: now you can get much more rich output from an SQL command. And this output is separated into 4 tab panels at bottom of Editor.
Continue reading NEW Tab-Panels in SQL Editor to Display Logs/Output/Warnings/Tune