abe-winter

Keybase proof

I hereby claim:

• I am abe-winter on github.
• I am abewinter (https://keybase.io/abewinter) on keybase.
• I have a public key ASBsIGpW6_UrFG6AODW7cmyIFAkri1Mf4Aj3MgZvUPEp1Qo

To claim this, I am signing this object:

abe-winter

{
    "type": "script",
    "description": "otter-export",
    "store": {},
    "modes": [
        3
    ],
    "usageCount": 35,
    "prompt": false,
    "omitTrigger": false,

abe-winter

sqlmodel / alembic onboarding notes

Getting up and running with sqlmodel and alembic took more than 10 minutes, and required editing boilerplate, so I wrote these notes to future me.

versions

I did this in december 2022, with library versions:

alembic==1.9.1

abe-winter

peewee migration notes

Peewee orm has built-in migration but it is not full-featured as of peewee 3.16.0.

It's missing:

1. state tracking table that can track what's been applied
2. auto-generate migrations
3. the migrator doesn't have create table I think

These are my future-reference notes to myself documenting the minimal thing I built to solve the first problem above.

abe-winter

loop.cpython-310-x86_64-linux-gnu.so: loop.pyx
	cythonize -i $^

abe-winter

GKE zonal cluster migration

Apparently a GKE cluster costs $75 a month; this is the most expensive component of the cloud bill for my side project. There is a free tier ... but I recently learned it only applies to zonal clusters, not regional clusters. Much to my chagrin. The pricing docs are very unclear.

So I moved from a regional cluster to a zonal cluster. If you know kube at all you know this is not the kind of thing kube makes easy.

Hard parts about this:

• moving the storage over
• recreating the NEGs