the repo still exists though: <https://github.com/cloudflare/worker-template-mysql>

the repo still exists though: https://github.com/cloudflare/worker-template-mysql

CChaika the repo still exists though: <https://github.com/cloudflare/worker-template-mys...

DC•3/13/24, 5:15 PM

Thank you. Did this work OK for you? I am guessing that they are probably not maintaining this pending hyperdrive for mysql. However, it seems to have been on the 'future' list for a while.

ChaikaOP•3/13/24, 5:15 PM

I last tried it a very long time ago. One of the big issues with it is no connection pooling like hyperdrive, so have to make a whole new connection on each request, slow

CChaika there was an old one but it got removed, had to use a hacky old unmaintained pat...

DC•3/13/24, 5:18 PM

Ah OK - thanks for your insights - I wonder if perhaps the worker solution is not quite ready enough. I wonder how others deal with the lack of access to DB's ? KV write latency is too slow for us and D1 does not quite seem to be production ready. I guess it depends on the usecase.

rob•3/13/24, 6:39 PM

how is everyone.. KV write latency is slow?

rob•3/13/24, 6:39 PM

what about using hyperdrive and raw sql queries?

Rrob how is everyone.. KV write latency is slow?

ChaikaOP•3/13/24, 6:43 PM

the actual write? Well, KV only has two central stores, one in US, one in EU, so slow from some locations.
for seeing those changes? If a location had viewed that key, it'll be cached for a min of 60s, until they pull from central store again and see update

Rrob what about using hyperdrive and raw sql queries?

ChaikaOP•3/13/24, 6:43 PM

depends on where your visitors and server is located

rob•3/13/24, 6:54 PM

Yah i was using planetscale+prisma but switching to writing raw sql queries and using hyperdrive

Walshy•3/13/24, 7:47 PM

I'd recommend using the workers template

Walshy•3/13/24, 7:47 PM

It depends on what features you use, the template has them all

ChaikaOP•3/13/24, 7:49 PM

probably cryptic because you're missing User -> Memberships

Walshy•3/13/24, 10:08 PM

for secrets, you should upload with wrangler secret put <binding>wrangler secret put <binding>

Walshy•3/13/24, 10:09 PM

for normal env vars, put them in the wrangler.toml per env is ideal otherwise yeah --var

ℭ

ℭ𝔦𝔯𝔠𝔲𝔦𝔱𝔊𝔬𝔡•3/14/24, 2:09 AM

Hello! I am new here and sorry if this is a noob question, I am running Android 11 and I was going to make a discord bot using discord.js that runs on workers. But when i tried to install C3 on termux, it gave me an error on one of the post install steps in some dependency. Can someone help me troubleshoot my problem?

ℭℭ𝔦𝔯𝔠𝔲𝔦𝔱𝔊𝔬𝔡 Hello! I am new here and sorry if this is a noob question, I am running Android ...

ChaikaOP•3/14/24, 2:18 AM

Hey

I would stop you a bit short though, Cloudflare Workers are not node.js, they instead run on V8, same Javascript Engine as Chrome and similiar Web Environment. There is some nodejs compatibility but no net support/CF only supports TCP Sockets through a special interface. Additionally, Discord bans CF IPs from their CDN except for ephemeral media/static things like Avatars, and they banned CF entirely from Gateway for a while, which I think is still active? Eitherway it just won't really work.

