Welcome to the official Cloudflare Developers server. Here you can ask for help and stay updated with the latest news
83,498Members
View on DiscordResources
Similar Threads
Was this page helpful?
A
O
" A
こ
--ca-certificate-id and --mtls-certificate-id are specified.
T
I
node-postgres:With node-postgres, you can install pg-native to boost the speed of both node-postgres and Drizzle by approximately 10%.This won't matter on Workers because Workers doesn't support native extensions.
node-postgres supports providing type parsers on a per-query basis without globally patching things. For more details, see Types Docs.Seems valid but probably somewhat of an advanced use-case?
postgres.js uses prepared statements by default, which you may need to opt out of. This could be a potential issue in AWS environments, among others, so please keep that in mind.Hyperdrive fully supports prepared statements now, and they improve performance so this is probably a benefit of
postgres.js// Clean up the connectionAlso, AJR explained why this was a good idea a while back, but might be good to add a line claryfing this in the docs because people might generally assume it's bad practice to close connections on every request.
ctx.waitUntil(sql.end());
TI
max
T
M
J
DAA
D
postgres://USERNAME:PASSWORD@HOSTNAME_OR_IP_ADDRESS:PORT/database_name
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
SOAOAT
UUTU
C
Optimized 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'!connectionLimit
also nice weekend to y'all 
I
Optimized HostcreateConnectionctx.waitUntilcreateConnectionconnectionLimitMysqlDialectpool
I
K
.A.A.A
Y
cloudflared<random_name>.<my_domain>.com/mysq://...name: 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()
})--ca-certificate-id--mtls-certificate-idnode-postgres