PGlite Dialect for Knex
npm install knex-pglite
Since PGlite is single user and only supports a single connection, this library doesn't allow users to configure
the connection pool in the Knex.Config.
Internally, the pool is set to { min: 1, max: 1 }, i.e. there is exactly one connection at a time.
``bash`
npm install knex-pglite
`ts
import { knex } from "knex";
import ClientPgLite from "knex-pglite";
const instance = knex({
client: ClientPgLite,
dialect: "postgres",
// Use an empty object to use an in memory db
connection: {},
// OR use the filesystem:
// connection: { filename: 'path/to/my-pgdata' },
// OR use indexdb:
// connection: { connectionString: 'idb://my-pgdata' },
// OR provide own PGLite instance (experimental; no TypeScript types...)
// connection: () => ({ pglite: new PGLite() } as object)
});
``
Mostly based on the build-in knex Postgres/Sqlite dialects.