Looking at the averages on the CPU time here, would I be generally OK within the Workers Bundled tie

Looking at the averages on the CPU time here, would I be generally OK within the Workers Bundled tier (50ms CPU time limit)

MMozzy Looking at the averages on the CPU time here, would I be generally OK within the...

Walshy•4/12/23, 8:08 PM

Yeah that looks fine to me. Only a few over, you need to be averaging over for it to be a problem

MozzyOP•4/12/23, 8:08 PM

Okay

MozzyOP•4/12/23, 8:09 PM

I guess as the D1 DB grows, the more CPU time will be used to fetch it though

Walshy•4/12/23, 8:09 PM

Nah it shouldn't impact your CPU time

MozzyOP•4/12/23, 8:10 PM

Oh? What is it that's using CPU time then? https://github.com/leonlarsson/bfstats-api/blob/main/handlers/cacheD1.ts

MozzyOP•4/12/23, 8:12 PM

(and I could probably Promise.all() and bulk fetch and all that as well to improve things)

Walshy•4/12/23, 8:12 PM

Hmm that's weird

Walshy•4/12/23, 8:13 PM

Yeah definitely shouldn't be using anywhere near ~40ms for this

MozzyOP•4/12/23, 8:13 PM

Am I doing something bad here?

Walshy•4/12/23, 8:14 PM

@skye_31 know of any weirdness with D1's shim taking a ton of CPU time? The operations it does isn't complex.
Perhaps the JSON parse from the SQL response?

Walshy•4/12/23, 8:14 PM

