Re:Declarative Schemas for simpler database management
by prmph on Thursday April 03, 2025 @04:53PM
(#43575261)
Oh, I am aware of the problems with this scheme for names. I just used it as a simple example. I wouldn't design my users table this way.
If I can, I even avoid storing actual names of users at all. If I have to, I use a simple free form "display_name" column; what is put there is up to the user.
Side note, but why do folks always bring up this "firstname lastname" example? It is not ever possible to implement that correctly in an automated fashion: some people have spaces in their first names, and some people have spaces in their last names. (I don't mean to single you out, as this exact example comes up multiple times in every declarative vs imperative discussion!)