https://blog.cloudflare.com/neon-postgres-database-from-workers

A

AcеOP•3/18/24, 12:42 AM

Try this

AAcе https://blog.cloudflare.com/neon-postgres-database-from-workers

X

x03•3/18/24, 12:51 AM

I'll definetally look into this. Also I've tried the documented "postgres + drizzle + workers" implementation but this was what started the issues in the first place

X

x03•3/18/24, 12:51 AM

seems like the

pg

pg

package just does not work on pages

W

Walshy•3/18/24, 12:52 AM

Yeah https://github.com/porsager/postgres works with nodejs_compat (compat flag) so works on Pages

WWalshy Yeah <https://github.com/porsager/postgres> works with nodejs_compat (compat fla...

X

x03•3/18/24, 12:56 AM

Thank you for pointing this out, I'm implementing this right now

X

x03•3/18/24, 3:19 AM

I'm running into an issue where trying to use AWS SES within pages does not work. A runtime error occurs:

Error: Dynamic require of \"node:buffer\" is not supported

Error: Dynamic require of \"node:buffer\" is not supported

X

x03•3/18/24, 3:20 AM

Is there any way around this? I dont want to use other services like mailgun because they're way too pricey

J

jensen•3/18/24, 4:31 AM

This is what I am currently doing to connect to a postgres db from within pages using the pg driver

1) Create a pages application, for mine I am using Remix.
2) Setup a worker called

pg-proxy

pg-proxy

that has a binding to a Hyperdrive instance. Use the Hyperdrive connectionString with the pg driver in the worker.
3) Setup drizzle with an http proxy in your pages application. The pages app can use a service binding to call the

pg-proxy

pg-proxy

worker directly.
4) Make requests with drizzle, they will be proxied to your pages worker and your pages worker will use the connection pool from Hyperdrive.

With this setup you can connect to any postgres db.

For email using Amazon SES I was able to get @aws-sdk/client-ses working within a pages handler.

A

abhi.a•3/18/24, 6:16 AM

Hi, I am using Cloudflare Turnstile captcha for my website. sometimes the captcha works but sometimes even if with the genuine user the captcha fails and returns error, not allowing user to do the payment. Please guide me on how to fix this ?

N

nikiv.dev•3/18/24, 8:51 AM

how do I set node_compat for my page in dashboard?

N

nikiv.dev•3/18/24, 8:52 AM

N

nikiv.dev•3/18/24, 8:52 AM

I am not sure it's this

Nnikiv.dev Click to see attachment

H

Hello, I’m Allie!•3/18/24, 8:59 AM

Pages doesn't support

node_compat

node_compat

. It does support

nodejs_compat

nodejs_compat

, which is slightly different

N

nikiv.dev•3/18/24, 9:02 AM

how do i set

nodejs_compat

nodejs_compat

N

nikiv.dev•3/18/24, 9:03 AM

N

nikiv.dev•3/18/24, 9:03 AM

actually i have it set

N

nikiv.dev•3/18/24, 9:03 AM

it seems

I

Illfatedchild•3/18/24, 10:01 AM

Hi Cloudflare, do you have policies on .dev pages where phishing sites are swarming?

IIllfatedchild Hi Cloudflare, do you have policies on .dev pages where phishing sites are swarm...

H

Hello, I’m Allie!•3/18/24, 10:03 AM

?abuse

F

Flare•3/18/24, 10:03 AM

If you feel that a site is engaging in illegal or inappropriate activities, you can submit an abuse report at https://abuse.cloudflare.com/. The Trust and Safety team will review the details and reply if appropriate. You can also report the site to your relevant local authorities. Reports cannot be filed via Discord or with individual employees or Champs.

I

Illfatedchild•3/18/24, 10:04 AM

These are the phishing pages, I wonder what is your turnaround time for these? We already used your CloudFlare abuse forms, and it seems there are no actions

phishing_pages_dot_dev_cases.xlsx48.28KB

IIllfatedchild These are the phishing pages, I wonder what is your turnaround time for these? W...

H

Hello, I’m Allie!•3/18/24, 10:05 AM

We can't do anything here. All Abuse-related actions can only be handled via the abuse form.

I

Illfatedchild•3/18/24, 10:06 AM

thanks

I

Illfatedchild•3/18/24, 10:32 AM

And when that won't work, who can we talk to? how do I even know if they are looking at my reports?

IIllfatedchild And when that won't work, who can we talk to? how do I even know if they are loo...

H

Hello, I’m Allie!•3/18/24, 10:40 AM

They are the only ones that can handle those reports

H

Hello, I’m Allie!•3/18/24, 10:40 AM

There isn't anything else we can do from here

