Local-only IndexedDB-backed PGLite database

[gwennlbh]

Hi! I tried following the guide to setup Drizzle with PGlite. I then tried using #2532 (comment) to setup migrations, then awaiting the migrate function from that discussion answer in my layout load function (i'm using SvelteKit) to migrate the in-browser database.

However, I stumble upon this error:

TypeError: Cannot read properties of null (reading 'open')
    at Object.getDB (file:///home/uwun/projects/cigale/node_modules/@electric-sql/pglite/dist/index.js:2:9138)
    at Object.getRemoteSet (file:///home/uwun/projects/cigale/node_modules/@electric-sql/pglite/dist/index.js:2:10031)
    at file:///home/uwun/projects/cigale/node_modules/@electric-sql/pglite/dist/index.js:2:8895
    at Object.getLocalSet (file:///home/uwun/projects/cigale/node_modules/@electric-sql/pglite/dist/index.js:2:9961)
    at Object.syncfs (file:///home/uwun/projects/cigale/node_modules/@electric-sql/pglite/dist/index.js:2:8850)
    at file:///home/uwun/projects/cigale/node_modules/@electric-sql/pglite/dist/index.js:2:23056
    at Array.forEach (<anonymous>)
    at Object.syncfs (file:///home/uwun/projects/cigale/node_modules/@electric-sql/pglite/dist/index.js:2:23004)
    at file:///home/uwun/projects/cigale/node_modules/@electric-sql/pglite/dist/index.js:1:4705
    at new Promise (<anonymous>)

Node.js v22.14.0

Considering the getRemoteSet function call, and everyone using a remote db too in my web searches, i feel like local-only setups are not really supported.

Is it possible at all?

See https://github.com/cigaleapp/cigale/tree/gwenn/pglite/

Thanks!

[yeonsubak]

I'm glad to see someone who's working on a project with Drizzle ORM + PGLite!

Since the migration by drizzle-kit is not yet officially supported, I run drizzle-kit generate to generate DDL in SQL, fetch the raw SQL statements from the server-side, then run $client.exec() to initialize schemas.

Although my project is based on Next.js 15 unlike you using SvelteKit, I'm pretty sure this approach works.