—“Why not PostgreSQL, rather than MySQL?”—
Depends on what you’re doing. joins vs scale. I designed (and continue to) systems that scale.
So the question is why not unstructured data (search), why not structured data (joins), or why not federated data (without joins). Imagine a triangle with each of those points on it, and make your choice.
My opinion is that oracle as usual will continue to malinvest in MySQL until Ingres (which is how I knew it), or Postgressql overtakes it.
However. I don’t think we get around financial scale = hierarchical, world modeling scale = relational, complex query = object-relational, and text search = object (document).
Source date (UTC): 2020-09-17 09:50:00 UTC
Leave a Reply