Hyperdrive isn't a database, it's just a way to connect to an existing database. If you need a datab

Hyperdrive isn't a database, it's just a way to connect to an existing database. If you need a database then you could investigate Supabase, Neon, Turso, Planetscale, bigger clouds like AWS or Azure, or one of the many other providers.

IIsaac McFadyen Hyperdrive isn't a database, it's just a way to connect to an existing database....

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

Yeah, i meant hyperdrive connected to a self-hosted VPS postgres database. Hyperdrive was said to not work with pages at all.

Is there any self-host alternatives though? I dont want to pay the massive fees that these cloud database providers have.

Isaac McFadyenOP•3/18/24, 12:35 AM

You can still connect to the VPS Postgres database from Pages.

Isaac McFadyenOP•3/18/24, 12:35 AM

You'll just need to use postgres.jspostgres.js or one of the other supported database connectors.

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

ohh, node-postgres isnt viable?

Isaac McFadyenOP•3/18/24, 12:35 AM

Hyperdrive can make things faster, but if you couldn't get it to work then that's fine.

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

I had build issues with it, which explains a lot

Xx03 ohh, node-postgres isnt viable?

Isaac McFadyenOP•3/18/24, 12:35 AM

I believe it should work? There's a couple specifically supported ones. One second.

IIsaac McFadyen I believe it should work? There's a couple specifically supported ones. One seco...

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

These were my build logs when trying to integrate node-postgres

Isaac McFadyenOP•3/18/24, 12:36 AM

So node-postgres is supported, but only with polyfills.

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

As a note, this is a SvelteKit pages app

Isaac McFadyenOP•3/18/24, 12:36 AM

So that's likely why it's not working.

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

What are polyfills?

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

I just read on it and I guess its some sort of middleware to provide compatibility? How do I implement it?

Xx03 I just read on it and I guess its some sort of middleware to provide compatibili...

Isaac McFadyenOP•3/18/24, 12:37 AM

Exactly, yeah. But generally you don't implement it yourself, there are packages to do it for you.

Isaac McFadyenOP•3/18/24, 12:37 AM

I'm not certain which ones would apply in this use-case however.

Xx03 What are polyfills?

Acе•3/18/24, 12:38 AM

They’re like fake packages that copy the same style as the node ones so things work on browsers/workers

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

Ah I see

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

does postgres.js work out of the box on pages?

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

I could try all of the alternative libraries, and if none work then look into some sort of polyfill solution

Xx03 I could try all of the alternative libraries, and if none work then look into so...

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

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

The Cloudflare Blog

Easy Postgres integration on Cloudflare Workers with Neon.tech

Neon.tech is a database platform that allows you to branch your (Postgres compatible) database exactly like your code repository.And with the release of their Cloudflare Workers integration you can get started in minutes.

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

Try this

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

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

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

seems like the

pg

pg

package just does not work on pages

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...

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

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

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 supportedError: Dynamic require of \"node:buffer\" is not supported

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

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-proxypg-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-proxypg-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.

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 ?

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

how do I set node_compat for my page in dashboard?

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

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

I am not sure it's this

Nnikiv.dev Click to see attachment

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

Pages doesn't support node_compatnode_compat. It does support

nodejs_compat

nodejs_compat

, which is slightly different

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

how do i set

nodejs_compat

nodejs_compat

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

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

actually i have it set

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

it seems

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...

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

?abuse

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.

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...

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.

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

thanks

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...

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

They are the only ones that can handle those reports

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

There isn't anything else we can do from here

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 ...

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

Thank you for suggesting @aws-sdk/client-ses@aws-sdk/client-ses, it seems that aws-sdkaws-sdk (the lib i was using) is old and will be depricated next year. Everything works fine now

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...

Isaac McFadyenOP•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.

Hyperdrive isn't a database, it's just a way to connect to an existing database. If you need a datab

Similar Threads

Similar Threads

Similar Threads