New In Postgres 12: Generated Columns

Re:New In Postgres 12: Generated Columns by zo1 on Wednesday October 02, 2019 @07:59AM (#21135455)

I find that it helps differentiate the different components of the query. Same way we use all-caps for constants, etc. If it's lower-case, or camel-case, then it just sort of "melts" into the rest of the query.

[ Parent | on HN ]

Re:New In Postgres 12: Generated Columns by icebraining on Wednesday October 02, 2019 @11:17AM (#21137359)

Also nice for differentiating it from the rest of non-SQL code.

[ Parent | on HN ]

Re:New In Postgres 12: Generated Columns by pletnes on Wednesday October 02, 2019 @09:17AM (#21136044)

Not with syntax highlighting.

[ Parent | on HN ]

Re:New In Postgres 12: Generated Columns by preommr on Wednesday October 02, 2019 @11:45AM (#21137712)

The tooling around sql is pretty awful. I was looking for a vscode plugin to get some syntax highlighting and linting for postgres yesterday, and just gave up. There are plenty of administrative tools that help with connecting to dbs and showing the results in a nice table, but nothing that really helps with writing it (or at least nothing of high quality that I could find).

[ Parent | on HN ]

Re:New In Postgres 12: Generated Columns by dewey on Wednesday October 02, 2019 @11:59AM (#21137872)

https://www.jetbrains.com/datagrip/ and Postico are pretty great for PG I think. I'm using them every day and having the option to attach DataGrip to a directory of queries in your code and directly executing them from there with set variables is pretty sweet.

It's helping you write queries by auto formatting and good auto completion.

[ Parent | on HN ]