Choose your database:
AnySQL
MySQL
MS SQL Server
Oracle
PostgreSQL
SQLite
Firebird
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Anley Lafleur: "I cannot wait to start using your exciting product and I am sure it will help me achieve my objectives".
Peter Robinson: "

As a tech savvy company director, I wanted an inexpensive web based database application to manage all aspects of my business. As with most humans I find developing purely by CLI very hard and do not have the will or time to invest in improving my skills. I was looking to find a nice human friendly GUI to design and build my application, which is when I came across PHP Generator for MySQL.

Whilst you still need a great understanding of logic and a small amount of programming ability to get the specific results you require, I am very happy with the speed of progress I have been making with this invaluable tool.

With all the standard libraries included, this product makes normal requirements such as JavaScript form validation, lookup selectors, on click events, auto complete, detailed searches, multiformat exports, rss feeds and username security straight forward and quick.

Having any changes made via the GUI written to the web server at the click of a button makes testing out ideas quick and easy without fear of breaking your application.

To conclude, I couldn't find any other product on the market that came close to offering the amount of options this does, and I do hope that more products like this come out in the future, with the hope of eventually eradicating the need to program all together".

More

Add your opinion

SQL Maestro Group / News / All company news / Code Factory product family updated to version 10.2

Code Factory product family updated to version 10.2

Feb 8, 2010

Prev Next

SQL Maestro Group is happy to announce the release of Code Factory 10.2, a premier GUI tool for managing SQL queries and scripts. There are versions for MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite, Firebird, DB2, SQL Anywhere and MaxDB.

Please consider the list of new features implemented in this version since the last official release:

DBMS-related features:

  • Starting with this version it is possible to connect to a remote server via SSH tunnel using a key-based authentication (in addition to the password-based authentication supported in the previous versions). To establish a remote connection in this way, you have to provide a private key (either in ssh.com or OpenSSH formats) and (optionally) a passphrase.

    This version also introduces support for both SSH-1 and SSH-2 protocols (whereas all the previous versions supported only SSH-1).

  • SSH tunnelingPicture 1. Connect to a remote server: SSH tunnel

Interface improvements:

  • Visual Query Builder has been dramatically improved. Now it can produce INSERT, UPDATE and DELETE statements as well as the SELECT statements containing subqueries and/or UNIONs.
  • Data Export wizard has been significantly improved:

    • Support for Microsoft Office Excel 2007, Microsoft Office Word 2007, OpenDocument Spreadsheed, and OpenDocument Text file formats has been implemented.
    • Now you can select the result file encoding (ANSI, UTF8, UTF16, UTF32, OEM, and Mac).
    • The wizard also has been completely rewritten to improve the look and feel and increase the usability.
  • Data Import wizard has been updated too:

    • Now you can import data from Microsoft Office Excel 2007 and Microsoft Office Access 2007 file formats along with Microsoft Office Excel 97-2003, Microsoft Office Access, CSV, DBF, and Text files supported in the previous versions.
    • Starting with this version you can import Text and CSV data files stored in different encodings.
    • Now it is possible to empty target tables as well as execute custom SQL scripts before and after the import.
    • An ability of using bulk-loading commands has been implemented (for MySQL, PostgreSQL, and Oracle). This feature can speed up the import process up to 10 times so it is recommended to use it always if possible.
    • The wizard has been completely redesigned to improve the look and feel and increase the usability.
  • Get SQL Dump: abilities to generate multi-row INSERT statements and specify output file encoding have been implemented.
  • BLOB Viewer: Unicode support has been added to the Non-BLOB data grid.

    Unicode supportPicture 2. BLOB Viewer: Unicode support

  • Database profile management improvements:
    • Starting with this version it is possible to reorder servers in the Explorer Tree as well as reorder databases from the same server. You can also sort servers and databases in an alphabetical order.
    • Now all the database profiles related to the same server may be deleted at once.
  • Data Grid features the following things:
    • Starting with this version it is possible to allow displaying row numbers in grids. Of course you can adjust the corresponding column to yours liking.

      Row numberingPicture 3. Data Grid: row numbering

    • Multi-column sorting has been implemented. To sort data on multiple columns, use the Advanced sort command from the grid's header popup menu.

      Multi-column sortingPicture 4. Data Grid: multiple column sorting

    • Now you can fix grid columns to view them permanently when working with other grid data. To fix a column, choose the corresponding item from the grid's header popup menu.

      Fixed columnsPicture 5. Data Grid: fixed columns

    • Starting with this version the number of grouped records is displayed for the group's header.

      Number of grouped recordsPicture 6. Data Grid: number of grouped records

  • An Italian localization is now included into the installation package.
  • SQL Editor: the Go to Line command has been added to the popup menu (Ctrl+G shortcut). Also field data types are now displayed in the Code completion window.

    Code completionPicture 7. SQL Editor: code completion

  • BLOB Viewer/Editor: starting with this version it's possible to customize PHP syntax highlighting for the text representation of BLOBs.

In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made. For more information about a specific tool see the appropriate page:

     
Prev Next