Hacker News new | ask | show | jobs
by londons_explore 1454 days ago
It's disappointing that each database can only talk one SQL dialect.

That means every application that accessed the database will have to use the same, and any migration will be a lot of work.
2 comments
Tostino 1451 days ago
One potential way forward is what AWS is trying with their Babblefish project: https://babelfishpg.org/

If this proves successful, there could be other implementations for other vendor dbms dialects.

link
paulryanrogers 1453 days ago
Sad there are so many dialects. Ideally each would converge on standard SQL and the standard would adopt enhancements as they become widespread. Much like vender prefixing in CSS.

Then one wouldn't need bespoke features except temporarily or where they are truly necessary for the business.

link