labe

#Creating unique keys in SQLite3

##Why create a unique key?

Say you want to ensure that certain values are never duplicated across rows in a given table-- e.g., voters can vote in many polls but they can only vote in one poll once. In the votes table, a unique key would be applied to the combination of voter_id and poll_id.

Or, say you have a sections table that represents sections of university courses. A section has a teacher, a teacher can teach many sections, but obviously a teacher cannot teach multiple sections that are held during the same day/time interval. So, you'll need a unique key on teacher_id, days_held and time_block.

##Create your SQL table

labe

Bacon-wrapped cheese-stuffed figs, veganized

Ingredients

• 1 c. cashews
• 1 clove garlic, diced
• 1 tsp chopped fresh rosemary (it absolutely makes a difference to use fresh)
• eggplant
• 2 Tbsp tamari (or regular soy sauce)
• 1 Tbsp liquid smoke

labe

Greens catalana

Ingredients

• greens of choice: collard/beet/mustard, swiss chard, spinach
• fresh garlic, finely chopped
• raisins
• pine nuts
• 1-2 Tbsp olive oil
• salt & pepper

labe

Batatas bravas

Ingredients

• sweet potatoes, peeled
• parsnips, peeled and chopped
• cauliflower, chopped
• garlic, diced
• vegetable stock
• onion, cut into rings 1/4-1/2'' thick

labe

dairy-free marscapone

Ingredients

• 1/2 cup cashews
• 1/2 teaspoon apple cider vinegar
• 1 Tbsp white sugar

1. Soak cashews overnight; or, if pressed for time, boil cashews on the stovetop or in the microwave until completely soft
2. Drain cashews

labe

Dinner Menu: 2014-08-15

First course

• wine-steamed mussels in escabeche sauce
• pan-seared asparagus in romesco sauce [1]
• pimientos de padron [2]
• 'bacon'-wrapped rosemary-garlic 'cheese'-stuffed figs

Intermezzo

• salad of oranges and basil [3]

labe

Vegan cornbread

1 cup all-purpose flour
1 cup yellow cornmeal
1 tablespoon sugar
2 teaspoons salt
2 teaspoons baking powder
1 cup unsweetened milk
1 tsp apple cider vinegar
6 Tbsp oil

labe

based on: https://www.sweetestmenu.com/perfect-cornmeal-cookies/
makes: 8-9? cookies

WET:
55 grams room-temperature coconut oil
50 grams granulated sugar
28 grams brown sugar
1/2 teaspoon vanilla extract
2 Tbsp aquafaba
1 tsp honey

labe

strawberry cake

1 Tbsp oil
2 Tbsp egg replacement (used banana dregs, see below, flax/chia egg prob would also work)
1/2 c sugar (90g -> could be less, maybe 80g, if using a berry reduction?)
1/4 tsp vanilla extract or paste

1/2 c flour (60 g)
1/2 tsp cinnamon (-> maybe reduce to 1/4 tsp and/or add cardamom... or replace entirely w/ cardamom?)
1/8 tsp salt

labe

Unsweetened plant-based milk
Yield: 4 cups

Equipment:
* Blender
* Fine-mesh strainer, e.g.
  - cheesecloth (a t-shirt will also work in a pinch)
  - yogurt strainer
  - tea strainer (if you want to try making a very small batch, or strain over multiple rounds)
  - paint strainer