4 ms·
One word of caution to those trying to improve on SQL - for the many users of SQL, technology is a secondary aspect of their jobs. Hence any replacement runs in
by dman 6y ago
One word of caution to those trying to improve on SQL - for the many users of SQL, technology is a secondary aspect of their jobs. Hence any replacement runs into the issue that many of its core users do not have the bandwidth to spend significant effort on learning another querying language.
I will cheer everyone who tries to displace SQL, because I do think it needs to be displaced but would also want to caution such people on the magnitude of the task ahead of them.
- bjo590 6y agoI often think that a great way to displace SQL would be to create a language that compiles to SQL similar to how TypeScript compiles to Javascript.
- _nhynes 6y agoYou mean like an ORM?
- chime 6y agoORMs I've worked with usually expect you to write the complex queries/joins yourself using a series of functions e.g. orm.select(table1).join(table2).on(keys).where(cond).group(by).having(cond).order(by). It's just SQL with extra steps. An ORM that understands db schema, indices, and automatically decides where to use outer join or subqueries based on what would be most efficient given the specific schema would be fantastic. Basically an ORM that 95% of the cases comes up with the most efficient way to look up the data.
- scotty79 6y agoAt minimum some ORMs let you reorder things which makes SQL 50% better. Smarter ORMs do what you want. Linq is magical.
- CaptainZapp 6y ago> I will cheer everyone who tries to displace SQL Why? What are better alternatives, really?
- yen223 6y agoThere's a non-trivial number of live running systems out there that interact with RDBMSes entirely through either ORMs or query builders, without a single line of programmer-written SQL. Those systems seem to hold up well.
- SahAssar 6y agoThose don't replace SQL in the same way that typescript does not replace javascript. They are also often specific to a certain framework or language in a way that makes them infeasible to compete with SQL in a general way.