Add Oracle Database core dialect.

kysely-org / kysely

A type-safe typescript SQL query builder

https://kysely.dev

MIT License

10.8k stars 275 forks source link

Add Oracle Database core dialect. #777

Open igalklebanov opened 12 months ago

igalklebanov commented 12 months ago

Hey 👋

Knex supports OracleDB with a core dialect. As part of becoming THE "drop-in" replacement for Knex, we should look for the easy wins in getting as close as reasonable to feature parity. This seems like one.

oracledb (or node-oracledb) has roughly 200k downloads per week, and there's an increase over time: https://npmtrends.com/oracledb

If you want to use Kysely with Oracle DB, please drop a comment OR reaction to this issue. Help us understand the demand in the typescript community for this.

hinogi commented 9 months ago

Oracle also offers docker container for easy testing and with node-oracle 6 also easier setup since you don't need a fat client also but can use a nodejs only implementation as well.

ikdi commented 8 months ago

It would be great to have Oracle DB support

igalklebanov commented 7 months ago

More numbers for prioritization.

Just a hint at oracledb usage with Typescript.

bslinkrga commented 7 months ago

As unfortunate as it is, some of us are having to work with Oracle whether we'd like to or not, until we can migrate off of it fully I'd like to have our integration be the "least crappy" possible, I love Kysley on some of my other projects and it'd be pretty awesome to have that type safety and beautiful DevX even when being stuck with the legacy db systems. For now I guess we'll have to use knex and do a lot of type casting haha