Sign in Subscribe

Vasili Sviridov

Agile is not compatible with deadlines

Change my mind. Discovering complexity of the thing you set out to implement on minimal, happy-path only requirements when everything is already tight and on fire just is not tenable. It's a cavalcade of shitty compromises and corner-cutting at it's finest. Backlog inflation is real, folks.

Type-safe schema generator, part IV

Well, it's good enough for my current needs. I can generate typed CRUD operations for the style of queries that I'm writing. Supports SELECT, UPDATE, INSERT, and DELETE, with JOINs (automatically makes fields nullable for OUTER JOINs). Aliased columns, COUNT, SELECT * ... and RETURNING. Uses nominal types

Type-safe schema generator, part III

So, had to do a little pivot. @typed-query-builder does not support sqlite out of the box, so instead I went the route of parsing queries... Maybe it was a big mistake :D I've gotten to a point where I can traverse my codebase with a glob expression, parse

Type-safe schema generator, part II

So, I've gotten to a point where the generator is able to produce a schema typescript file that is compatible with my current database. The code can be found here. It currently runs on Bun, but can be trivially adapted for Node (w/ better-sqlite3). It will likely require

Type-safe schema generator

Started working on a type-safe schema generator based off the sqlite schema. I'm pulling out the database schema using #bun's native sqlite driver with a simple query: SELECT tbl_name, name, type, sql FROM sqlite_schema WHERE 1=1 AND type = 'table' AND sql

Podcast Episode 10

Podcast Episode 9 will be premiering at 11AM on Friday

Podcast Episode 8 will be premiering in one hour

August 25, 2023 Join us there.

Did a new spam botnet come online recently?

For the last couple of days I see a sustained wave of attempted spam inbound. From a very wide variety of IP addresses, so it's not a single compromised VPS somewhere... My mail server is very small, usually it rejects spam 40-60 messages per day, but yesterday it

I should get a clapper board :D

I don't have one of those, but we can simply use our hands to make it easier to synchronize audio track to the video track, and also two separate video tracks together...