How do you guys visualise your databases? I'm attempting to do some more-complex backend stuff now and I feel like I'm struggling to plan out my databases. Do you guys have like, an algorithm in your had for how you go about designing and connecting your tables?

I like to draw them out on a big piece of paper

and think about each relationship, is it one->one or one->many

I think I tend move from identifying entities to dependent entities

I guess that is the best way, I was just looking up for a nice open source diagram helper but maybe pen and paper is the way forward

ah there’s lots of tools, but I haven’t found anything as good as pen and paper,

I make a lot of revisions in the early stages

I like that notepaper with dots

it is indeed cute

I'm going to try and implement a tag-experience system (imagine reddit upvotes, but there being multiple things you could be upvoted for). Trying to plan it all out 🙂

sounds great 🙂 like a nice thing to plan

drawing the database schema is my favourite bit of any project 😄

because it allows you to truly think about what your project is going to do and it feels good getting it all planned out?

yeah - exactly that

@danieleneal could I ask you to check if these tables (and comments) seem sane and readable from an outsiders perspective? I want to open source this one day so I want to make sure that my train of thought can be followed in my comments. Thinking of reordering the file? https://gist.github.com/Ashe/88157ca7561834042c59c9115f287844