4 ms·
I've noticed the same and will compare it graphics programming. Loads of GUI applications write their UIs in application code. Eventually they have to reach to
by paulddraper 8y ago
I've noticed the same and will compare it graphics programming.
Loads of GUI applications write their UIs in application code. Eventually they have to reach to an actual graphics buffer, or OpenGL or similar lib, but only in the most simplistic, elementary way possible. (Sort of like `SELECT * FROM user WHERE id = 4`.)
That keeps 98% your logic in one place, with one language, one composition paradigm, and one set of tools.
For programs that have demanding graphics needs, however, they will start writing greater and greater amounts of code into shaders, to be run on the GPU. It's more complex to split logic like this, and the capabilities of shader languages aware far beneath those of general purpose programming languages. But when it matters, you'll happily take the improved performance.
It's great to see PostgreSQL doing what it can to close the gap and make this easier.
tl;dr
SQL queries are the graphics shaders of server programs.