S

sultan.xh•3/18/24, 10:46 AM

Is it possible to move the git repo ownership without impacting the page app setup?

Jjensen This is what I am currently doing to connect to a postgres db from within pages ...

X

x03•3/18/24, 11:42 AM

Thank you for suggesting

@aws-sdk/client-ses

@aws-sdk/client-ses

, it seems that

aws-sdk

aws-sdk

(the lib i was using) is old and will be depricated next year. Everything works fine now

A

asenpons•3/18/24, 1:32 PM

Hello, does Cloudflare Pages support SSR sites? is using a lite node? or full node compatibility? I saw some posts that users complain that some packages don't work because the less node compatibility.

Aasenpons Hello, does Cloudflare Pages support SSR sites? is using a lite node? or full no...

I

Isaac McFadyen•3/18/24, 1:36 PM

Cloudflare Pages supports SSR, but it's not Node - it's the Cloudflare Workers runtime, which is a lightweight JavaScript runtime that supports a smaller subset of Node features.

I

Isaac McFadyen•3/18/24, 1:36 PM

Quite a few things work, especially with Node.js compatibility mode enabled, but some don't (e.g. there's no filesystem so no

fs

fs

fs

fs)

I

Isaac McFadyen•3/18/24, 1:36 PM

The only way to know for sure is to try it out with your specific use-case.

A

asenpons•3/18/24, 1:40 PM

thank you @Isaac McFadyen

