Is it normal to design a database without writing an analysts first but basing it on the design?

Comments

• lysdexic@programming.dev ⁨1⁩ ⁨year⁩ ago

  I think there’s context missing from that story. Diagrams do not trigger disgust. At best, making superfluous and time-wasting demands in the context of trivial tasks that add nothing of value and achieve nothing but wasting time and adding overhead can often lead managers to frown upon them.

  source

  • nitefox@lemmy.world ⁨1⁩ ⁨year⁩ ago

    The DB is already made, but they had to change it cause they didn’t plan a huge portion of its logic beforehand even though they knew about it: this resulted in major changes across the whole schema

    source
• MagicShel@programming.dev ⁨1⁩ ⁨year⁩ ago

  Seems kinda weird to me. It’s completely legit to ask for documentation before making it yourself. Some people are just more visual and need to see diagrams - they certainly help me.

  That being said, I haven’t used formal UML in twenty five of professional development. I mostly use class diagrams and flow diagrams. Could be he was reacting to something that he feels is more academic and less practical.

  source

  • nitefox@lemmy.world ⁨1⁩ ⁨year⁩ ago

    The DB is already made, but they had to change it cause they didn’t plan a huge portion of its logic beforehand even though they knew about it. This resulted in major changes across the whole schema, while we were already working on implementing the various features

    source

    • MagicShel@programming.dev ⁨1⁩ ⁨year⁩ ago

      I see. So it’s an absolute cluster fuck because no one did the correct planning in the first place and everyone is flying by the seat of their pants. I don’t have a lot of information to go on, but this seems like poor leadership. And you know that because they had the requirements but didn’t create the right schema in the first place.

      This (whether by leadership failure or honest mistake) is sometimes a reality in software development. And it sucks because that usually puts a lot of pressure on developers to hit moving targets because the deadlines don’t usually change just because you spent weeks working on bad design.

      source
• monomon@programming.dev ⁨1⁩ ⁨year⁩ ago

  As others said, in-depth design is often skipped, especially if the dev team started very small. Sounds like your intuition is right, though - the lack of design bit them on the ass when they realized they missed a part.

  I have also been laughed at when I suggested a UML diagram in the past. However, it is helpful. For more visually oriented people even more so.

  I’d suggest to go ahead and do it, unless your boss is adamant that it is a waste of time. When they see the result they might be happy.

  source

  • nitefox@lemmy.world ⁨1⁩ ⁨year⁩ ago

    EDIT: writing it out, I swear, makes no sense at all

    Oh I’m not the one who designed the DB, I just implement the endpoints and stuff for this particular project (my role is that of a FE dev).

    I asked cause:

    • they were saying that between me and my coworker, who actively work on the project, and the DB designer, the communication is poor. Which is obviously true since we were handed out the DB with an oral, confused, explanation for a complex DB;
    • they didn’t foresee how interconnected the part 1 and part 2 were. Let me explain how stupid this is: the data from part 1 are mostly read only, which are provided from part2. We knew about this from day one, but it was never added to the visual design… and neither to the DB. So when they actually went to work on part 2 - months later we had the green light to work on the project - they had this sudden realisation: the data are interconnected, we have to rework part 1! (which would have been completely avoidable beforehand)

    source

    • atheken@programming.dev ⁨1⁩ ⁨year⁩ ago

      I understand the predicament you are in, but I don’t know that you’ll get very far with your current approach.

      The actual artifact you need from your collaboration is the list of API endpoints and the structure of what the request and response payload will look like for each one. This doesn’t need to be UML, it can literally be a text doc.

      By asking for something highly structured that the other people may not know how to make, or do not have the tools to make, you’re putting them in a position where they have to acknowledge that they don’t know how to do something, or causing them to do work that they don’t value. Once you’ve had success on a team and developed trust/respect, you can push for adding process/tooling, but if you’re new to a team, you really have to work with what you’ve got.

      Either of you could write a simple doc outlining the API and then collaborate on that (it’s also much easier to actually comment/collaborate on than a diagram, anyway).

      source

      • -> View More Comments
• eluvatar@programming.dev ⁨1⁩ ⁨year⁩ ago

  I’ve found most places aren’t very good at explaining the system design. Just make one yourself from what you understand, that’ll help you figure out how the system works, and your team will usually correct anything you got wrong (assuming it’s small enough to quickly review and notice incorrect assumptions).

  source
• glad_cat@lemmy.sdf.org ⁨1⁩ ⁨year⁩ ago

  Once again, it’s the norm, but it’s very bad. You should have at least some kind of “design specification” to explain what has been chosen. You can use PlantUML or Mermaid, and write this in some kind of spec. It’s not professional to skip the explanation, but most developers/managers do this.

  source

  • monomon@programming.dev ⁨1⁩ ⁨year⁩ ago

    Recently discovered d2 which has a somewhat nicer syntax.

    source
• Kissaki@feddit.de ⁨1⁩ ⁨year⁩ ago

  This is such a broad question. It’s normal and not normal to do so, it’s also normal not to do so.

  If it turns out / becomes evident you need a diagram now now’s the time to create one. You may push quality even without seeing the value in it. In some places or with some people it may be unwanted.

  source
• Haui@discuss.tchncs.de ⁨1⁩ ⁨year⁩ ago

  While I‘m not a „professional“ in the sense of ever working for a classical software company and had to look up uml, I have been CEO before and most bosses are not very intelligent (but kinda smart).

  He might have reacted that way because he either didn’t know what you mean or he wanted you to do the work of designing the database. Just a thought though.

  source

  • nitefox@lemmy.world ⁨1⁩ ⁨year⁩ ago

    The DB is already made, but they had to change it cause they didn’t plan a huge portion of its logic beforehand even though they knew about it: this resulted in major changes across the whole schema

    source

    • Haui@discuss.tchncs.de ⁨1⁩ ⁨year⁩ ago

      I‘m sure you didn‘t mean harm by copy pasting your answer but it doesn’t really match my comment now.

      source
• Von_Broheim@programming.dev ⁨1⁩ ⁨year⁩ ago

  I find that code written towards fulfilling some specific database design is usually a nightmare about 20minutes into the project. You end up with garbage semantics and interfaces because you’re building an entire app for the sake of storing stuff in a database. It’s an ass backwards approach to software development imo, software is about solving a human problem and data persistence is just one of the steps in the solution. Instead figure out what data your consumers need, then figure out what domain objects can be extracted from that, then plan how you will persist those domain objects. You’ll end up with less boilerplate, better naming of entities and services and you’ll also find that the words your team uses to talk to each other make sense to your business people not just your dba.

  source
• atheken@programming.dev ⁨1⁩ ⁨year⁩ ago

  I haven’t made a UML diagram in years. Or an ER diagram, for that matter.

  Getting a schema dump and/or generating a diagram from an existing system would be useful, it won’t be UML, but can convey similar information. At a certain point, keeping an updated UML diagram is extra work that is almost guaranteed to go out of data instantly.

  source