Cannot run Studio with IndexedDB setup for PGlite

Hi everyone, I start my PGlite setup with

const client = new PGlite('idb://xxxx');
const db = drizzle({client});

const client = new PGlite('idb://xxxx');
const db = drizzle({client});

In drizzle.config.ts,

export default defineConfig({
  dialect: 'postgresql',
  schema: './src/db/schema.ts',
  out: './src/db/migrations',
  driver: 'pglite',
  dbCredentials: {
    url: 'idb://xxxx'
  }
})

export default defineConfig({
  dialect: 'postgresql',
  schema: './src/db/schema.ts',
  out: './src/db/migrations',
  driver: 'pglite',
  dbCredentials: {
    url: 'idb://xxxx'
  }
})

But there is error:

No config path provided, using default 'drizzle.config.ts'
Reading config file '/Users/xxx/git/xxx/drizzle.config.ts'
TypeError: Cannot read properties of null (reading 'open')

No config path provided, using default 'drizzle.config.ts'
Reading config file '/Users/xxx/git/xxx/drizzle.config.ts'
TypeError: Cannot read properties of null (reading 'open')

Do you know where is the problem? Thanks.

5 Replies

lukask•4w ago

I have the same issue. @dinhanhthi could you solve it in the meanwhile?

lukask•3w ago

Added a github issue for this: https://github.com/drizzle-team/drizzle-orm/issues/4278

GitHub

[BUG]: Cannot read properties of null (reading 'open') when running...

Report hasn't been filed before. I have verified that the bug I'm about to report hasn't been filed before. What version of drizzle-orm are you using? 0.40.0 What version of drizzle-kit...

Maston•3w ago

I don't understand the expected behaviour here? Only errors this way when trying to use pglite's indexeddb persistance... I think you're simply not supposed to use drizzle-kit when using pglite in the browser, how is drizzle-kit going to run migrations when the db is in your browser? You can use drizzle-kit to generate the migrations, but to run them on the browser you need to implement some other logic, for example include them in your public folder, then import them on the frontend and run them there Gonna make a example repo maybe it is useful for people

Maston•3w ago

https://github.com/mastondzn/drizzle-kit-pglite-browser i came up with this

GitHub

GitHub - mastondzn/drizzle-kit-pglite-browser

Contribute to mastondzn/drizzle-kit-pglite-browser development by creating an account on GitHub.

Maston•3w ago

Also, this error is not from drizzle-kit, its the error pglite gives when you try to use new Pglite("idb://...") in node

Gaming

Programming

Cannot run Studio with IndexedDB setup for PGlite

Did you find this page helpful?