D
I
gitignore an .env--auto-iam-authn to workDcloud-sql-proxy, I can remove 0.0.0.0/0 in the allow IPs list in Google Cloud SQL.DID
G
null
AA
N
ADDAD
T
FFF
A
pnpm run devwrangler.tomlnpx wrangler hyperdrive create linkp-neon-hyperdrive --connection-string="🚧 Creating 'linkp-neon-hyperdrive'
✅ Created new Hyperdrive config
{
"id": "<ID>",
"name": "linkp-neon-hyperdrive",
"origin": {
"host": "ep-old-sky--pooler.ap-southeast-1.aws.neon.tech",
"port": 5432,
"database": "linkp-db",
"scheme": "postgresql",
"user": "hyperdrive-user"
},
"caching": {
"disabled": false
}
}src/index.tsexport const injectDB = createMiddleware(async (c, next) => {
try {
console.log(
Connecting to database...${c.env.HYPERDRIVE.connectionString}
);
const sql = neon(c.env.HYPERDRIVE.connectionString);
c.req.db = drizzle({ client: sql, schema });
await next();
} catch (error) {
console.error("Database connection error:", error);
throw new HTTPException(503, { message: "Database connection failed" });
}
});import { drizzle } from "drizzle-orm/neon-http";Postgres & node-postgres instead of neon-http
Denv.HYPERDRIVE.connectionString in the global context?
S
FFFAFFAFAFAFAFAF
. Although the node MySQL driver doesn't support Workers yet, haha
YA
wrangler dev) does not currently support connecting to remote databases that require SSL. It is a known gap that we are hoping to address in the future.YAdocker run -d -e POSTGRES_PASSWORD=password -p 5433:5432 postgres:16 -c ssl=on -c ssl_cert_file=/etc/ssl/certs/ssl-cert-snakeoil.pem -c ssl_key_file=/etc/ssl/private/ssl-cert-snakeoil.key)wrangler dev --remotelocalConnectionString but will use the Hyperdrive binding you give it instead.sslmode=disable (this is probably the hardest to mange given I don't think Supabase supports that)Y
Kgitignore ^ You must provide a password - e.g.
'user:password@database.example.com:port/databasename'--auto-iam-authncloud-sql-proxy0.0.0.0/0A request to the Cloudflare API (/accounts/xxxxxxxxxxx/hyperdrive/configs) failed.
Internal Server Error [code: 10000]pnpm run devnpx wrangler hyperdrive create linkp-neon-hyperdrive --connection-string="🚧 Creating 'linkp-neon-hyperdrive'
✅ Created new Hyperdrive config
{
"id": "<ID>",
"name": "linkp-neon-hyperdrive",
"origin": {
"host": "ep-old-sky--pooler.ap-southeast-1.aws.neon.tech",
"port": 5432,
"database": "linkp-db",
"scheme": "postgresql",
"user": "hyperdrive-user"
},
"caching": {
"disabled": false
}
}export const injectDB = createMiddleware(async (c, next) => {
try {
console.log(
);
const sql = neon(c.env.HYPERDRIVE.connectionString);
c.req.db = drizzle({ client: sql, schema });
await next();
} catch (error) {
console.error("Database connection error:", error);
throw new HTTPException(503, { message: "Database connection failed" });
}
});import { drizzle } from "drizzle-orm/neon-http";Postgresnode-postgresneon-httpenv.HYPERDRIVE.connectionStringnpx wrangler dev --remotewrangler devdocker run -d -e POSTGRES_PASSWORD=password -p 5433:5432 postgres:16 -c ssl=on -c ssl_cert_file=/etc/ssl/certs/ssl-cert-snakeoil.pem -c ssl_key_file=/etc/ssl/private/ssl-cert-snakeoil.keylocalConnectionStringsslmode=disable