(Untitled)
Updated the blog engine to a new version and that broke the colors... Gotta figure out what's up.
Update: it was actually loading the custom CSS file :facepalm:
Vasili Sviridov
Podcast Episode 15
Skipping episode 14 for the time being, as I have to re-record bits of audio.
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.