Frontend dev trying to fullstack - confused by options
I am almost exclusivley a frontend dev, trying to branch out and build a full stack app with NEXTjs, drizzle and planetscale. I keep finding myself struggling with option paralysis trying to decide if I have complex SQL to minimise work in the app or lots of simple SQL queries that need complex functions to join them all together. I know the answer i likely *"it depends" * but can anyone recommend any good articles or youtube videos on best practice and practical tips when planning and building the interactions between database and app.
My current specific scenario is a family charity letting parents know about support groups. It has a table of
- a one to many join to
- a one to many join to
- a many to many join (via a junction table) to
How would you handle displaying all the groups including all the opening hours, contact details and the attendee types?
- simple SQL query for each table, and manually join in the app?
- complex drizzle query to get all the data into the specific format ( is it even possible - best I end up with several empty parent objects that still need manipulation)
- something else?
My current specific scenario is a family charity letting parents know about support groups. It has a table of
groups- a one to many join to
openingTimesweekdaystartTimeendTime- a one to many join to
contactDetailstypevalue- a many to many join (via a junction table) to
attendeeTypesnamedescriptionHow would you handle displaying all the groups including all the opening hours, contact details and the attendee types?
- simple SQL query for each table, and manually join in the app?
- complex drizzle query to get all the data into the specific format ( is it even possible - best I end up with several empty parent objects that still need manipulation)
- something else?
