Can I use drizzle, pglite with mem0?

[YanceyOfficial]

Hello, I'm working an Electron desktop app, and the database system uses drizzle and pglite

The following code is Drizzle configuration:

import { defineConfig } from 'drizzle-kit'

export default defineConfig({
  schema: './src/main/lib/db/schema.ts',
  out: './resources/drizzle',
  dialect: 'postgresql',
  driver: 'pglite',
  dbCredentials: { url: 'database.sqlite' }
})

The follows code is Pglite configuration:

import { PGlite } from '@electric-sql/pglite'
import { vector } from '@electric-sql/pglite/vector'
import { drizzle } from 'drizzle-orm/pglite'
import { app } from 'electron'
import { join } from 'path'

const dbPath = join(app.getPath('userData'), 'Database')
export const pglite = new PGlite({
  dataDir: dbPath,
  extensions: { vector }
})

export const db = drizzle(pglite)

I'm wondering how to connect DB to mem0

import { Memory } from 'mem0ai/oss'
import { Settings } from '../db/schema'

export const initMemory = ({ settings }: { settings: Settings }) =>
  new Memory({
    version: 'v1.1',
    embedder: {
      provider: 'openai',
      config: {
        apiKey: settings.providers?.openaiApiKey ?? '',
        model: 'text-embedding-3-small'
      }
    },
    vectorStore: {
      provider: 'pgvector',
      config: {
        collectionName: '???',
        embeddingModelDims: 1536,
        user: '???',
        password: '???',
        host: '???',
        port: 5432,
        dbname: 'vector_store', // Optional, defaults to 'postgres'
        diskann: false, // Optional, requires pgvectorscale extension
        hnsw: false // Optional, for HNSW indexing
      }
    },
    llm: {
      provider: 'openai',
      config: {
        apiKey: settings.providers?.openaiApiKey ?? '',
        model: 'gpt-4o'
      }
    },
    historyDbPath: 'memory.db'
  })