Xx03 Thank you for suggesting `@aws-sdk/client-ses`, it seems that `aws-sdk` (the lib...

J

jensen•3/18/24, 2:21 PM

Yeah been this way for a while. Definitely use the v3 libs

Iits.jcw if I use Origin Rules to rewrite DNS to target a Pages site on a custom domain, ...

M

Marius Gundersen•3/19/24, 10:41 AM

Why not point the domain there directly? What should the custom domain be used for if it doesn't point there?

D

Deo Kumar•3/19/24, 2:11 PM

I was using git integration, for some reason I needed to use GitHub actions to build my pages project and deploy it using pages action. So I deleted the project and re-created it so I can use assets upload. But when I try to add my custom domain it says:

The hostname is part of a banned domain. This web property cannot be added to Cloudflare at this time. If you are an Enterprise customer, please contact your Customer Success Manager. Otherwise, please email abusereply@cloudflare.com with the name of the web property and a detailed explanation of your association with this web property.

The hostname is part of a banned domain. This web property cannot be added to Cloudflare at this time. If you are an Enterprise customer, please contact your Customer Success Manager. Otherwise, please email abusereply@cloudflare.com with the name of the web property and a detailed explanation of your association with this web property.

The hostname is part of a banned domain. This web property cannot be added to Cloudflare at this time. If you are an Enterprise customer, please contact your Customer Success Manager. Otherwise, please email abusereply@cloudflare.com with the name of the web property and a detailed explanation of your association with this web property.

The hostname is part of a banned domain. This web property cannot be added to Cloudflare at this time. If you are an Enterprise customer, please contact your Customer Success Manager. Otherwise, please email abusereply@cloudflare.com with the name of the web property and a detailed explanation of your association with this web property.

DDeo Kumar I was using git integration, for some reason I needed to use GitHub actions to b...

C

Chaika•3/19/24, 2:12 PM

Do you have any unpaid/partially paid invoices? iirc the billing migration has been messing with that a bit as well.
Otherwise you'll need to email that abusereply@ address

CChaika Do you have any unpaid/partially paid invoices? iirc the billing migration has b...

D

Deo Kumar•3/19/24, 2:18 PM

No, I sent an email.
Thank you.

DDeo Kumar No, I sent an email. Thank you.

D

Deo Kumar•3/19/24, 6:57 PM

I didn't get the reply yet, if I don't know the problem how can I fix it. And what if the site was production ready, I may have lost many traffic?

S

squareclamp•3/19/24, 8:23 PM

Anyone know if build caching works with remix projects or if there is way to leverage it unofficially? Its not in the documented frameworks.

J

juanferreras•3/19/24, 10:47 PM

if a domain

example.com

example.com

is a Cloudflare Zone inside Account ID 1, and a Cloudflare Pages project exists for Account ID 2.

Can

example.com

example.com

(the apex) be added as a Custom Domain on the Pages project? Or do you need to actually own the zone / have access to the zone for it to work?

W

Walshy•3/19/24, 10:47 PM

Yes but you may need to use the API/Terraform

W

Walshy•3/19/24, 10:48 PM

The UI will not properly see it and will say to move to cf

J

juanferreras•3/19/24, 10:51 PM

hey Walshy! thanks for such a quick response. Got it! That makes sense, didn't know there was an API, that's actually even better

P

Patrick•3/20/24, 3:21 AM

Can someone check my thinking here, I'm a bit confused by how I should configure my

wrangler.toml

wrangler.toml

to account for the fact that I have a Pages app, a production database, and a preview database. The prod and preview DBs are bound to their respective environments via dash app as "DB".

[[d1_databases]]
binding = "DB"
database_id = "014f4d7a-7d36-4c40-ada2-d0015f8a6471"
database_name = "my-db"
migrations_dir = "./functions/database/migrations"
preview_database_id = "406e7298-a837-4451-bec2-a6a229aac08d"
# preview_database_id = "DB"

[[d1_databases]]
binding = "DB"
database_id = "014f4d7a-7d36-4c40-ada2-d0015f8a6471"
database_name = "my-db"
migrations_dir = "./functions/database/migrations"
preview_database_id = "406e7298-a837-4451-bec2-a6a229aac08d"
# preview_database_id = "DB"

[[d1_databases]]
binding = "DB"
database_id = "014f4d7a-7d36-4c40-ada2-d0015f8a6471"
database_name = "my-db"
migrations_dir = "./functions/database/migrations"
preview_database_id = "406e7298-a837-4451-bec2-a6a229aac08d"
# preview_database_id = "DB"

[[d1_databases]]
binding = "DB"
database_id = "014f4d7a-7d36-4c40-ada2-d0015f8a6471"
database_name = "my-db"
migrations_dir = "./functions/database/migrations"
preview_database_id = "406e7298-a837-4451-bec2-a6a229aac08d"
# preview_database_id = "DB"

I'm a bit confused about how this should be configured for local dev. When I run

wrangler pages dev

wrangler pages dev

wrangler pages dev

wrangler pages dev with the preview_database_id set to my actual previews database id, am I running locally with my previews database remote from the edge?

When I want a miniflare D1 DB local for dev, should I be changing the

wrangler.toml

wrangler.toml

to not have the actual preview_database_id and replace it with just "DB"?

I'm a bit more confused trying to understand the

wrangler pages dev

wrangler pages dev

wrangler pages dev

wrangler pages dev output about bindings in both scenarios and what these mean:

With the actual ID:

Your worker has access to the following bindings:
- D1 Databases:
  - DB: my-db (406e7298-a837-4451-bec2-a6a229aac08d), Preview: (406e7298-a837-4451-bec2-a6a229aac08d)

Your worker has access to the following bindings:
- D1 Databases:
  - DB: my-db (406e7298-a837-4451-bec2-a6a229aac08d), Preview: (406e7298-a837-4451-bec2-a6a229aac08d)

Your worker has access to the following bindings:
- D1 Databases:
  - DB: my-db (406e7298-a837-4451-bec2-a6a229aac08d), Preview: (406e7298-a837-4451-bec2-a6a229aac08d)

Your worker has access to the following bindings:
- D1 Databases:
  - DB: my-db (406e7298-a837-4451-bec2-a6a229aac08d), Preview: (406e7298-a837-4451-bec2-a6a229aac08d)

With the string "DB":

Your worker has access to the following bindings:
- D1 Databases:
  - DB: my-db (DB), Preview: (DB)

Your worker has access to the following bindings:
- D1 Databases:
  - DB: my-db (DB), Preview: (DB)

Your worker has access to the following bindings:
- D1 Databases:
  - DB: my-db (DB), Preview: (DB)

Your worker has access to the following bindings:
- D1 Databases:
  - DB: my-db (DB), Preview: (DB)

Why are there two listed here? Why are they both the same in the first scenario? Both bindings are set to "DB", and that's how they're referenced in my functions.

I have the impression that my

wrangler.toml

wrangler.toml

is correct because my CI migration

wrangler d1 migrations apply

wrangler d1 migrations apply

with and without

--preview

--preview

--preview

--preview appear to be running on the expected DBs. I'm just still quite a bit confused about how this should be set up for local dev. I could maybe use a separate .toml file for local dev? I could try to remember to change the file each time I want to work locally? Maybe I'm missing something?

T

TreeBeard•3/20/24, 2:14 PM

how do i make
Cache-Control to have these status ? private, max-age=0, no-store, no-cache, must-revalidate, post-check=0, pre-check=0

A

Adi•3/20/24, 11:41 PM

Question, I see a bunch of lines in the recent wrangler release notes on Pages support

wrangler.toml

wrangler.toml

. Is there experimental support for this already? Any docs or tips on how we can use this?

https://blog.cloudflare.com/neon-postgres-database-from-workers

Similar Threads

Similar Threads

Similar Threads