The decision to upgrade to Pro or not can be made after some time of evaluation. Beginners will find the Free version good enough and can enjoy it at zero cost. They’re usable, but need work – especially to justify the $200 bill. I give Valentina Studio (Free and Pro) a score of 3.5 out of 5. But the functionality difference between Valentina Studio Free and Pro is too big and somehow not really justified. This inconsistency can confuse and annoy the end user.įinally, it is understandable to have features disabled in a free version. For example, when doing some tasks (say specifying the field type), we need to double click an arrow to bring up a pop up dialog while doing some other tasks (say changing the table’s DB engine, or its charset), we only need to single click. The definition of PK/FK is also less intuitive than in alternative apps. Likewise, when creating a table, it takes a longer process to define all the basics: fields, index, PK, etc with the UI. Also, unlike PHPMyAdmin, after an operation (like inserting a field), it won’t provide an SQL statement for that operation. For example, it lacks filters and navigation whether you are in a grid view and/or SQL output view. Generally speaking, Valentina Studio provides rich, but still in-much-need-of-improvement features. It has code insight and code completion features, which is quite handy. It also provides an SQL dialog, where we can input SQL statements. We can double click a table in tree view or column view to bring up another view to see the master-child relationship. In the grid, we can right click on a record to export that record into CSV or SQL. When a table is selected, it displays the table data in a grid view when a field is selected, only the column data is displayed. We can also create and modify an entity accordingly.Īnother view, less used in my case, is the tree view: And the final level of details will be displayed in the right most pane. Selecting a database in column one, we can choose to display tables, links, views in column two and for tables, view its fields, indexes, etc in column three. In this view, different levels of entities (database, table, fields, links, indexes, etc) are displayed in columns in a cascading style. This is my favorite view in Valentina Studio. We will cover this later.Īfter selecting a server, the databases in that server will be displayed in the following cascading column view: The report project manages the source, query and design of a report. But it must have Valentina Report Server support (bundled with Valentina Server) to be called from an application. A “report” generated by Valentina can reside locally and remotely. Projects: This is mainly used in report generation.Currently it supports Valentina DB and SQLite. Database: Supports files based database management.A red dot before the connection (or “Bookmark” in Valentina’s term) means the server is currently down. In my case, we can see there are two remote MySQL connections and one local connection. It supports both local server and remote server connections. It supports four types of “servers”: MySQL, PostgreSQL, Valentina and ODBC. Servers: Provides CS based database management.The startup speed of Valentina Studio is fast, faster than another tool that I am using. Thanks to Valentina for providing me with a key for my installation and evaluation. In this article, I will use Valentina Studio Pro. Both versions support Windows, Mac and Linux platforms, making it a cross-platform tool. Another is the Pro version, with more features, priced at $200 per unit. Valentina Studio Pro 12.4.Valentina Studio, the database management tool, has two versions.
0 Comments
Leave a Reply. |