How I Reduced My DB Server Load by 80%

Re:How I Reduced My DB Server Load by 80% by roselan on Monday October 09, 2017 @02:11PM (#15436120)

Intellij tools are capable to parse, lint, and autocomplete sql in strings.

To my own surprise, it has become my favorite way to handle queries with multiple/variable joins.

[ Parent | on HN ]

Re:How I Reduced My DB Server Load by 80% by dotancohen on Monday October 09, 2017 @02:33PM (#15436290)

Also, in languages that support HEREDOCS, if you call the HEREDOC "SQL" then VIM and the Intellij editors will syntax-highlight the SQL.

[ Parent | on HN ]

Re:How I Reduced My DB Server Load by 80% by roselan on Tuesday October 10, 2017 @01:38PM (#15443731)

It's not only that: It connects to your database an you have autocompletion for tables, columns and any schema objects, as well as linting. All that inside any string.

By example:

$sql = "select myColFromTableB from tableA";

Inspection will give you have a "unknown column" warning.

(ps: sorry for late reply)

[ Parent | on HN ]

Re:How I Reduced My DB Server Load by 80% by dotancohen on Wednesday October 11, 2017 @04:44AM (#15448219)

Thank you, I did not know that! It is not working for me, but I'll poke and peek around for a setting.

[ Parent | on HN ]