![]() * Query Editor - enables the ability to copy the generated query. * Object Colors - enables marking objects with specific colors. * Keyboard Shortcuts - enables the ability to redefine the shortcuts and create own shortcut sets. * Error Lookup - search for error description by its code. ![]() * Dump Wizard - enables filter for tables to select them for a dump. generation of SQL scripts for new/changed database objects. * Diagram Editor - enables forward engineering - i.e. * Data Transfer - copy data between different databases * Data Editor Multiple Update - update few records at once. * Data Editor Layouts - save columns and their order as a named layout ![]() * Data Editor - enables go to parent record function. Forms can use all supported databases as the datasource. * Form Editor - visual editor of Valentina Forms that can be saved into Valentina Project file (.vsp). Reports can use as datasource MS SQL, MySQL, PostgreSQL, SQLite, Valentina DB, ODBC. * Report Editor - visual editor of Valentina Reports that can be saved into Valentina Project file (.vsp). Get Valentina Studio Pro as an in-app purchase (pay only once) to get additional advanced pro-features such as: *** See also: Valentina Studio Pro ($199 only) *** Valentina Studio uses iCloud to share bookmarks between your devices! You also get different DB-related utilities, including Import/Export, Dumps, Diagnose, Clone and Reindex. Open as many editors as you like at the same time for different databases/servers opened in tab-panels. * Server Admin - where you can manage users, learn logs and other parameters of servers. * Query Editor - build SQL queries visually using just a few mouse clicks * SQL Editor - with color syntax, auto-completion, recent and saved favorite queries, templates, console with error/warning reporting. * Related Data Editor - easily learn and manage linked records of two tables, link/unlink records by a mouse click, do set operations over linked records. * Data Editor - easily browse table records in the grid, modify records, an inline edit of values, sort, filter records and save favorite filters, preview images, hex editors for binary values. * Diagram Editor - design new diagrams or do reverse engineering, e.i explore existing databases visually. * Schema Editor (tree view and column view) - create and modify all schema objects of supported databases: Tables, Views, Fields, Enums, Links, Constraints, Triggers, Indexes, Stored Procedures. Valentina Studio brings you powerful, visual editors for your data including: = SQLite, MS SQL Server, MariaDB, MongoDB, mySQL, PostgreSQL and Valentina databases = With Valentina Server this is not a problem since it can handle a client connection in any encoding.Īny Date Format - each connected client can specify own date time format for work.Īny Language of Errors - each connected client may specify own language for errors returned by Valentina Server.= 100% Free - The Best Database Management GUI for = Īny Encoding of Connection - while not each language/IDE supports UTF16 directly, you will have UTF8 or ANSI strings. Secure Connections (SSL) - to enable SSL, just specify in the ini file the SSL port and provide the two keys that Valentina Server will use. ![]() This feature makes VServer more responsive and reduces network traffic. 5, then the 6th connection will not be refused immediately by vserver, but will wait some time (configured) in the pool of connections. Pool Of Connections - if you have Valentina Server with limited connection number, e.g. You can use:ĭisconnect on Client Idle - Valentina Server can disconnect a client with an idle longer than the timeout specified in the ini-file. This allows you to keep business logic on the server and reduce network traffic. Stored Procedures - Valentina Server supports stored procedures according to SQL standard with powerful extensions. This allows you to develop business logic on the server side and reduce network traffic. Hot backup - you can scheduler backups of database(es) using event Scheduler of Valentina Server. An event can be any Valentina SQL command, e.g. In contrast with “thread per connect” model it provides a better performance when a lots of connections present.Įvent Scheduler - you can create EVENTS scheduled to be executed once or periodically. Multi-threaded Design - Valentina Server incorporates the most advanced and effective threading model based on the “pool of threads”. Speed - while each database vendor mentions how fast its product is, Valentina Server provides a really ground-breaking performance, beating most of mature and popular databases servers (MSSQL, Oracle, Access, mySQL, Postgre, FileMaker, 4D, …) in at least a 3-5 times and usually up to 10-100+ times depending on a query, db structure and data. 32/64 bit Versions - 64 bit versions (starting with 4.5 release) allow to manage RAM bigger of 2 GB.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |