Support for Postgres and MySQL via Hyperdrive

[imjlk]

Since this project is already integrated with Drizzle ORM, I believe we can easily extend its database support. By utilizing Hyperdrive, we can add compatibility for not only Cloudflare D1 but also for Postgres and MySQL.

/**
 * Generic Drizzle database configuration (internal)
 */
interface DrizzleConfig<Fn extends (...args: any) => any> {
     /** Drizzle database instance */
     db: ReturnType<Fn>;
     /** Adapter options (provider omitted) */
     options?: Omit<DrizzleAdapterConfig, "provider">;
}

export interface WithCloudflareOptions extends CloudflarePluginOptions {
    /**
     * D1 database for primary storage, if that's what you're using.
     */
    d1?: DrizzleConfig<typeof d1Drizzle>;

    /** Postgres database configuration for Hyperdrive */
    postgres?: DrizzleConfig<typeof postgresDrizzle>;

    /** MySQL database configuration for Hyperdrive */
    mysql?: DrizzleConfig<typeof mysqlDrizzle>;

    /** KV namespace for secondary storage */
    kv?: KVNamespace<string>;
}

I will open a PR for this shortly. Thank you!

[PabloG6]

Any update on this?

[imjlk]

My plan was to create additional examples after PR #8 gets approved, but if possible, I’ll try to create a Neon or Supabase example in a separate PR within the next few days

[zpg6]

@imjlk - let's consider reopening #7. We can label this feature clearly as experimental in the docstring.