pgFormatter v3.0 released

pgFormatter 3.0 released
------------------------

A PostgreSQL plpgsql and SQL code syntax beautifier/formatter that
can work as a console program or as a CGI web app.

Febuary 28 2018 - v3.0

This major release fixes some issues reported by users during the
last six months and adds several new features.

* Add colorization of comments.
* Add detection and colorization of user defined function in the SQL
code. Until now only PostgreSQL internal function was highlighted.
* Add new option -B | --comma-break and in CGI the checkbox
"New-line after comma (insert)" to force a newline after each
comma in INSERT statements, columns and values parts.
* Add command line option: -F | --format to be able to change the
output format in CLI mode. At now there is two possible format,
text the default or html. More format can be added in the future.
* Add support to all psql meta commands up to v1O.

There is also some improvement in SQL code formatting.

The move to a new major release is related to the removing of the
html_highlight_code() method used to apply HTML formatting style.

If you are using your own custom scripts based on the pgFormatter
Perl modules this will break backward compatibility and you will
have to remove the call to html_highlight_code() in your script.
Here is the new synopsys for an HTML output:

my $beautifier = pgFormatter::Beautify->new();
$beautifier->query( 'select a,b,c from d where e = f' );
$beautifier->format('html');
$beautifier->beautify();
my $nice_html = $beautifier->content();

Note that if you are using the pg_format script provided in the
pgFormatter release you don't have to care about this change.

For the complete list of changes see:
https://github.com/darold/pgFormatter/blob/master/ChangeLog

Links & Credits
---------------

Thank to the developers who submitted patches and users who reported
bugs and feature requests, especially Gajus Kuizinas, Troy Johnson
and Tobias Bussmann.

pgFormatter is an open project. Any contribution to build a better
tool is welcome. You just have to send your ideas, features requests
or patches using the GitHub tools.

Links:

Website: http://sqlformat.darold.net/
Download: http://sourceforge.net/projects/pgformatter/
Development: https://github.com/darold/pgFormatter
Changelog: https://github.com/darold/pgFormatter/blob/master/ChangeLog

About pgFormatter
-----------------

pgFormatter is a SQL and PlPgsql formatter/beautifier that supports
keywords from SQL-92, SQL-99, SQL-2003, SQL-2008, SQL-2011 and
PostgreSQL specifics keywords. May works with any other databases
too. It shares the same code with pgBadger, so any improvement made
in the parser is reversed to pgBadger. Tool created and maintained
by Gilles Darold.

pgFormatter works on any platform and is available under the
PostgreSQL licence.

--
Gilles Darold
Some GPL tools at http://www.darold.net/
(squidclamav - sendmailanalyzer - ora2pg - modproxyhtml - pgCluu
squidguardmgr - sysusage - squidanalyzer - pgbadger - pgformatter)