Cloudflare d1

[thunderbug1]

Hello,

The project is compatible with Sqlite, is it also compatible with Cloudflare d1 which is based on Sqlite?

[lroal]

In theory, it should work as long as you run cloudflare with nodejs compatability flag (because it needs nodejs domain)
But I need to create an adapter for it first.

[thunderbug1]

thank you very much for your fast answer and the project in general.

Are you planning on building an adapter for d1? I see quite a long list of adapters in the roadmap drafts.

[lroal]

Perhaps you need this too, not sure

compatibility_date = "2024-09-23"

[lroal]

I have tested it with d1 and it throws error. I need to investigate this.

Cannot create pool for database outside node

[thunderbug1]

ok thank you for the updates.

[lroal]

FYI:
To make it compatible with Cloudflare D1, I need to refactor some internal components and remove the deprecated Domain module in Node.js. Currently, I use it internally as an "async context" or "thread singleton" to avoid passing the connection around. Once this change is implemented, it will pave the way for compatibility with other runtimes and databases like Deno and pgLite. This is a necessary internal update and will not affect the public API.

While I can’t provide an exact delivery date, my goal is to complete it by January 2025.

[thunderbug1]

ok, thank you.
I ended up using this now: https://www.kysely.dev/

[lroal]

Cloudflare is now supported from v.4.5.0
_{📄 wrangler.toml}

name = "d1-tutorial"
main = "src/index.ts"
compatibility_date = "2025-02-04"

# Bind a D1 database. D1 is Cloudflare’s native serverless SQL database.
# Docs: https://developers.cloudflare.com/workers/wrangler/configuration/#d1-databases
[[d1_databases]]
binding = "DB"
database_name = "<your-name-for-the-database>"
database_id = "<your-guid-for-the-database>"

_{📄 src/index.ts}

import map from './map';

export interface Env {
  // Must match the binding name in wrangler.toml  
  DB: D1Database;
}

export default {
  async fetch(request, env): Promise<Response> {
    const db = map.d1(env.DB);
    const customers = await db.customer.getAll();
    return Response.json(customers);
  },
} satisfies ExportedHandler<Env>;