Cocktail Recipe Builder

Sep 25, 2023

Sketch

remember that relational databases use a new table for each many-to-many relationship
- so, a cocktail has many ingredients, and an ingredient can be in many cocktails
- this means we need a new table to store the relationship between cocktails and ingredients
- this table will have a cocktail_id and an ingredient_id column
- this is called a "join table" or "junction table"
- the cocktail_id and ingredient_id columns are both foreign keys that reference the id column of the cocktails and ingredients tables, respectively
when working with supabase/postgres and nextjs, what is a decently ergonomical why to handle CRUD of these tables?
- supabase sdk VS prismajs VS typeorm
supabase features
- database - think tables/data
- auth - think users
- storage - think images, videos, etc

name: daiquiri
description: rum, lime, sugar
ingredients:
- rum
- lime
- simple syrup
instructions:
- combine ingredients in a shaker
- shake with ice
- strain into a coupe
- garnish with a lime wheel
method: shaken
glassware: coupe
ice: none
garnish: lime wheel

name: simple syrup
description: 1:1 sugar to water
ingredients:
- sugar
- water
instructions:
- combine sugar and water in a jar
- shake until sugar is dissolved
- store in the fridge for up to 1 month
abv: 0%
acidity: 0%
brix: 50%
categories:
- sweetener

5th ranked iOS app in "Food & Drink" category is "Beachbum Berry's Total Tiki" for $12.99
7th is "Cocktail Party: Drink Recipes" for $3.99
8th is "Santa Fe Margarita Trail" for $2.99
12th is "Imbiblia" for $2.99
18th is "Lush Cocktails" for $1.99