pgFormatter
A PostgreSQL SQL syntax beautifier that can work as a console program or as a CGI. On-line demo site at http://sqlformat.darold.net/ (by darold)
sqlf
By tym27
Our great sponsors
pgFormatter | sqlf | |
---|---|---|
4 | 1 | |
1,601 | - | |
- | - | |
5.5 | - | |
about 1 month ago | - | |
PLpgSQL | ||
PostgreSQL License | - |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pgFormatter
Posts with mentions or reviews of pgFormatter.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-05-21.
- Command line SQL formatter or beautifier
- Ask HN: Preferred SQL Auto-Formatter?
-
How did you guys replace ALE?
I needed a formatter for SQL, didn’t like the available one and it took 10 lines of Lua to write a custom one for this.
-
What do you use to format SQL in PostgreSQL dialect?
I have found this https://github.com/darold/pgFormatter, but I am not sure if there is something else that I haven't discovered yet.
sqlf
Posts with mentions or reviews of sqlf.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-07-07.
-
What do you use to format SQL in PostgreSQL dialect?
I’m sort of persnickety about using right-aligned keywords and commas first in select and group by lists, etc. I also consider all-caps keywords to be a relic of the times before automated syntax highlighting in editors, and prefer all lowercase most of the time. Not finding anything that satisfied all my preferences (sorta understandable, really) I rolled my own little script using the Python sqlparse library: https://gitlab.com/tym27/sqlf
What are some alternatives?
When comparing pgFormatter and sqlf you can also consider the following projects:
sqlfmt - SQL formatter with width-aware output
sqlfmt - SQL Formatter
nvim-ale-diagnostic - Display Neovim LSP diagnostics in ALE.
sqlfluff - A modular SQL linter and auto-formatter with support for multiple dialects and templated code.
.dotfiles