Khafra Comments - Answer Overflow

Khafra

Explore posts from servers

DIAdiscord.js - Imagine an app CDCloudflare Developers

•Created by Khafra on 11/4/2024 in #workers-help

D1 in workers constant query errors & timeouts

I ended up replacing d1 with kv since it suited our needs better (high read volume, low writes), haven't had any issues yet 🙂

11 replies

CDCloudflare Developers

•Created by Khafra on 11/4/2024 in #workers-help

D1 in workers constant query errors & timeouts

I disabled the db call that was making a majority of those read requests and I haven't had any more issues. The call was:

return await ctx.env.DB.prepare('SELECT * FROM events;')
      .all()
      .then((r) => Response.json(r.results ?? [], { headers: corsHeaders }))

return await ctx.env.DB.prepare('SELECT * FROM events;')
      .all()
      .then((r) => Response.json(r.results ?? [], { headers: corsHeaders }))

where the events table consisted of 0-2 items normally, right now it has 2 items:

 select * from events
name    url    start    end    quark    goldenQuark    cubes    powderConversion    ascensionSpeed    globalSpeed    ascensionScore    antSacrifice    offering    obtainium    octeract    blueberryTime    ambrosiaLuck    oneMind    color
Happy (Possibly Late) Halloween    https://www.youtube.com/watch?v=RcZn2-bGXqQ    2024-10-31T00:00    2024-11-02T12:59    0.1    0.1    0.1    0.1    0.1    0.1    0.1    0.1    0.1    0.1    0.1    0.1    0.1    0.01    #ff8040
Halloweekend    https://www.youtube.com/watch?v=DvQj8dT0Ctg    2024-11-02T00:00    2024-11-03T23:59    0.66    0.06    0.66    0.66    0.66    0.66    0.06    0.66    0.66    0.66    0.66    0.16    0.16    0.16    #ff9500

 select * from events
name    url    start    end    quark    goldenQuark    cubes    powderConversion    ascensionSpeed    globalSpeed    ascensionScore    antSacrifice    offering    obtainium    octeract    blueberryTime    ambrosiaLuck    oneMind    color
Happy (Possibly Late) Halloween    https://www.youtube.com/watch?v=RcZn2-bGXqQ    2024-10-31T00:00    2024-11-02T12:59    0.1    0.1    0.1    0.1    0.1    0.1    0.1    0.1    0.1    0.1    0.1    0.1    0.1    0.01    #ff8040
Halloweekend    https://www.youtube.com/watch?v=DvQj8dT0Ctg    2024-11-02T00:00    2024-11-03T23:59    0.66    0.06    0.66    0.66    0.66    0.66    0.06    0.66    0.66    0.66    0.66    0.16    0.16    0.16    #ff9500

(copied from the dashboard, sorry about formatting)

11 replies

CDCloudflare Developers

•Created by Khafra on 11/4/2024 in #workers-help

D1 in workers constant query errors & timeouts

ty 🙏

11 replies

CDCloudflare Developers

•Created by Khafra on 11/4/2024 in #workers-help

D1 in workers constant query errors & timeouts

yeah :/

11 replies

CDCloudflare Developers

•Created by Khafra on 11/4/2024 in #workers-help

D1 in workers constant query errors & timeouts

account id - bd22ac056a23329365c8a57927490701 db id - 2bd61136-7eb6-4b5d-82ce-f3405294398d traffic wise from Nov 1 -4 read: 107m written: 1.8k

11 replies

CDCloudflare Developers

•Created by Khafra on 11/4/2024 in #workers-help

D1 in workers constant query errors & timeouts

Going to the database console and entering select 1; hangs and part of the page (table size, tables) doesn’t load. The total size of all tables is 3.72 Mb

11 replies

CDCloudflare Developers

•Created by Khafra on 7/29/2024 in #workers-help

websocket request to durable object does not contain upgrade header

under the durable objects docs, I would have never found the option

8 replies

CDCloudflare Developers

•Created by Khafra on 7/29/2024 in #workers-help

websocket request to durable object does not contain upgrade header

works perfectly, thank you! did I miss this in the docs somewhere?

8 replies

CDCloudflare Developers

•Created by Khafra on 7/29/2024 in #workers-help

websocket request to durable object does not contain upgrade header

8 replies

Gaming

Programming