fredx87 / effect-kysely Goto Github PK

I'm giving this lib a try and I was having some issues w/ the import path. I currently have to add this to my ts config for ts to accept that "effect-kysely/sqlfx" is a path that exists. lol.

"compilerOptions": {
    "paths": {
        "effect-kysely/*": [
            "node_modules/effect-kysely/dist/*"
        ]
    }
}

Also, importing from "effect-kysely/dist/sqlfx" makes ts happy without the code above but breaks (at least) bun test.

Hey there 👋

At first I didn't know this package existed, but I have also begun a prototype of an Effect and Kysely with a slightly different approach to things. My intent behind this issue is to see if you'd be interested in merging forces 😄

My Prototype

I have put together a prototype integration here - https://github.com/TylorS/typed/blob/ts/poc/kysely/examples/realworld/src/api/common/infrastructure/kysely.ts.

The key difference is the implementation of @effect/sql's (used to be sqlfx) Client interface here. This allows Kysely to use its drivers/dialects and configuration and we'd gain access to any libraries that will pop up supporting the @effect/sql interfaces directly, including its own.

It also provides Kysely's type-safety around the Sql.schema.* and Sql.resolver.* methods ensuring that Kysely returns at least (can have additional properties) the Encoded side of the Schema for proper conversion to the Type of the schema.

Right now I only have the postgres connection setup, but it will be quite trivial to support all of the @effect/sql-* variants as the only real change is in the @effect/sql-* Compiler interface to construct the Client, all else is the same.

Links

• Database Setup
• Example Query
• Migration