Comment by reactordev

Comment by reactordev 2 days ago

10 replies

Pretty.

The question I have is this, and don’t attack me for asking, but do people still produce database diagrams for use at work? I thought we had abstracted this by using Domain Driven design, ORMs, APIs, and the like.

Do individual teams still document their tables or do they document their entities? Do you still hand roll sql in a dao or do you use some higher abstractions?

Curious minds want to know because it’s been over a decade since I’ve done any database design documentation and have only done lean relationships and domain modeling documentation. Swaggering the rest.

I will say this, I love the look of this and I would love to just draw abstract shapes and things like I do on Miro. AWS architectures, etc etc.

andersonklando 2 days ago

We do at my team. I do not work on the Backend side, but I help in designing the DB schema.

Whenever I am thinking of new features to be developed, or when engineers are suggesting some features/approaches, looking at the ERD helps a ton. Onboarding is also easier.

We were using Lucidchart[1] until we reached the limit[2], so we found dbdiagram.io (which is just not the same).

[1] So far, it was the best of the market in terms of "canvas freedom" [2] We are struggling with salaries, so we are saving everywhere

  • reactordev 2 days ago

    how many tables? is it manageable and interesting like trying to squeeze 2b records into postgres or what?

    Also lucidchart is just draw.io fyi - you don't need a license unless you need the file sharing aspect and I feel like it belongs closer to the code.

    I'm just generally curious what others' process is for this as the only meetings I've had in the last 5 years were who was getting cut.

    • andersonklando 2 days ago

      If I recall, Lucidchart allows up to 15 "shapes.

      > Also, Lucidchart is just draw.io fyi - you don't need a license unless you need the file sharing aspect, and I feel like it belongs closer to the code.

      No, it is not. I took the whole day to check what is available in the market, and concluded that Lucidchart UX is quite balanced.

      • reactordev 2 days ago

        well, they used to be - I just went and saw they sprinkled llms into it so yeah, now it's different. Diagrams.net aka Draw.io was what they were using...

    • [removed] 2 days ago
      [deleted]
matt-p 2 days ago

Yes, very much so but I think it's probably a self fulfilling thing?

If I care about the data model so much that I want to diagram it then it's going to be the exact DB schema.

mrits 2 days ago

The databases often out live the abstraction.

datadrivenangel 2 days ago

People have stopped documenting their databases, which is a loss for the industry.

  • reactordev 2 days ago

    We just assume 6th order and swing for the fences? Why do you think that is? Because we have too much data? I remember a guy who was in charge of schema but that was as close as we got to documenting the actual database.

tonyhart7 2 days ago

only for learning

for industry???? let me create an ERD for my 10th SaaS tools that need generic auth and payment, nope