As my code gets more complicated or deeplier nested, I just love that it slowly adds newlines to break up functional hierarchy into visual blocks. It has been a complete game changer for me in terms of how I write fancy JS. However I’ve recently been spoiled in my JavaScript (well, JSX) editing with prettier. It makes sense that they have easy rules like “each term on its own line”. This is fine and I’m happy they exist and have provided value. Those other formatters undoubtedly use a simpler algorithm for their formatting. I believe that using available space is a requirement for that. I wanted something that I could hook up to my text editor on save and it would always produce beautiful results. While I understand why they do that, I was not satisfied with using them to automatically format my SQL. I tested six of the formatters from the first page of results with the query SELECT 1, 2, and all six of them formatted it onto two or three lines. Justification for sqlfmtĪ search for sql formatter uncovers lots of online and offline formatters. sqlfmt is for those who think it is better to have no choice in the SQL formatting than it is to format it by hand. If you do not heartily ascribe to automated, opinionated (i.e., few or no options) choices in your code formatters, sqlfmt is not for you. As we are dealing with code formatting here, there is much opinion, and here I will discuss mine. In addition, I will argue for its need in light of the existing SQL formatters and describe its somewhat interesting implementation.
Sql code formatter how to#
Here I will describe how to use it and its features. I built sqlfmt with my Cockroach Labs colleague Raphael “knz” Poss.
Its purpose is to beautifully format SQL statements. It’s one of the most popular blogs we’ve ever published so we wanted to get it back up on the site for a new crop of blog readers.
*This post was originally published in 2018 by former CockroachDB engineer, Matt Jibson, who owns goats and makes his own soap.
0 kommentar(er)
