Day 4: Part 1, part 2, part 3. 2185 words.

Day 5: zilch

Day 6: 740 words.

Time to go home and work on day 7 soon.

Polis is down for a somewhat extended count, as it’s doing an intensive check on a huge disk.

It’s going to take about ten hours.

Breakfast was scrambled eggs on toast. Nothing fancy there, though the cumin I put in the eggs was fresh ground.

Lunch was spinach, chickpeas, feta, mozzarella and onions.

Dinner was fragrant lentils and rice, fragranced with pepper, coriander, cumin and cardamon. Topped with browned onions and yoghurt.

Yes, I am nuts. But then, if I can avoid a tax audit, maybe I can do NaNo! So, based on previous storyline, here goes:

Day 1: 1063 words.

Day 2: Zilch. Work sucks sometimes.

Day 3: 2286.

So I’ve got a crush on a cute and geeky girl from New Zealand. Maybe if she ends up in the US for a couple years, we’ll hang out.

I have no costume for the party tonight. I’m probably going to feel lame. Again. Oh, well. It didn’t matter terribly long last time. And this time, baileyjordan will be there! And his costume rocks.

Now, if I could just get the hotel phone server that’s been crashing off my bench.

He’s coming!

Oh man that was a blast. I was finally around for one of the Doghouse waterfights.

My sister rocks.

It snowed for the first time this season today. It’s a bit early. Usually we get a light snow around halloween, and it’s dry for a spell after, but today we have four inches and the snow’s still falling. Town is quiet, I think everyone is surprised by the early snow. Nobody was quite ready for it.

I’m snuggled in, having done the dishes and warmed myself that way again. Made soup of herbs d’ province, sundried tomatos and cous-cous. It’s a good day to write and play the cello.

Today, baileyjordan made peirogies (just the frozen kind), but he topped them with sautéed apples, onions, spinach and feta. It was made of win.

Later on, I went to the tea shop, and got to try a rather pricey green tea for free that they’d just received. It was grown in the Americas, which is unusual for tea. Kind of a fun experience.

My life is win.

I just saw Monday Night in Westerbork, at the student theatre at CSU in Fort Collins. Bear was amazing. He’s put together a really excellent show. Tired now, headed back home tomorrow.

insert into auths select account_id, “authorization” from card_batch_items, customers where card_batch_id = 61 and status = ‘Completed’ and card_batch_items.customer_id = customers.id and “authorization” not in (select number from transactions where number is not null);

insert into transactions (number, date, memo) select “authorization”, ‘2007-8-25’, ‘Credit Card Charge’ from auths;

insert into transaction_items (account_id, amount, transaction_id, number) select case when alternation.i = 1 then account_id else 1552 end as account_id, case when alternation.i = 0 then -amount else amount end as amount, transactions.id as transaction_id, auths.”authorization” as number from card_batch_items, alternation, auths, transactions where card_batch_id = 60 and card_batch_items.status = ‘Completed’ and auths.”authorization” = card_batch_items.”authorization” and transactions.number = auths.”authorization”

PostgreSQL:

SELECT name, "authorization" from card_batch_items 
where card_batch_id = 63 and status = 'Completed' and not "authorization" in 
    (select number from transactions where date ='2007-9-25');

Simple query, more or less. Fields like so:

card_batch_items.name varchar(25) not null,
card_batch_items.authorization varchar(25), # Will not be null if status = "Completed"
transactions.date date not null,
transactions.number integer

Simple? Not quite. If transactions.number is null for a matching row, column NOT IN (subquery) fails, because NULL = anything is NULL, and being not-true, returns nothing.

Tonight was talking architecture with my brother, my cousin Aaron and his father Dan. We all want such similar things. He wants to build “a mud house” — cob or so — and starting to live green. Thomas (my brother) wants to build an ecologic apartment complex, and use inexpensive materials (straw and cob, probably on metal or timber frame) to make green apartments affordable.

We all agree that permaculture thinks too small and doesn’t often involve engineers and investors. If we’re gonna make this earth a better place, we’re going to have to start integrating into the mother culture here. We can make steps — large steps, but not leaps — to make things better.

Anyone want to start a green complex on a section in a city? Maybe the idea’s time has come.

Dear girl on the train today:

You and your schoolmate made my day. Talking about digital signal processing theory loud enough to be overheard, and not being ashamed of being easily the two smartest and most interesting people on the entire car was awesome. There’s a reason I said “Thank you”.

Coming out to my family was decidedly non-awkward. “So what should I call you?” was all my cousin said. That was the most overt anyone said.

A good party. Overwhelming numbers of conversations I wanted in on at the same time. Such is my family. We are a tribe for sure.