Instead of Gateway bots you can do Interactions Bots/slash commands (https://discord.com/developers/docs/tutorials/hosting-on-cloudflare-workers), but they're semi-limited.

rob•3/14/24, 3:10 AM

Ah so DiscordJS doesnt work on workers as a diurable object type thing ?

Dikshant Rai•3/14/24, 7:11 AM

hi all, I am trying to create a worker which proxy to my pages on suffix. I have this code for worker.js but it is not working as it throws an error as page not found.

// Export a default object containing event handlers
export default {
  // The fetch handler is invoked when this worker receives a HTTP(S) request
  // and should return a Response (optionally wrapped in a Promise)
  async fetch(request) {
    // Parse the request URL
    const url = new URL(request.url);

    // If the request URL matches '/blog1', proxy it to the Cloudflare Pages site
    if (url.pathname.startsWith('/blog1')) {
      // Construct the proxied URL
      const proxiedUrl = 'https://coderabbit-docs.pages.dev' + url.pathname;

      // Proxy the request to the specified URL and return the response
      return fetch(proxiedUrl, request);
    }

    // For other requests, return a default response
    // return new Response('Welcome to my Cloudflare Worker!', {
    //   headers: { 'Content-Type': 'text/plain' },
    // });
  },
};

// Export a default object containing event handlers
export default {
  // The fetch handler is invoked when this worker receives a HTTP(S) request
  // and should return a Response (optionally wrapped in a Promise)
  async fetch(request) {
    // Parse the request URL
    const url = new URL(request.url);

    // If the request URL matches '/blog1', proxy it to the Cloudflare Pages site
    if (url.pathname.startsWith('/blog1')) {
      // Construct the proxied URL
      const proxiedUrl = 'https://coderabbit-docs.pages.dev' + url.pathname;

      // Proxy the request to the specified URL and return the response
      return fetch(proxiedUrl, request);
    }

    // For other requests, return a default response
    // return new Response('Welcome to my Cloudflare Worker!', {
    //   headers: { 'Content-Type': 'text/plain' },
    // });
  },
};

If I hit my domain with suffix, it goes to 404 .

Froge•3/14/24, 9:22 AM

I'm unable to upgrade my Workers account to Paid, as I'm getting

Try again in 5 minutes. Your account is undergoing maintenance right now.

Try again in 5 minutes. Your account is undergoing maintenance right now.

We're 10M requests out of 100,000, for some reason we got automatically downgraded to Free plan.

Now we're stuck getting 429 errors all over the place...

There was an incident report stating issues with the dashboard a couple of hours ago, which has since gone without a trace.

CChaika Hey 👋 I would stop you a bit short though, Cloudflare Workers are not node.js...

ℭ

ℭ𝔦𝔯𝔠𝔲𝔦𝔱𝔊𝔬𝔡•3/14/24, 9:56 AM

Ok but even if that does not work why can't I install C3 in Android?

ℭℭ𝔦𝔯𝔠𝔲𝔦𝔱𝔊𝔬𝔡 Ok but even if that does not work why can't I install C3 in Android?

Hello, I’m Allie!•3/14/24, 10:07 AM

Might be that there isn’t a version of workerd, the Workers Runtime, compiled for Android?

HHello, I’m Allie!Might be that there isn’t a version of workerd, the Workers Runtime, compiled fo...

ℭ

ℭ𝔦𝔯𝔠𝔲𝔦𝔱𝔊𝔬𝔡•3/14/24, 10:08 AM

Can I compile it then?

ℭℭ𝔦𝔯𝔠𝔲𝔦𝔱𝔊𝔬𝔡 Can I compile it then?

Hello, I’m Allie!•3/14/24, 10:08 AM

Maybe, but not on Android

Hello, I’m Allie!•3/14/24, 10:09 AM

It can take an hour or two for a clean build, and that is on a desktop

Hello, I’m Allie!•3/14/24, 10:09 AM

They might have sped it up recently

Hello, I’m Allie!•3/14/24, 10:09 AM

But still

ℭ

ℭ𝔦𝔯𝔠𝔲𝔦𝔱𝔊𝔬𝔡•3/14/24, 10:10 AM

I have a Ubuntu homelab server in my house which has 4GB ram and 100GB of swap. will it work?

ℭℭ𝔦𝔯𝔠𝔲𝔦𝔱𝔊𝔬𝔡 I have a Ubuntu homelab server in my house which has 4GB ram and 100GB of swap. ...

Hello, I’m Allie!•3/14/24, 10:11 AM

Maybe, though if you have access to a server, it might be easier to ssh onto it and just do your development there

ℭ

ℭ𝔦𝔯𝔠𝔲𝔦𝔱𝔊𝔬𝔡•3/14/24, 10:12 AM

My server is offline now but I can get it online in about 5 to 10 mins. So how do I build it? Is it like git clone then make ?

ℭℭ𝔦𝔯𝔠𝔲𝔦𝔱𝔊𝔬𝔡 My server is offline now but I can get it online in about 5 to 10 mins. So how d...

Hello, I’m Allie!•3/14/24, 10:13 AM

I meant, instead of using C3 on Android, why not use it on your server?

ℭ

ℭ𝔦𝔯𝔠𝔲𝔦𝔱𝔊𝔬𝔡•3/14/24, 10:17 AM

No I still don't have a public IP address. If I go out and want to develop on a new idea I just had, I will have to drive back to my house

ℭℭ𝔦𝔯𝔠𝔲𝔦𝔱𝔊𝔬𝔡 No I still don't have a public IP address. If I go out and want to develop on a ...

Hello, I’m Allie!•3/14/24, 10:32 AM

You could use something like Tailscale or CF WARP to connect to the server, even if you don’t have a public IP

DDikshant Rai hi all, I am trying to create a worker which proxy to my pages on suffix. I have...

rob•3/14/24, 11:19 AM

Why not just set a custom domain on the pages project ?

rob•3/14/24, 11:20 AM

You'll be paying for invocations everytime your worker fetches it

HHello, I’m Allie!You could use something like Tailscale or CF WARP to connect to the server, even...

ℭ

ℭ𝔦𝔯𝔠𝔲𝔦𝔱𝔊𝔬𝔡•3/14/24, 11:36 AM

i will try

JoeDoe•3/14/24, 12:57 PM

What will happen if a cron is triggered, and it's a long running process, and then another cron is triggered?

JoeDoe•3/14/24, 12:58 PM

Will the function run twice?

ℭℭ𝔦𝔯𝔠𝔲𝔦𝔱𝔊𝔬𝔡 Ok but even if that does not work why can't I install C3 in Android?

dave•3/14/24, 1:00 PM

What’s C3?

JoeDoe•3/14/24, 1:17 PM

How can I get my worker to run more than 30 seconds?
I'm having a cron job trigger a database syncing function, which can run for 30mins from the start

Devon•3/14/24, 1:19 PM

can you poll the DB sync status periodically? serverless isn't really meant for long running jobs

DDevon can you poll the DB sync status periodically? serverless isn't really meant for...

JoeDoe•3/14/24, 1:20 PM

yeah it's possible I guess...

JoeDoe•3/14/24, 1:20 PM

and would need to trigger it more frequently then

JoeDoe•3/14/24, 1:20 PM

and sync smaller bits at a time

Devon•3/14/24, 1:20 PM

serverless isn't meant for running 30 minute tasks

JJoeDoe What will happen if a cron is triggered, and it's a long running process, and th...

JoeDoe•3/14/24, 1:21 PM

do you know about this?

Devon•3/14/24, 1:21 PM

so I'd see if you can run it asyncronously. or look at stateful compute options

Devon•3/14/24, 1:21 PM

oh you can setup a job state table/KV to check job status before runnign thing. pretty common pattern overall.

JJoeDoe How can I get my worker to run more than 30 seconds? I'm having a cron job trigg...

ChaikaOP•3/14/24, 1:27 PM

sounds like you're hitting this:

On the Unbound billing model, scheduled Workers (Cron Triggers) have different limits on CPU time based on the schedule interval. When the schedule interval is less than 1 hour, a Scheduled Worker may run for up to 30 seconds. When the schedule interval is more than 1 hour, a scheduled Worker may run for up to 15 minutes.

ChaikaOP•3/14/24, 1:27 PM

although that mentions Unbound, I would imagine Standard would be the same

AnotherAlex•3/14/24, 1:55 PM

Is there any way to check the compatibility version/flags on a deployed worker? I can't use the Header.getSetCookie function because it doesn't exist, although the code editor reports it existing on the type.

kian•3/14/24, 1:58 PM

You could hit the API to see what it's currently set to, but that's about it.

// Export a default object containing event handlers export default { // The fetch handler is invoked when this worker receives a HTTP(S) request // and should return a Response (optionally wrapped in a Promise) async fetch(request) { // Parse the request URL const url = new URL(request.url); // If the request URL matches '/blog1', proxy it to the Cloudflare Pages site if (url.pathname.startsWith('/blog1')) { // Construct the proxied URL const proxiedUrl = 'https://coderabbit-docs.pages.dev' + url.pathname; // Proxy the request to the specified URL and return the response return fetch(proxiedUrl, request); } // For other requests, return a default response // return new Response('Welcome to my Cloudflare Worker!', { // headers: { 'Content-Type': 'text/plain' }, // }); }, };

the repo still exists though: <https://github.com/cloudflare/worker-template-mysql>

Similar Threads

Similar Threads

Similar Threads