4 ms·
I agree that SQL and flavors of PL/SQL have a 1980s vibe attached to them (well, they were born in those times!), but even small adjustments can make them feel
by yrashk 3y ago
I agree that SQL and flavors of PL/SQL have a 1980s vibe attached to them (well, they were born in those times!), but even small adjustments can make them feel better: for example, dropping the TYPING IN CAPS tradition.
Queries like `select this from that`, in my opinion, feel different than `SELECT this FROM that`, and we can often use color to distinguish keywords from names.
---
More importantly, performance seems much better if you don't have to have a middleman between your data and the user. I wrote a bit about this earlier this year https://yrashk.com/blog/2023/02/16/what-happens-if-you-put-http-server-inside-postgres/ https://yrashk.com/blog/2023/02/16/what-happens-if-you-put-h...
I am also very excited about what you can do with row and column-level security in databases like Postgres.