pgFormatter v3.0 released
От | Gilles Darold |
---|---|
Тема | pgFormatter v3.0 released |
Дата | |
Msg-id | b5e3917a-a9b0-27e3-1570-59ce2a4914fe@darold.net обсуждение исходный текст |
Список | pgsql-announce |
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)
В списке pgsql-announce по дате отправления: