https://boristane.com/blog/durable-objects-database-per-user/

[utterances-bot]

One Database Per User with Cloudflare Durable Objects and Drizzle ORM | Boris Tane

Using Durable Objects and Drizzle ORM to create isolated SQLite databases for each user in a Hono app

https://boristane.com/blog/durable-objects-database-per-user/

[danieljvdm]

Awesome writeup. I'd love to see how you choose to handle auth in this setup!

[cmackenzie1]

Great stuff Boris!

I was modeling this in my worker and was getting the following issue when trying to use migrate() from Vitest tests.

RollupError: Parse failure: Expected ';', '}' or <eof>
At file: /Users/cole/gitlab/cole/flume/drizzle/0000_zippy_joshua_kane.sql:1:8

Adding the following plugin to my vitest.config.mts solves this.

import { defineWorkersConfig } from '@cloudflare/vitest-pool-workers/config'

export default defineWorkersConfig({
  test: {
    poolOptions: {
      workers: {
        wrangler: { configPath: './wrangler.jsonc' },
      },
    },
  },
  plugins: [
    {
      name: 'sql-loader',
      transform(code, id) {
        if (id.endsWith('.sql')) {
          const escapedCode = code.replace(/\\/g, '\\\\').replace(/`/g, '\\`').replace(/\${/g, '\\${')
          return `export default \`${escapedCode}\`;`
        }
      },
    },
  ],
})

[boristane]

@cmackenzie1 absolutely brilliant addition! I didn't cover testing here, thanks for sharing :)

[rubenbase]

What are the recommended best practices for authentication/authorization in this setup?

[boristane]

@rubenbase, I store all the user and session details into a separate database, typically Cloudflare D1. And I use this database for authz.

[WarlockJa]

This is gold! Thank you very much for this article @boristane. This is exactly what I was looking for and delivered in a stellar manner.

[joefitter]

Incredible write up, thanks so much for taking the time to break it down!

[techjandro]

This is just beyond helpful and interesting @boristane, thank you!

[fl0wo]

Amazing, straight to the point! Would love to see a similar article on how to run DO locally, shared between 2 wrangler projects!

thank you for this gem