4 votes

Designing APIs that don't expose database primary keys

The fundamental problem with exposing the simple, surrogate keys which tend to be the database's Primary Keys is that it leaks your implementation outside of your database. If you have an API that [...
user avatar
  • 11.6k
2 votes

Mixing static referred and dynamic data in database

Putting limits on values for database identifiers can be problematic. Today, you think "surely 1000 static items will always be enough." But what happens when it isn't enough? Values 1-1000 ...
user avatar
1 vote

Form builder app database design adding versioning

There are a variety of options with associated trade offs: Create a new explicit version of the form for each change - and snapshot each element of the form for each change. Lots of records, but ...
user avatar
  • 338

Only top scored, non community-wiki answers of a minimum length are eligible