Category: Valentina Studio

Now we have v4 and v5 WIKIs

Now we have two separate wikis to keep docs of v4 and v5:

Valentina Studio v5 will to v5 section, vstudio v6 will point to v5 section, and so on.
Old url http://www.valentina-db.com/dokuwiki  will point to the docs of the current official release.

[NEW] VStudio – Check Updates

We have add into Valentina Studio feature “Check Updates”. Only Mac App Store version will not have it, because AppStore itself take care about updates.

On start Valentina Studio will send a GET query to valentina-db site. This will happens in separate thread to not delay user in the case of network trouble.

You will be able enable/disable this feature in prefs panel, also you can specify if report about beta builds of vstudio.

I want note, that in this GET query we also will send some anonymous information such as:

  • OS on which works studio
  • version of studio
  • 32 or 64 bit architecture
  • MD5 hash of MAC address of the computer.
We going to use this hash as anonymous identifier of some computer where vstudio is started. So we will be able, to see that e.g. 30% of users start vstudio  each day, 10% once per week … may be something else …
Future we going add yet automatic sending of crash log if any. Again such anonymous identifier will allow us link that crash logs together in our database.
Also we thinking about adding into Valentina Studo of integration to our Mantis bug tracker, so user can report issue or make a feature request right from vstudio.

[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

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.

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.