“Why not PostgreSQL, rather than MySQL?”— Depends on what you’re doing. joins

—“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

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *