Sherliz Holmes

@JhoiraArtificer

she/her
seaslug.garden/

just a selkie in the sea

(I also go by Liz)

avatar by @PotechiPon on twitter

Sherliz Holmes @JhoiraArtificer7/6/2024, 5:12 AM

Sherliz Holmes @JhoiraArtificer

Sherliz Holmes @JhoiraArtificer7/6/2024, 12:32 AM

diving headfirst into the Database Mines

only one of our cocktail books has an index by ingredient. I am building a relational database for (ideally) All of our books. finally I can know what all recipes we have that use coffee or Lillet or honey syrup or whatever

#spreadsheets fan club #except that I know a spreadsheet really isn't the appropriate tool here #but it counts #hot girl behavior

Sherliz Holmes @JhoiraArtificer7/6/2024, 5:12 AM

I Was Wrong and a few others are lightly indexed by ingredient, though it's largely by "largest ingredient", so a coffee drink with rum shows up under coffee and a rum cocktail with some espresso is under rum. I am solving this problem as we speak (albeit slowly).

also now it can be queried for drinks with rum AND coffee not rum OR coffee

#hot girl behavior #spreadsheets fan club #alcohol

You must log in to comment.

in reply to @JhoiraArtificer's post:

eden @eden7/6/2024, 12:42 AM

#spreadsheets fan club

Natalie @nex37/6/2024, 12:46 AM

please tag this "#hot girl behavior"

cassie @porglezomp7/6/2024, 1:09 AM

a spreadsheet is just an interactive database that’s bad at enforcing its schema

effika @effika7/6/2024, 1:58 AM

A good normalized database solves so many problems! I wish more people understood that. Excellent project.

yana @yana7/6/2024, 2:44 AM

i love a spreadsheet...i should learn a database..........i am watching your career with great interest

Beta is on cohost dot org @stillinbeta7/6/2024, 3:47 AM

I will create a recipe collection that is so normalised

in reply to @JhoiraArtificer's post:

Mags!@RatBaby7/6/2024, 5:20 AM

i would like to suggest sort by "largest ingredient (weight)" so if cocktails contain a brick those show up first

Mags!@RatBaby7/6/2024, 5:21 AM

sort cocktails by weight, which ones use tungsten cubes as garnish?

Pat @tekgo7/6/2024, 8:32 PM

So at this point do the database entries have the entire recipe or is there info that’s not included?

Sherliz Holmes @JhoiraArtificer7/6/2024, 9:18 PM

Quantities and instructions beyond group categories like "stirred" "shaken" "blended" aren't included. There's a reference to the book name and page number for full info. Also I have collapsed some information into things like "Bitters", "Rum" (for when there's multiple rums or it asks for something specific), "Custom syrup" (for things other than the standard simple, honey, ginger, etc.), just to cut down on extraneous information.

Pinned Tags