pglite support

[sombriks]

Environment

Knex version: latest
Database + version: https://github.com/electric-sql/pglite
OS: any supported by pglite

Select applicable template from below.
If issue is about oracledb support, tag @ atiertant. For MSSql tag @ smorey2.
Rest of dialects don't need tags.
If issue is about TypeScript definitions, tag @ lorefnon.

Feature discussion / request

pglite seems very straightforward to use directly, but i am wondering what would be needed to add support for this to use it like we use sqlite for example

[czeidler]

I guess you have to implement a dialect like in https://github.com/knex/knex/blob/master/lib/dialects/pgnative/index.js, right? But what is the required interface for the driver? is there any docs on it? Hard to figure out without type information...

[czeidler]

I created: https://www.npmjs.com/package/knex-pglite to use pglite with knex

[jawadst]

Thanks a lot @czeidler. I tried your package and it worked great!

[sombriks]

this is amazing, i guess knex is also a first class frontend library now!

[sombriks]

@czeidler it works on browser nicely, thank you so much for your work! https://github.com/sombriks/vue-pglite-knex-example

it think it is worth to be mentioned in the docs, i'll open the PR to the knex docs!