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, the database management tool, has two versions.
0 Comments
Leave a Reply. |