PostgreSQL Code Factory online Help

Return to chapter overview

What's new

07/10/2008 - PostgreSQL Code Factory 8.7 released

DBMS-related features:

•	Support of Unicode/UTF-8 data has been implemented.

•	A possibility of connecting to remote PostgreSQL databases via HTTP tunneling has been added. The technology works as follows:

o	Upload the connection PHP script to your website. The script is named pgsql_tunnel.php and can be found under the installation folder.

o	Test the script in your web-browser (optionally).

o	Enter the script URL in the Create Profiles wizard or Edit Database Profile dialog. Of course you should turn ON the "I have to use HTTP tunneling" option.

•	The Quick Connect mode has been implemented. Use it to skip metadata refreshing when connecting to a database.

Interface improvements:

•	The SQL Formatter for DML statements (SELECT, INSERT, UPDATE and DELETE) is implemented. It can be invoked by means of the Format SQL link on the SQL Editor's navigation bar (Ctrl+Alt+D shortcut).

•	The SQL Generator tool has been implemented. Use this feature to produce various SQL scripts (CREATE, DROP, SELECT, INSERT, etc) for the selected object. The result script can be saved to a file, copied to clipboard, and opened in SQL Editor or SQL Script Editor.

•	Some new features have been incorporated into SQL Editor and SQL Script Editor. Now it is possible:

comment/uncomment selected text (Shift+Ctrl+. / Shift+Ctrl+, shortcuts respectively). If no text is selected, the whole line will be commented. By the way, it is not necessary to select commented text to uncomment it, just press Shift+Ctrl+, having the cursor inside the commented text. Both kinds of comments (single-line and multi-line) are supported;

o	convert selected text to different cases (lower, UPPER, and NameCase);

o	export the contents of the editor to RTF and HTML formats (to file or to clipboard);

o	create a new query, close existing one, save the query to profile, etc. using a popup menu that has been added to each query tab;

o	print/preview the contents of the editor;

o	use the script runner to execute large scripts without opening them in the editor window.

•	Data Grid has been significantly updated:

o	Starting with this version it is possible to use the lookup editor for a column, which is linked by a foreign key with a (single) column from another table. The editor displays the contents of parent table�s columns within the dropdown window.

Now the grid automatically switches to the Simple mode for queries that return more than 5000 records (the number can be customized in the Options dialog). This mode allows you to get thousands and millions of records displayed in a few seconds, but does not feature filtering, grouping and sorting abilities.

o	Now it is possible to encrypt the contents of the selected cell by the md5 algorithm (the corresponding item has been added to grid's popup menu).

•	A lot of other minor improvements and corrections have been made.

05/07/2007 - First public release of PostgreSQL Code Factory

PostgreSQL Code Factory is a premier PostgreSQL GUI tool aimed at the SQL queries and scripts development. The software equips users with all the productivity tools they need to speed up the query building and data management processes. PostgreSQL Code Factory is a good choice for everyone who need build SQL statements and edit SQL scripts with a convenient easy-to-use interface.

Key features of PostgreSQL Code Factory are as follows:

•	Visual Query Builder;

•	Handy SQL Editor with code folding and syntax highlighting;

•	Simultaneous executing of several queries with multi-threading;

•	Data management: viewing, editing, grouping, sorting and filtering abilities;

•	Data export to as many as 14 file formats including Excel, RTF and HTML;

•	Data import from Excel, CSV, text files and more ;

•	Powerful BLOB Viewer/Editor.

The applications also provide you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, customize user interface according to your needs and much more.

Return to chapter overview