The Valentina team is happy to announce that Valentina Studio supports MariaDB, the drop-in replacement for MySQL from Michael “Monty” Widenius, the creator of MySQL.
Category: Valentina Studio Pro
Valentina Studio on Mac App Store
Valentina Studio 5.1 is now available for free through Mac App Store. Valentina Studio 5.1 was recently released with support for SSH, making it your best choice for working with virtual hosting services and the databases you may have stored there.
Valentina Studio on the Mac App Store also has in-app upgrading to Valentina Studio Pro for your convenience.
[VStudio][NEW] Support of SSH connects to remote servers
Usually mySQL servers are closed to access from external IPs. Instead mySQL users are used to connect to remote host using SSH tunnel and then connect to mySQL server like from localhost.
We have add into Valentina Studio support of SSH connects to remote hosts. It is clear that it can be used for any remote DB server: Valentina Server, mySQL or PostgreSQL.
Also we have to push SSH parameters into the connection string of Valentina Reports, so now reports can connect to e.g. remote mySQL server by SSH tunnel also. Read in WIKI.
[VStudio] MAS Submission steps
After 5.0 release we have made the first attempt to submit Valentina Studio into Apple’s Mac App Store. As expected, it was reject with a couple of fair issues and one advice to hide all PRO features in the free edition of VStudio.
Step by step we have come to a new design. On the picture you can see how start page will looks for 5.1 version of Valentina Studio (MAS).
Since we was need to remove “Projects” section anyway, we have decide to put “in-app store” of Valentina Studio on the start page instead of section “Projects”.
If a user will do in-app purchase then PRO features will be enabled and become visible. The section “Projects” will be visible again on the start page.
[VStudio][Change] Free VStudio 5.1 will be able to save diagrams and do reverse engineering.
In 5.0 Diagrams was a PRO feature, so was available in free version only in the demo mode: you could create and edit diagram, but you was not able save it for future use.
Working on submitting of Valentina Studio into Apple’s App Store, we was asked to remove from free version any such demo-features. We have decide instead remove it completely, open half of its functionality to free edition of VStudio. In 5.1 build of Valentina Studio you will be able
- create diagrams and save them into your db.
- add new schema objects (tables, fields, views, links)
- add existed schema objects of your database (reverse-engineering).
Disabled will be just forward-engineering, i.e. generation of SQL scripts to produce new schema objects and change existed.
Interesting to note, that a competing product in AppStore, asks in-app purchase 70$ for reverse-engineering. Valentina Studio 5.1 will give this for free. Enjoy 🙂
[VStudio][Improve] Server Admin Panel – Log Files
5.0b60 includes significant improve of LOG files panel of Server Admin tool.
1) Now in the list of log files of a VSERVER you can see two sections. The first is named TAIL and contains only active log files. If you choose one of them, you will see tail (end) of this file with automatic refresh. This is analog of terminal tail command.
2) We have improve protocol between VSERVER and VStudio to exclude from vserver log file commands that send VStudio itself to collect information.
3) We have extend set of SNMP commands that VSERVER supports to increase performance of talk between VSERVER and VStudio. Besides, VSERVER is able proceed these commands absolutely parallel to its main job.
[NEW][MAC] VStudio.app and installer of VServer_x64 now are signed
OS X 10.8 has option “System Settings -> Security -> General -> Allow: MAS App Store and identified developers” on default to be ON, so you cannot installed easy not signed applications and run installers. Note that 10.7 also can have this option enabled on some computers.
To resolve this issue, we have sign vstudio.app and vserver_x64.pkg installer.
Unfortunately we cannot easy sign other our installers (V4RB, V4REV, V4CC, … ) because we using third party installer. So for now, for 5.0, we going to ship these installers not signed. To run them, OS X developer should in the Finder do CTRL + click on icon of installer and choose OPEN command in the contextual menu. In this case you will see the button ALLOW in the OS X security dialog. Click it, and continue as usual.
[NEW] VStudio now is able to send a crash log file to Valentina team
In a case of crash, Valentina Studio on linux and windows now is able to create text file that contains crash log information (stack of calls, loaded DLLs, … ). MAC OS X version of VStudio have no need to do this because OS X itself generates such crash log.
On the next start Valentina Studio will show dialog with suggestion to send this crash log to Valentina-db.com. Please note, this crash log contains totally anonymous information. This information will help to Valentina team to see that there was fact of crash, and where exactly was crash. You can set check box to not show this dialog future and just send a crash report automatically if it is found.
On Windows and Linux, after sending of crash log file, it is deleted from disk of your computer. On OS X it is not deleted, because OS X append them into single file per application.
[NEW] VStudio Postgre Plugin now is able to manage Schemas
During testing of Valentina Studio one user have point that Schemas of PostgreSQL are not supported in VStudio yet. So we have spend almost 2 weeks to implement support of schemas for PostgreSQL on all levels:
- Schema Editor (trees, columns); Diagrams in development yet.
- Table Editor
- SQL Editor
- SQL DIFF
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] VSERVER as HTTP Server + Admin based on Valentina Reports
Few years ago we have added into Valentina Server HTTP port, so it have:
- normal port
- SSL port
- HTTP port
- SNMP port
We added this HTTP port to be able do the next step — implementing admin built-in right into VServer. So user can access from any browser this admin by HTTP. We see the following advantages of this:
- it is enough install server on you mac/win/linux computer and this admin will be available immediately, without need in Apache/PHP/else.
- this admin will allow to manage vserver from platforms where not exists VStudio or iValentina. For example Android users will be able manage VServer.
Such admin of vserver we was going implement on C++ of course.
But some time ago we have got idea to use Valentina Reports for this, which could do HTTP generation from report. We have spend some time to make couple of prototypes of this idea. And while we did them, we have already made few improvements in our Reports to support this. The most important are:
[Imp] VReports few improvements
Thanks to Matthew Gardner, we have made few improvements in Valentina Reports engine:
- Header section fixed to work with data from cursor.
- Expression control that produce text, now respect FORMAT field, such as currency or date. For this engine try convert string into a number, and on success apply formatting.
- System Color Dialog is used now for all places.
[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