Post AVkyM34GHAfh9HvPLU by 3DPrintingDad@fosstodon.org
 (DIR) More posts by 3DPrintingDad@fosstodon.org
 (DIR) Post #AVkyM34GHAfh9HvPLU by 3DPrintingDad@fosstodon.org
       2023-05-17T20:02:48Z
       
       0 likes, 0 repeats
       
       I encountered my first MongoDB database today. It was designed by someone with no real database experience.The DBA inside me is currently banging his head against a wall.
       
 (DIR) Post #AVkyM5GO73YlxTc7Wa by Nobody@social.freetalklive.com
       2023-05-17T20:10:53Z
       
       0 likes, 0 repeats
       
       @3DPrintingDad I use parse-server ... the first thing I did when I inherited the project is to remove MongoDB and replace it with postgres.
       
 (DIR) Post #AVkyh1BIU8jjNZDNnU by 3DPrintingDad@fosstodon.org
       2023-05-17T20:14:41Z
       
       0 likes, 0 repeats
       
       @Nobody I don't have that choice. I just have to redesign the "schema" if I can call it that.
       
 (DIR) Post #AVkypxxJqYKJyvwYYy by Nobody@social.freetalklive.com
       2023-05-17T20:16:18Z
       
       0 likes, 0 repeats
       
       @3DPrintingDad I'm sorry to hear it.The whole concept of trying to make a database out of hunks of JSON is drain bramaged.
       
 (DIR) Post #AVl1PSojIQKJjyypc0 by 3DPrintingDad@fosstodon.org
       2023-05-17T20:45:07Z
       
       0 likes, 0 repeats
       
       @Nobody My biggest gripe is the idea of "Oh, it's Agile. Need to change a data type? Do so. Record structure? Do so."But... then who has to deal with the inconsistencies? It simply kicks the responsibility down the line and creates technical debt, something Agile tries to avoid.calI will say, an inexperienced designer can do nearly as much damage when making a relational database. There's a reason why DBAs exist and an experienced one will know when to de-normalize and when to normalize.
       
 (DIR) Post #AVl1eMHLt6eVo2TDs0 by 3DPrintingDad@fosstodon.org
       2023-05-17T20:46:38Z
       
       0 likes, 0 repeats
       
       @Nobody I think I've officially reached "Old IT Codger" status.ally
       
 (DIR) Post #AVl1eN76mg3KOYgYXg by Nobody@social.freetalklive.com
       2023-05-17T20:47:48Z
       
       0 likes, 0 repeats
       
       @3DPrintingDad I'm right there with you.
       
 (DIR) Post #AVl1wKx1YzuCtsXEUC by Nobody@social.freetalklive.com
       2023-05-17T20:51:04Z
       
       0 likes, 0 repeats
       
       @3DPrintingDad Agreed.  One reason for my decision to move to Postgres was the ability to enforce relational contstraints.  The simplicity of a relational database allows you to do huge things that you can't do in an ad hoc database.  Like suddenly deciding that each database row ought to have a start and end date and making it so with the magic of triggers and views.