M
J
D
AA
D
postgres://USERNAME:PASSWORD@HOSTNAME_OR_IP_ADDRESS:PORT/database_nameAD
WAs many hosted databases have limits on the number of unique connections they can manage, Hyperdrive attempts to keep number of concurrent pooled connections to your origin database lower.
AWAA
W
S
OAOA
T
UUTU
C
Optimized Host: aws.connect.psdb.cloud or Direct which in my case is eu-central.connect.psdb.cloud?ssl={"rejectUnauthorized":true} at the end, should I keep it?import { createConnection } from "mysql2/promise"; whereas kysely says import { createPool } from 'mysql2' // do not use 'mysql2/promises'! (https://www.kysely.dev/docs/getting-started?package-manager=pnpm&dialect=mysql#instantiationconnectionLimit? Default in kysely docs is 10
also nice weekend to y'all 
I
Optimized Host will likely just add a layer of complexity since they'll be trying to also handle global routing.createConnection is correct. Note that because of the way Hyperdrive works, it's safe and recommended to create a new connection on every request (and terminate the connection after each request using ctx.waitUntil).createConnection even has a connectionLimit param because it's not pooling anyway...)C
MysqlDialect only supports pool connection it seems 
I
K
.A.A.A
Y
cloudflared container in the same network.<random_name>.<my_domain>.com/mysq://... with TCP typeA
Kpostgres.js and {prepare: true}. Are transactions known not to work with hyperdrive at all?AA
DDwrangler dev --remote works perfectly
Spostgres(connStr, {max: 5, fetch_types: false,}) (not that I need more than one connection but the docs suggested setting max to 5) and I have the cache disabled since the purpose of my query is to catch updates to a counter due to mutations by other clients. My app is not yet publicly released, so there is very little traffic.AI that's kinda interesting, any idea why postgres.js does and node-postgres doesn't? I feel like I've seen it mentioned before but don't remember what the reason given wasAbinary and text. Postgres.js uses the binary format, while node-postgres uses the text format. float or timestamp. 
Ipostgres://USERNAME:PASSWORD@HOSTNAME_OR_IP_ADDRESS:PORT/database_nameOptimized HostOptimized Hostaws.connect.psdb.cloudDirecteu-central.connect.psdb.cloud?ssl={"rejectUnauthorized":true}import { createConnection } from "mysql2/promise";import { createPool } from 'mysql2' // do not use 'mysql2/promises'!connectionLimitconnectionLimitcreateConnectioncreateConnectionctx.waitUntilMysqlDialectpoolcloudflared<random_name>.<my_domain>.com/mysq://...postgres.js{prepare: true}wrangler dev --remotepostgres(connStr, {max: 5, fetch_types: false,})binarytextfloattimestampname: Deploy App
on:
push:
branches: main
permissions:
contents: read
jobs:
deploy:
runs-on: self-hosted
steps:
- name: Checkout repository
uses: actions/checkout@v4
with:
fetch-depth: 1
- name: Install dependencies
run: npm ci
- name: Check DB migrations
run: |
output=$(npx drizzle-kit generate)
echo "$output"
if ! echo "$output" | grep -q "No schema changes, nothing to migrate"; then
echo; echo "Error: Schema changes detected. Please generate migrations before deploying."
exit 1
fi
- name: Apply DB migrations
env:
DATABASE_URL: ${{ secrets.DATABASE_URL }}
run: npx drizzle-kit migrate
- name: Deploy application to Cloudflare
env:
CLOUDFLARE_API_TOKEN: ${{ secrets.CLOUDFLARE_API_TOKEN }}
CLOUDFLARE_ACCOUNT_ID: ${{ secrets.CLOUDFLARE_ACCOUNT_ID }}
run: npx wrangler deployconst connection = await mysql.createConnection({
host: host,
user: username,
password: password,
database: database,
port: port,
disableEval: true,
connectTimeout: 1000,
ssl: {
rejectUnauthorized: true,
}
});app.all("*", async (c, next) => {
const sql = postgres(c.env.database.connectionString, {
max: 5,
fetch_types: false
});
const db = drizzle(sql);
c.set("database", db);
await next()
})c.executionCtx.waitUntil(sql.end())import { Context } from 'hono';
import postgres from 'postgres';
const db = (c: Context) => {
console.log('Connecting to database...');
console.log(c.env.HYPERDRIVE.connectionString);
const connectionString = c.env.HYPERDRIVE?.connectionString;
return postgres(connectionString, {
fetch_types: false
});
};
export default db;Connecting to database...
postgresql://neondb_owner:*************@91a7****************d1e4c29.hyperdrive.local:5432/neondb?sslmode=disable
✘ [ERROR] PostgresError: connection is insecure (try using `sslmode=require`)