Composite primary keys
Storing the key as a list, with no singular field beside it, forced every path that only handles one column to say so. One of them was deleting the whole table.
Roger Padilla
9 posts by Roger Padilla
In search of the type-safest ORM
I resisted narrowing find results, because a narrowed row is no longer the entity. Then I upgraded every project I maintain and none of them needed the entity back.
Semantic search: native vector similarity in a multi-dialect ORM
UQL 0.3 ships native semantic search across PostgreSQL, MariaDB, SQLite, and MongoDB Atlas, with automatic index migration.
Standard decorators: props & cons
The annotation is now checked against the property it describes, which legacy decorators could never do. It cost three decorators, parameter injection, and NestJS compatibility.
How much memory does an ORM cost per request?
Three ways I measured per-request allocation wrong before I got one I trusted, and why the result isn't the leak table it looks like.
What does an ORM really cost you?
Six ORMs, one full PostgreSQL lifecycle, timed per step. Prisma comes fifth of six, and one step is responsible for most of it.
Zero dependencies: what we deleted
npm i uql-orm installs one package and nothing else. Getting there meant deleting a 1.8 MB transpiler, a 264 KB metadata polyfill, and the sourcemaps nobody read.
In search of the fastest TypeScript ORM
Pure SQL generation speed across 7 TypeScript ORMs and query builders, measured with an open, reproducible benchmark.
In search of the perfect TypeScript ORM
What makes a perfect ORM? I evaluated the top 5 features every TypeScript ORM should have, and why the existing ones fall short.