Using UUIDs Vs Sequences In PostgreSQL: Developer Perspective
UUIDs vs Sequences: Listen to Developers & Choose Wisely. PostgreSQL provides both, but decision depends on app design, usage & performance considerations. UUIDs offer flexibility, sequences guarantee uniqueness.
This month's PGSQL Phriday #015 discusses using UUID in PostgreSQL. I have previously written on this topic (UUID or cached sequences?) , and I won't tell you which one to use, as I believe that the decision should be based on your business requirements, application design, and access patterns. However, the PGSQL Phriday #015 introduces the topic as a fight between the database community and developers, which I think is the wrong approach and may lead to bad SQL application design. A database community should prioritize its users, who are primarily developers, instead of opposing them. As some...