search

kysely-org / kysely

A type-safe typescript SQL query builder
https://kysely.dev
MIT License
10.23k stars 260 forks source link

Kysely + Objection.js #1

Closed calmonr closed 3 years ago

calmonr commented 3 years ago

Is there any intent of switching from Knex.js to Kysely in the future on Objection.js?

Nice work by the way.

koskimas commented 3 years ago

Thanks! Probably not, for the same reason I'm not contributing this to knex. It would mean a significant rewrite and API change.

calmonr commented 3 years ago

@koskimas You are totally right. Keep up the good work.

mmahalwy commented 2 years ago

to that point, @koskimas curious if youd build objectionjs or a new orm from the start?

seeden commented 2 years ago

I am curious as well :) maybe it will be part of this package directly :)

kasvith commented 1 year ago

Will there be a new ORM like Objection?

seeden commented 1 year ago

@kasvith you can try https://github.com/seeden/kysely-orm

kasvith commented 1 year ago

@seeden it seems really nice

mifi commented 6 months ago

drizzle orm also feels like objection but it is fully type-safe

kasvith commented 6 months ago

tbh drizzle feels like prisma, where objection was much more like a wrapper around a query builder. we still use it in production

mifi commented 6 months ago

I also use Objection in production and it's great. But seeing that Objection has slowed down development and its lacking type safety, moving forward I'm looking for alternatives. What I love about objection is that it allows customisable querying of deep table relations into a JSON structure without too much magic (withGraphFetched). And I can still include raw sql or use knex alongside to run more complex raw queries. IMO drizzle also feels like a thin layer over sql similar to knex/kysely, but it has the added benefit of being able to easily specify and query relations into JSON objects, kind of like Objection. Prisma feels like a higher and heavier layer which abstracts away differences between SQL flavours, and it may generate an arbitrary number of sql queries based on your query. For me the biggest issues with drizzle are:

kasvith commented 6 months ago

i wish objection had continuous development :( ngl apart from typesafety its the best ORM even today