• 0 Posts
  • 7 Comments
Joined 2 years ago
cake
Cake day: February 26th, 2025

help-circle






  • I get it. SQL is such an obtuse language. There are no shortage of programming interfaces to it because it is so dumb.

    Now, do you hate SQL or RDBMS? Do the concepts of normalization (deduplication of data), primary and foreign keys, etc. bother you? (Not throwing shade, I hate matrix math, we don’t control what we like.) I ask because there are alternatives to not dealing with SQL but maintaining the benefits of a RDBMS - namely data integrity checks, atomic operations, etc. etc.

    Because if you do all the programming necessary to guarantee data integrity, and all that good stuff on top of a key-value DB… well, you’ve just created an RDBMS from first principles.

    It’s your passion project, use what makes you enjoy it. Just try not to fall into the trap of reinventing the wheel. It’s easier to use an RDBMS for it at first and switching to a more specialized tool later when requirements are clearer than the other way around.

    An alternative is finding someone to partner up with and be your DB developer and DBA. Easier said than done, but it’s a great alternative.