SQL Maestro Group Company has reported about the release of a new version of its graphical environment for managing the SQL-queries and scripts called Code Factory 8.7.
Developers and database administrators are offered MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite, Firebird, DB2 and MaxDB versions for DBMS.
Tools of Code Factory family contain full support for work with data in Unicode/UTF-8 format. Also there is an opportunity of connecting to MySQL, PostgreSQL and SQLite databases through HTTP-tunnels.
The version of Code Factory for Oracle supports now all DBMS server versions from 8i and 11g. The new Quick Connect mode evades a phase of metadata update when connecting to databases.
For correct registration of the code in SQL language, they implemented the support for all expressions with SELECT, INSERT, UPDATE and DELETE statements in SQL Formatter utility. Now, using keyboard command Ctrl+Alt+D the developer can format a code quickly.
New SQL Generator utility helps to create different SQL scripts with CREATE, DROP, SELECT, INSERT, etc statements. The obtained scripts can be saved in a file, copied to the clipboard and opened in SQL Editor.
In data tables receiving by way of Code Factory queries, now we can see large data files – up to several million records. Also it is possible now to encrypt single data cells through MD5 algorithm.
