Out of curiosity would anyone use prisma over kyse...
# general
k
Out of curiosity would anyone use prisma over kysely and why?
t
A lot of people do use Prisma
The migration support in it can be considered better
Overall we don't recommend it because it's not designed well for lambdas
k
Alright thanks, 😅 kysely documentation website just looks uncomfortable
t
I actually find kysely to be incredibly well documented since it uses tsdoc
Everything I need shows up in my editor, never have to go to the website
k
🤔 really
t
To expand on what I said earlier, Prisma requires shipping large rust binaries with your lambda. This really slows down cold start times
k
Thanks for the insights
t
Additionally Prisma can only connect using a normal postgres connection whereas our kysely setup uses the data api. This means with Prisma you need to also place an RDS proxy in front to deal with the large number of connections
Ultimately I find it's a lot to pay for just to be able to use a popular ORM
r
I’ve just started with it and have built some pretty complex dynamic queries really quickly, including the likes of MATCH AGAINST for fulltext indexes, very impressed. The author is very responsive in the Discord server too.
m
anyone have experience with TypeORM's start times? I dislike TypeORM a lot and am looking for any excuse to rip it out
experiencing a problem with our cognito triggers, which have a max 5 second lifespan (can't be extended) - they communicate with SQL and have been timing out
t
Typeorm is just using pg under the hood right? Shouldn't be any worse than anything else
m
probably
t
That said I haven't seen anything that bad with either PG or MySQL with kysely
m
kysely's API and documentation looks beautiful. gonna experimen with migrating from typeorm (whose documentation is decidedly NOT beautiful)
t
Haha love to see a convert!