Keep your database organized using ER diagrams

Подписаться 224 тыс.

Просмотров 152 тыс.

50% 1

If you want a great tool for creating diagrams, be sure to checkout eraser.io/cody . Using eraser you can easily create diagrams via code and save those to a git repository for your entire team to collaborate on.
-----
📘 T3 Stack Tutorial: 1017897100294.gumroad.com/l/j...
🤖 SaaS I'm Building: www.icongeneratorai.com/
💬 Discord: / discord
🔔 Newsletter: newsletter.webdevcody.com/
📁 GitHub: github.com/webdevcody
📺 Twitch: / webdevcody
🤖 Website: webdevcody.com
🐦 Twitter: / webdevcody

Опубликовано:

30 апр 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 50

@pekorabestgirl543 Год назад

oh hell yeah, I have always been someone who prefer using line code as note instead of drawing. I registered for the website using your link. huge thanks

@mr.unknown6179 7 месяцев назад

This diagrams are generally better than the traditional ER diagram

@fcktom 10 месяцев назад

Was just about to start doing this in excalidraw for my astro site - perfect timing 👍

@CarloNyte 3 месяца назад

this is amazing! I never knew something like this existed or that it even had a name

@ericaleverson9430 29 дней назад

I signed up for eraser, thank you!

@renata-qx3xw 2 месяца назад

Thank you for sharing. It's super handy to have a diagram. I used to draw them up myself when I started with SQL, and it drove me crazy. I'm using SSMS 2019 at the moment, and being able to create a diagram made me understand better how the tables work together.

@kaustubhdeo3143 25 дней назад

Can we create an ER diagram for any database in SSMS? I mean, if we get access to a new database which is managed by a client, can we create ER diagram for this db?

@JiNx-yf1ef Год назад

Thank you so much that's what i was looking for

@fernandoz6329 Год назад

1- Automatic generation is ok, however I could manual organize the tables. Is there a way to control it? 2-Generate databases diagrams is ok, is there a way to port to a database or you have to manually do it? 3-Is there a reverse engineering way to convert a database to diagram? So far, cute however bit useless.

@colbr6733 Год назад

Good questions 👍

@riordan381 6 часов назад

😮 Me with a big white board and a range of color markers

@ivandrofly Год назад

I've just discover this app and it's amazing

@bashscript2805 Год назад

You need to develop your application using domain object first approach, not database first approach

@DreamsAPI Год назад

Cool, what is that? Ill also google that, have any sites that will help?

@bashscript2805 Год назад

@@DreamsAPI There is a cool book "Unit testing principles, pratice and patters". Actually the book is not particularly about unit testing, it's also about ddd. Give it a shot

@colbr6733 Год назад

In reality implementation depends on your own background and experience of the architecture. A DB admin approach might be to start at the Db, as they are directly relating to their own expertise.

@reiito8727 Год назад

@@bashscript2805 is your book by Vladimir Khorikov ?

@bashscript2805 Год назад

@@reiito8727 yep

@AllenAndersonTaylor 6 месяцев назад

Wish I knew this for college 😢😢😢

@ngamsomset Год назад

look much better than old-school UML.

@kerimgueney Год назад

For new or smaller projects these diagrams are about as useful as UML, namely not useful at all. Things change so quickly that the diagram becomes inaccurate real fast.

@WebDevCody Год назад

Not if you update them 🧠. Eraser also integrates with GitHub so you can easily just have a button to click and update diagrams directly from your repo

@kerimgueney Год назад

@@WebDevCody only if it happens automatically. People already struggle updating their comments, continuously updating some graphical diagram is either going to be neglected or balloon the cost of the project. The ROI is marginal.

@supersteez5316 Год назад

I agree. Code works great as documentation. Until it doesn't. Once an application scales up in terms of complexity, or even collaborators, it becomes more and more difficult to design around. Diagrams like these serve as the starting point for making changes. Iterations slow down, but onboarding and communicating with other collaborators improve.

@ShaanCoding Год назад

@@supersteez5316 good alternative if your using prisma is to use prisma generate to generate a ERD diagram. By embedding this in your readme or documentation you can have a live up to date version of the diagram.

@aarifansari9097 3 месяца назад

thanks a lot

@SeibertSwirl Год назад

Good job babe!!

@WebDevCody Год назад

Thanks beautiful 😘

@pim8268 Год назад

Awesome thanks

@farangonwheels Год назад

I've been looking for something like this to visualize an openapi schema, might have to just use this for now

@J3R3MI6 2 месяца назад

Ai on eraser does this instantly now

@gdtutorial Год назад

Shading?

@gabef9538 Год назад

I want my computer to do this for all programs and just flag any program that connects to the internet. I want it to see how long and when programs use internet.

@Lanier-pk2yo 6 месяцев назад

What’s the name of the coding language you’re using in this video? I love the diagrams as a way to get organized but I’m just getting started and trying to figure out where I should go next

@zenoxolo 5 месяцев назад

Looks like a subset of DBML (DataBase Markup Language).

@ashutoshpatel5030 Год назад

#includespaidpromotion ✔️

@RajveerSingh-vf7pr 10 месяцев назад

mermaid is good to...

@bnssoftware3292 2 месяца назад

Can you output postgres DDL from this?

@BarisPalabiyik Год назад

Prisma have an er diagram generator too.

@chrishabgood8900 Год назад

Ya can you give it an sql schema from the db and it generate it for you?

@WebDevCody Год назад

I do believe they are working on a feature or prototype to take in a prisma file and generate a ER diagram, but I’m not certain.

@nikolatodorovic7198 Год назад

There are already tools like these integrated into jetbrains product such as datagrip, not sure if its available for community edition though. MySQL workbench from microsoft also is a free option though it doesnt work with every rdbms and supports only mysql

@KodornaRocks Год назад

why would one need such a thing? Just ask chatgpt to do that for you, it can even warn you about missing columns, wrong types, suggestions of improovements ...