Comment by codr7
1 year ago
At the peak of my hyper typing trip, doing lots of Haskell and C++, I was trying to encode all the column/table/query types of my database in the host language.
Nothing I would recommend, perfect doesn't mean its a good idea.
Kysley does a good job of this. I haven't found it annoying.
Well... I think MySQL is a 2nd class citizen so I had to write my own schema gen but that only burned a few hours. Now it's great
On the other hand: https://kysely.dev/docs/recipes/excessively-deep-types
Is it though, or are you currently enjoying the same trip?
I mean, take a step back, is it worth the effort?
Kysley is worth the effort, yes.
Prisma and Drizzle...those gave me a bit too much heck. Kysley is close enough to SQL while offering some benefits, typings being one of them, but also query builders are often helpful when I need to run subtle variations of the same query, e.g. depending on the user's permissions or to add search filters.