PgFormatter: A PostgreSQL SQL syntax beautifier
1–10 of 33 posts
Re: PgFormatter: A PostgreSQL SQL syntax beautifier
#2Pasting "SELECT 1,2," then clicking [FORMAT MY CODE] on their online demo[1] seems to break something. It renders the site header, but nothing else.
[1] http://sqlformat.darold.net/
Also, a similar tool was recently discussed: https://news.ycombinator.com/item?id=18087514
Re: PgFormatter: A PostgreSQL SQL syntax beautifier
#3The stark difference between a formatter and a formatter officially blessed by the parent project, is that the former is far more vulnerable to having its output viewed with a jaundiced eye and the formatter being cast away.
I remember trying the one from TFA and NOPE-ing out immediately. Similarly, "sqlfmt" that was on HN recently. If there was an official Postgres formatter, I would probably persevere despite whatever oddities it would inevitably have.
Re: PgFormatter: A PostgreSQL SQL syntax beautifier
#4Do you really need to serve ads on your demo site?
Maybe you do, but that doesn't seem very OSS.
Re: PgFormatter: A PostgreSQL SQL syntax beautifier
#5A 100% Perl project in 2018 is a rare sight.
(Implementing a SQL formatter in pure SQL is not impossible, but would be quite a tour de force. Just a thought.)
Re: PgFormatter: A PostgreSQL SQL syntax beautifier
#6The stark difference between a formatter and a formatter officially blessed by the parent project, is that the former is far more vulnerable to having its output viewed with a jaundiced eye and the formatter being cast away. I remember trying the one from TFA and NOPE-ing out immediately. Similarly, "sqlfmt" that was on HN recently. If there was an official Postgres formatter, I would probably persevere despite whate…
The sqlfmt one pulls in the cockroachdb parser, and that team has a fairly big incentive to be compatible with PG syntax. Nobody is perfect, but it seems set up to stay current/correct.
Re: PgFormatter: A PostgreSQL SQL syntax beautifier
#7The stark difference between a formatter and a formatter officially blessed by the parent project, is that the former is far more vulnerable to having its output viewed with a jaundiced eye and the formatter being cast away. I remember trying the one from TFA and NOPE-ing out immediately. Similarly, "sqlfmt" that was on HN recently. If there was an official Postgres formatter, I would probably persevere despite whate…
The sqlfmt one pulls in the cockroachdb parser, and that team has a fairly big incentive to be compatible with PG syntax. Nobody is perfect, but it seems set up to stay current/correct.
I meant the style choices. But it did also choke on Identity Columns IIRC (https://blog.2ndquadrant.com/postgresql-10-identity-columns/).
Not knocking either project - just pondering adoption.
Re: PgFormatter: A PostgreSQL SQL syntax beautifier
#8Sometimes this (https://zeroturnaround.github.io/sql-formatter/) does a better job for me. Doesn't support Postgres explicitly but works most of the time.
Re: PgFormatter: A PostgreSQL SQL syntax beautifier
#9I like Notepad++'s Poor Man's SQL Formatter plug-in. Works well for anything I do.
Re: PgFormatter: A PostgreSQL SQL syntax beautifier
#10Do we need to use caps for SQL keywords? My understanding is that it served a purpose back in the days of monochrome screens, but modern IDEs colour the keywords so caps are now redundant. Though I don't use caps even without colouring, I find them just a nuisance.