#life Be COVID-checked in a shop for the first time

#life Get Pfizerd, pt3

#nagel Have my Confluence account fixed after 1.5 years of it being broken

#nagel Update daily stock sync robot to use primary key for update query, because it's much more efficient

#nagel Make sure that daily stock sync robot also accounts for IAM parts which have a secondary, proper partnumber that differs from the OEM number

#nagel Bring down uncached 22s response down to uncached 700ms response

#nagel Pre-generate category trees on production for 11,000 sellable parts

#nagel Find SQL query that has no indexes and ran for >5 seconds, so add index and now it runs in 0.01s

#nagel Cache part categorization tree because so far we've been building it on demand and it's a nested recursive tree, so if you request 700 parts suddenly the request takes 22s and the frontend team is sad

#nagel Rip out Pimcore ORM in another part of the app and replace with raw SQL, as ORM creates insane amounts of overhead

#life Make sure everyone gets to their appointment on time

#nagel Mark parts that do not have a special price based on their age

#nagel Add button to globally re-import settlement rates outside of daily sync in case a service worker updates rates in ERP

#life Send update to pug breeder for puggy's first birthday

#life Eat Christmas ham 🇵🇭

#life Get new debit card

#life Tell accountant that he's unfired and re-hired because life is weird

#life Accounting Q4 '21

#life Switch from farmer bank to better bank

#life Season cast-iron pan