Generate types from existing db about kysely HOT 7 CLOSED

What prevents you from using that library using npx? I agree something like that would be a nice feature, but does writing a simple interface per table really take a significant portion of the development time? I can only imagine it does if you are writing a very simple crud.

While something like this would be a nice feature, It's a lot of work to write and maintain it. It would be helpful for people migrating an existing codebase to Kysely though.

Kysely already has the db.introspection module, which could be used to implement this.

from kysely.

To be fair, if sql-ts really works, code would not have to to be copy pasted. Instead Kysely could include sql-ts as an optional dependency.

And there is a benefit beyond saving time: automatic generation prevent errors when creating the type interfaces.

from kysely.

Nothing prevents. It was a suggestion!

from kysely.

What I meant was, if that library already does what you need, why not use it to create the interfaces for Kysely? If it works, why would we need to copy paste the code to Kysely?

from kysely.

sql-ts has a CLI you can run using npx without installing anything locally.

from kysely.

Yeah, they dont need to depend on each other. They can work in parallel where we simple import the types from the generated sql-ts file.

import { Person, Pet, Movie } from './sql-ts-generated';

interface Database {
  person: Person
  pet: Pet
  movie: Movie
}

from kysely.

Sure, I was just saying that sql-ts could be integrated without copy and pasting code. If you don't want to go that route, no worries.

from kysely.