4 ms·

Ever since I read the "Out of the Tar Pit" paper[1], I've been designing my data structures in a more relational form. [1]: https://github.com/papers-we-love/p

• bob1029 4y ago
  This paper was a very big deal for us. I thought “oh this is nice” and then I got to chapter 9... SQL is so much more powerful than most developers are aware. It's not just some annoyance to trod through in order to get to your data. It is an entire data-as-computation paradigm that also happens to be a domain specific language. SQL is functional. It is also relational. Figuring out how to combine both of these properties across your entire domain is peak elegance. We got pretty damn close on our current iteration. The walls of the matrix are a bit messy, but from inside a given SQL expression you can't tell. It all looks very clean from the inside. SQLite represents the most stable and portable foundation upon which to construct one of these systems. Nothing else comes close.