I'm learning about databases and the capabilities seem to overlap a lot. How do data structure, queries, and transactions help decide between SQL and NoSQL?
For example, if I'm storing activity events with different fields, would a SQL table with JSON data or a document database make more sense?
_b93+claywicket.6:
So I don't have to rule out SQL just because some event fields vary?