Sign in Subscribe

Topic

typesafe

A collection of 4 issues

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