News for hackers. Stuff that matters.
Re:We Can Do Better Than SQL by sanxchit on Thursday May 09, 2019 @08:08PM (#19873802)
Having worked with databases for a while, SQL seems to be useful because it forces you to think about how your data is structured. To me SQL is a thin wrapper around the relational algebra notation. The biggest problem I run into with SQL is that it is hard to tell how performant a complex query is before actually running it.
Re:We Can Do Better Than SQL by danisth on Friday May 10, 2019 @12:08AM (#19874979)
Not a great interface, but estimated query plans can be pretty useful for getting a feel for how heavy a query will be.