How can i use honohub with cloudflare d1?

[Stead08]

I want to use Cloudflare D1 with HonoHub, but I need to access the database from the Hono context.
With the initialization:

const app = new Hono();
app.route("/", createHub(hubConfig));

I cannot use the context, so I cannot access the database.
Is there any good solution?
Thanks

[MathurAditya724]

Hey! were you able to solve this?

[Stead08]

I don't expect this to be implemented as a new feature, so I have closed the issue.

[MathurAditya724]

I am aware of a method to use D1 with HonoHub, but it's not my preferred approach. However, I do believe it's important to provide a solution. I'll reopen this issue to ensure we implement either a function or an example to make HonoHub work seamlessly with D1.

[MiguelsPizza]

Also interested in D1 support. Maybe default to D1 if one of the bindings pass in extends the abstract class?

declare abstract class D1Database {
  prepare(query: string): D1PreparedStatement;
  dump(): Promise<ArrayBuffer>;
  batch<T = unknown>(statements: D1PreparedStatement[]): Promise<D1Result<T>[]>;
  exec(query: string): Promise<D1ExecResult>;
}

A declarative approach might be better though

[framebassman]

@MathurAditya724 basically, this issue is not related to the D1 or any other type of database. The main issue is the following - there is no access to the Context in app.route("/", createHub(hubConfig)); code, so I cannot use fetch the env variables at all.

[MathurAditya724]

Yeah, working on a new draft for this

[webdeb]

Yeah, working on a new draft for this

Hello, when do expect a progress in this direction?