s3-lite-client VS kysely

S3 client: @aws-sdk/client-s3 sucks, both in terms of DX & package size. I wish Cloudflare would make their R2 worker API a general purpose package for anyone to use. The closest I have found that is good in the meantime is @bradenmacdonald/s3-lite-client.

I discovered that Prisma’s generator feature allows arbitrary code generation from Prisma’s table definition files. Even query builder libraries like Kysely can use Prisma generators to output necessary type definition files. For this ORM, I decided to use Prisma for table definitions and migrations, automatically generating required files with Prisma’s generator. While Rails’ migrations involve creating differential files, I personally find Prisma’s approach—automatically generating migration files from schema files—more convenient, which was one reason for this choice.

Honestly any typescript library with great type safety probably has seriously gnarly generics inside. Here[1] is a random file from kysely, which is surprisingly readable even though kysely's type safety is incredibly good.

But things I encounter in the regular non-library world are usually recursive types that have specific constraints. A couple years ago I had my first foray into typescript generics, and was so stumped that I actually gave up. I was trying to map the type of one nested object to another. This[2] is the stackoverflow post from the legendary jcalz that saved me! Check jcalz's link to the TS playground

[1]https://github.com/kysely-org/kysely/blob/master/src/query-b...

What are the differentiators to https://kysely.dev ?

This was one of the problems I ran into https://github.com/kysely-org/kysely/issues/664, not being able to use functions inside onDuplicateKeyUpdate

> Using SQL queries is typesafe with Kysely https://kysely.dev/ (without the need for an ORM)

Wow, this is even better than what I've seen people do with F# type providers. Cool cool cool.

Surprised nobody has mentioned “Kysely” (https://kysely.dev).

It is a query builder (not an ORM), that (ab)-uses the Typescript type system to give you full type safety, intellisense, autocomplete etc.

Crucially it doesn’t require any build/compile step for your queries which is fantastic.

The most interesting JS DB lib I came across was https://github.com/kysely-org/kysely but still didn't feel as good as EF Core.