(God I can't wait to get rid of this shim)

Walshy•4/12/23, 8:16 PM

Yeah that's what I'm thinking... I hate that this manifests for users due to the shim

Walshy•4/12/23, 8:17 PM

I don't think we count binding compute time

Walshy•4/12/23, 8:17 PM

(Also ideally we don't use JSON for the real binding)

Walshy•4/12/23, 8:18 PM

Don't think you want to read C++

Walshy•4/12/23, 8:18 PM

It's not easy to parse

Walshy•4/12/23, 8:19 PM

Sadly it's far far worse

MozzyOP•4/12/23, 8:20 PM

In short, I can't do anything to bring the CPU time down on my side?

WWalshy (Also ideally we don't use JSON for the real binding)

Hello, I’m Allie!•4/12/23, 8:26 PM

Laughs in Cereal

Tarnadas•4/12/23, 8:27 PM

Hey, I'm trying to set up postgres, but I'm just accessing a public db so I don't want to set up tunneling.
Is it possible to do this? I tried following this (https://developers.cloudflare.com/workers/tutorials/query-postgres-from-workers-using-database-connectors/), but when I fetch my API and it tries to connect to postgres I receive:

(log) Fetch API cannot load: mainnet.db.explorer.indexer.near.dev

(log) Fetch API cannot load: mainnet.db.explorer.indexer.near.dev

my client connection looks like this:

      const client = new Client({
        user: 'public_readonly',
        password: 'nearprotocol',
        database: 'mainnet_explorer',
        hostname: 'mainnet.db.explorer.indexer.near.dev',
        port: '5432',
      })

      const client = new Client({
        user: 'public_readonly',
        password: 'nearprotocol',
        database: 'mainnet_explorer',
        hostname: 'mainnet.db.explorer.indexer.near.dev',
        port: '5432',
      })

TTarnadas Hey, I'm trying to set up postgres, but I'm just accessing a public db so I don'...

Hello, I’m Allie!•4/12/23, 8:29 PM

The database connector connects to a WebSocket, which would be provided by the Tunnel. If you are connecting to a public DB that doesn't provide a WebSocket API, then it will not work.

HHello, I’m Allie!The database connector connects to a WebSocket, which would be provided by the T...

Tarnadas•4/12/23, 8:30 PM

Are there any other libraries I could use instead, so that I don't need the tunnel?

Tarnadas•4/12/23, 8:32 PM

Will go to sleep now so checking back later

TTarnadas Are there any other libraries I could use instead, so that I don't need the tunn...

Hello, I’m Allie!•4/12/23, 8:33 PM

No. At the moment, unless you have access to the TCP Worker beta, then you cannot connect to anything that doesn't support HTTP(S) or WebSockets, whether that be a Database, a Live Stream, or something else.

Hello, I’m Allie!•4/12/23, 8:34 PM

Note too that directly opening a connection to your DB in a Worker may not be the best approach anyway, as most databases are not optimized for extremely short-lived connections running only 1-2 queries.

JJorgeDev Does anyone know if it is possible to run workers on only one region?

Cyb3r-Jak3•4/12/23, 9:56 PM

Not without being enterprise. You can just make a firewall that blocks access to the worker apart from certain areas depending on your needs

addison•4/12/23, 10:27 PM

If I need to cache posts a user loads from the db should I be using workers kv for this?

SSilence Does anyone host a discord bot on pages/functions? If so could you tell me do yo...

Cyb3r-Jak3•4/13/23, 1:08 AM

You should probably do it during the deployment process

Chaika•4/13/23, 3:30 AM

Cloudflare Apps are pretty much abandoned/unmaintained at this point. Most of them are by third party devs as well, it might be that the ones you are using are broken
This channel is for workers, if you want to talk about Apps more, please use #general-discussions

Dio•4/13/23, 3:48 AM

guys are trying to use service binding. There are 2 worker
A "user" and a "parser".
I've written service binding in "parser "config. I run -local 2 worker . I try to get it via env.user, but I see there is no «user» in parser env, although at start it says that there is service binding in console

李

李二牛li2niu•4/13/23, 4:35 AM

Hi, all , I saw event.cf.longitude is only available for Enterprise customers, so it means we 5$ paid plan users cannot access that? Thanks for your responding

kian•4/13/23, 4:37 AM

Where did you see that it's Enterprise only?

Kkian Where did you see that it's Enterprise only?

李

李二牛li2niu•4/13/23, 4:43 AM

https://community.cloudflare.com/t/starting-with-workers-and-lat-long/217639

Cloudflare Community

Starting with workers and Lat/Long

Just started using Cloudflare and liking the testing that we are doing. We are working to get Latitude and Longitude into the header similar to how we are doing that with a competing CDN. I have been reading the articles below and having some issues just getting started with workers and the general setup. Any assistance would be appreciated.

李

李二牛li2niu•4/13/23, 4:43 AM

Keep in mind that the event.cf object and its properties, including event.cf.latitude, are only available to Cloudflare Enterprise customers in the scope of their workers running on the Cloudflare network.

李

李二牛li2niu•4/13/23, 4:44 AM

In the first thread, the last user said that.

李李二牛li2niu Keep in mind that the event.cf object and its properties, including event.cf.lat...

李

李二牛li2niu•4/13/23, 4:44 AM

It is said by GPT4

李

李二牛li2niu•4/13/23, 4:45 AM

{
"outcome": "exception",
"scriptName": "wapi",
"exceptions": [
{
"name": "TypeError",
"message": "Cannot read properties of undefined (reading '0')",
"timestamp": 1681312866750
}
],
"logs": [
{
"message": [
{
"code": "404"
}
],
"level": "log",
"timestamp": 1681312866750
}
],
"eventTimestamp": 1681312865895,
"event": {
"request": {
"url": "https://wapi.li2niu.com/v1?sign=REDACTED&provider=q&lang=8389372&api_key=&lat=-0.00&lon=0.00",
"method": "GET",
"headers": {
"accept": "/",
"accept-encoding": "gzip",
"accept-language": "zh-CN,zh-Hans;q=0.9",
"cache-control": "no-cache",
"cf-connecting-ip": "114.92.92.54",
"cf-ipcountry": "CN",
"cf-ray": "7b6c7503c9724136",
"cf-visitor": "{"scheme":"https"}",
"connection": "Keep-Alive",
"content-type": "application/x-www-form-urlencoded",
"host": "wapi.li2niu.com",
"user-agent": "ConnectMobile/4 CFNetwork/1404.0.5 Darwin/22.3.0",
"x-forwarded-proto": "https",
"x-real-ip": "114.92.92.54"
},
"cf": {
"clientTcpRtt": 242,
"longitude": "121.45810",
"latitude": "31.22220",
"tlsCipher": "AEAD-AES128-GCM-SHA256",
"continent": "AS",
"asn": 4812,
"clientAcceptEncoding": "gzip, deflate, br",
This is a json from worker log. I saw the lat and lon in event.cf

kian•4/13/23, 4:49 AM

It is said by GPT4

Ignore GPT-4 then

kian•4/13/23, 4:50 AM

It'll work fine regardless of plan

const client = new Client({ user: 'public_readonly', password: 'nearprotocol', database: 'mainnet_explorer', hostname: 'mainnet.db.explorer.indexer.near.dev', port: '5432', })

Looking at the averages on the CPU time here, would I be generally OK within the Workers Bundled tie

Similar Threads

Similar Threads

Similar Threads