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
This tool now can work with Valentina Server, PostgreSQL and mySQL.
This is the central place where you can:
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
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.
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.
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.
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.
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.
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.
Here we show couple of few-seconds movies that demonstrate how you can establish links between tables using new diagrams of Valentina Studio Pro.
For Valentina database you can establish Foreign Key, ObjectPtr and Binary Link. For SQLite and Postgre only Foreign Key.
Shows how you get access to “Add Link” button and then to panel, which allows you to choose link type for the left and right table.
Shows how you can establish by few mouse clicks MM link between two tables, and how this automatically creates third MM table and FK fields in original table(s).
We have made a couple of benches of our new SQL DIFF feature of Valentina Studio Pro v5.0 Results are quite impressive.
We are glad to inform you, that we already have working Valentina Reports engine with datasource from mySQL.
We have use one of BSD clients compatible with mySQL Server. This resolve any issues related with GPL-license of mySQL native drivers.
Please note, that this mySQL datasource for now works only for Valentina Reports ADK, but not in Valentina Studio – Report Editor. To prepare reports in the GUI Editor you need to use Valentina or Postgre or SQLite database with the same tables. But do not worry, in about 1.5-2 months we will introduce 5.x version of Valentina Studio, with full-featured mySQL plugin also.
Right now, you can make dump of schema of mySQL database, and load that dump into local Valentina DB, then use it as test-db to design report(s). Later, from ADK application, just specify mySQL datasource against this report(s). For mySQL you should use connection string of kind
theReport = my_project.MakeNewReport( "report_1", "mysql://host=192.168.2.33, user=admin, passw=admin", "SELECT fldName, fldPhone FROM tblPerson" )
Valentina Studio saves diagrams right into the database, even while working remotely with Valentina Server and PostgreSQL server. Since teams of developers can work on a server at the same time, how do you manage diagrams? Valentina 5 implements locks of diagrams and lock management through Valentina Studio.
For example, if user1 opens a diagram to edit. Then, user2 tries to open it. User2 will get the following dialog with the choice to open diagram in the read-only or exclusive mode.
Valentina DB maybe the only database engine which gives you ability to specify collator properties of the Database->Table->Field chain using inheritance.
For example, you can specify Collator.strength = kPrimary for Database object, and all its tables and their fields also will get the same value.
Even better. You can specify another value for some table or field, e.g. tblPersonFrench.Collator.strength = kSecondary, which overrides settings of parent object. If later you decide to change Database.Collator.strength to e.g. kTertiary, then all tables except tblPersonFrench inherit this new value. But tblPersonFrench will preserve its own value kSecondary. And finally, you may want drop this own value of object to force it to use parent’s value.
From now (v5.0) Valentina Studio is able:
The following picture shows how you can use power of Valentina Studio Data Editor, to manage records of a Table without SQL.
You can add/delete/update records and values of fields. You can filter records applying filter.
You can even use Related Table Editor (bottom side) that displays records of related table (linked by Foreign Key). It is enough click record of the top table, and bottom table shows you related records.
Even more. You can just by mouse click link/unlink records. In background FK gets value of PK of parent record. But for you this looks as easy as mouse click.
Even more. You can apply set commands to find union/intersection or difference of sets of related records for few parent records. Couple of mouse clicks and you see result of quite complex SQL operation, which even SQL expert will write in few minutes only …