What are some database solutions I can use for my SvelteKit pages app? Hyperdrive does not work, and
What are some database solutions I can use for my SvelteKit pages app? Hyperdrive does not work, and D1 does not seem ready to be used either.
IHyperdrive 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.
XYeah, 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.
Is there any self-host alternatives though? I dont want to pay the massive fees that these cloud database providers have.
IYou can still connect to the VPS Postgres database from Pages.
IYou'll just need to use
postgres.js or one of the other supported database connectors.Xohh, node-postgres isnt viable?
IHyperdrive can make things faster, but if you couldn't get it to work then that's fine.
XI had build issues with it, which explains a lot
II believe it should work? There's a couple specifically supported ones. One second.
XThese were my build logs when trying to integrate node-postgres
ISo node-postgres is supported, but only with polyfills.
XAs a note, this is a SvelteKit pages app
ISo that's likely why it's not working.
XWhat are polyfills?
XI just read on it and I guess its some sort of middleware to provide compatibility? How do I implement it?
IExactly, yeah. But generally you don't implement it yourself, there are packages to do it for you.
II'm not certain which ones would apply in this use-case however.
AThey’re like fake packages that copy the same style as the node ones so things work on browsers/workers
XAh I see
Xdoes postgres.js work out of the box on pages?
XI could try all of the alternative libraries, and if none work then look into some sort of polyfill solution
AThe Cloudflare Blog
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.
ATry this
XI'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
Xseems like the
pg
W
XThank you for pointing this out, I'm implementing this right now
XI'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 supportedXIs there any way around this? I dont want to use other services like mailgun because they're way too pricey 
JThis 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
3) Setup drizzle with an http proxy in your pages application. The pages app can use a service binding to call the
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.
1) Create a pages application, for mine I am using Remix.
2) Setup a worker called
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 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.
AHi, 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 ?
Nhow do I set node_compat for my page in dashboard?
N
NI am not sure it's this
HPages doesn't support
node_compatnodejs_compathow do i set
nodejs_compat
Nactually i have it set
Nit seems
IHi Cloudflare, do you have policies on .dev pages where phishing sites are swarming?
FIf 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.
IThese 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
HWe can't do anything here. All Abuse-related actions can only be handled via the abuse form.
Ithanks 
IAnd when that won't work, who can we talk to? how do I even know if they are looking at my reports?
HThey are the only ones that can handle those reports
HThere isn't anything else we can do from here
SIs it possible to move the git repo ownership without impacting the page app setup?
XThank you for suggesting 
@aws-sdk/client-sesaws-sdk
AHello, 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.
