What am I doing wrong?

H

Try

try {
  // ...
} catch (error: any) {
  console.error(`Error while inserting row into accesslog table: ${error}`);
  return Response.json({ message: `Error while inserting row into accesslog table: ${error.message}` });
}

try {
  // ...
} catch (error: any) {
  console.error(`Error while inserting row into accesslog table: ${error}`);
  return Response.json({ message: `Error while inserting row into accesslog table: ${error.message}` });
}

try {
  // ...
} catch (error: any) {
  console.error(`Error while inserting row into accesslog table: ${error}`);
  return Response.json({ message: `Error while inserting row into accesslog table: ${error.message}` });
}

try {
  // ...
} catch (error: any) {
  console.error(`Error while inserting row into accesslog table: ${error}`);
  return Response.json({ message: `Error while inserting row into accesslog table: ${error.message}` });
}

L

lokiwindOP•5/31/23, 2:01 PM

try {
          await env.DB.prepare(
            "INSERT INTO accesslog (ip, time, path) VALUES (?1, ?2, ?3)"
          ).bind(ip, time, pathname).run();
        } catch (error) {
          console.error(`Error while inserting row into accesslog table: ${error}`);
          return Response.json({ message: `Error while inserting row into accesslog table: ${error.message}` });
        }
      }

try {
          await env.DB.prepare(
            "INSERT INTO accesslog (ip, time, path) VALUES (?1, ?2, ?3)"
          ).bind(ip, time, pathname).run();
        } catch (error) {
          console.error(`Error while inserting row into accesslog table: ${error}`);
          return Response.json({ message: `Error while inserting row into accesslog table: ${error.message}` });
        }
      }

try {
          await env.DB.prepare(
            "INSERT INTO accesslog (ip, time, path) VALUES (?1, ?2, ?3)"
          ).bind(ip, time, pathname).run();
        } catch (error) {
          console.error(`Error while inserting row into accesslog table: ${error}`);
          return Response.json({ message: `Error while inserting row into accesslog table: ${error.message}` });
        }
      }

try {
          await env.DB.prepare(
            "INSERT INTO accesslog (ip, time, path) VALUES (?1, ?2, ?3)"
          ).bind(ip, time, pathname).run();
        } catch (error) {
          console.error(`Error while inserting row into accesslog table: ${error}`);
          return Response.json({ message: `Error while inserting row into accesslog table: ${error.message}` });
        }
      }

@HardAtWork

Llokiwind ```js try { await env.DB.prepare( "INSERT INTO accesslog (...

H

Hello, I’m Allie!•5/31/23, 2:01 PM

Yeah, so add the

any

any

type, and see if it works.

Llokiwind ```js try { await env.DB.prepare( "INSERT INTO accesslog (...

L

lokiwindOP•5/31/23, 2:02 PM

The code is now like this

L

lokiwindOP•5/31/23, 2:02 PM

But error :'error' of type 'unknown'.

Llokiwind The code is now like this

H

Hello, I’m Allie!•5/31/23, 2:03 PM

Yeah, so add the

any

any

type to the catch block like so, and see if it stops throwing that error.

try {
    await env.DB.prepare(
      "INSERT INTO accesslog (ip, time, path) VALUES (?1, ?2, ?3)"
    ).bind(ip, time, pathname).run();
  } catch (error: any) {
    console.error(`Error while inserting row into accesslog table: ${error}`);
    return Response.json({ message: `Error while inserting row into accesslog table: ${error.message}` });
  }
}

try {
    await env.DB.prepare(
      "INSERT INTO accesslog (ip, time, path) VALUES (?1, ?2, ?3)"
    ).bind(ip, time, pathname).run();
  } catch (error: any) {
    console.error(`Error while inserting row into accesslog table: ${error}`);
    return Response.json({ message: `Error while inserting row into accesslog table: ${error.message}` });
  }
}

try {
    await env.DB.prepare(
      "INSERT INTO accesslog (ip, time, path) VALUES (?1, ?2, ?3)"
    ).bind(ip, time, pathname).run();
  } catch (error: any) {
    console.error(`Error while inserting row into accesslog table: ${error}`);
    return Response.json({ message: `Error while inserting row into accesslog table: ${error.message}` });
  }
}

try {
    await env.DB.prepare(
      "INSERT INTO accesslog (ip, time, path) VALUES (?1, ?2, ?3)"
    ).bind(ip, time, pathname).run();
  } catch (error: any) {
    console.error(`Error while inserting row into accesslog table: ${error}`);
    return Response.json({ message: `Error while inserting row into accesslog table: ${error.message}` });
  }
}

L

lokiwindOP•5/31/23, 2:04 PM

Thank you I will try

L

lokiwindOP•5/31/23, 2:07 PM

Problem solved thanks @HardAtWork

M

Murder Chicken•5/31/23, 4:04 PM

Random question. Has anyone found an HTML minifier that works in a CF worker? Most of them fail with missing dependencies like:

  node_modules/clean-css/lib/options/format.js:1:30: ERROR: Could not resolve "os"
  node_modules/clean-css/lib/options/inline-request.js:1:18: ERROR: Could not resolve "url"
  node_modules/clean-css/lib/options/rebase-to.js:1:19: ERROR: Could not resolve "path"
  node_modules/clean-css/lib/reader/apply-source-maps.js:1:17: ERROR: Could not resolve "fs"
  node_modules/clean-css/lib/reader/apply-source-maps.js:2:19: ERROR: Could not resolve "path"

  node_modules/clean-css/lib/options/format.js:1:30: ERROR: Could not resolve "os"
  node_modules/clean-css/lib/options/inline-request.js:1:18: ERROR: Could not resolve "url"
  node_modules/clean-css/lib/options/rebase-to.js:1:19: ERROR: Could not resolve "path"
  node_modules/clean-css/lib/reader/apply-source-maps.js:1:17: ERROR: Could not resolve "fs"
  node_modules/clean-css/lib/reader/apply-source-maps.js:2:19: ERROR: Could not resolve "path"

  node_modules/clean-css/lib/options/format.js:1:30: ERROR: Could not resolve "os"
  node_modules/clean-css/lib/options/inline-request.js:1:18: ERROR: Could not resolve "url"
  node_modules/clean-css/lib/options/rebase-to.js:1:19: ERROR: Could not resolve "path"
  node_modules/clean-css/lib/reader/apply-source-maps.js:1:17: ERROR: Could not resolve "fs"
  node_modules/clean-css/lib/reader/apply-source-maps.js:2:19: ERROR: Could not resolve "path"

  node_modules/clean-css/lib/options/format.js:1:30: ERROR: Could not resolve "os"
  node_modules/clean-css/lib/options/inline-request.js:1:18: ERROR: Could not resolve "url"
  node_modules/clean-css/lib/options/rebase-to.js:1:19: ERROR: Could not resolve "path"
  node_modules/clean-css/lib/reader/apply-source-maps.js:1:17: ERROR: Could not resolve "fs"
  node_modules/clean-css/lib/reader/apply-source-maps.js:2:19: ERROR: Could not resolve "path"

M

Murder Chicken•5/31/23, 4:05 PM

All of the ones I've looked at have similar dependencies.

D

dave•5/31/23, 4:35 PM

Is there a way to match on every path except for one? https://developers.cloudflare.com/pages/platform/headers/

Headers · Cloudflare Pages docs

To attach headers to Cloudflare Pages responses, create a _headers plain text file in the output folder of your project. It is usually the folder that …

D

dave•5/31/23, 4:36 PM

oh I guess I can detach the header for only one path

J

James•5/31/23, 4:36 PM

yeah I'd do a

and then another

!

! rule following to just remove on that one path

D

dave•5/31/23, 4:36 PM

is the limit really only 2,000 chars for the entire file?

J

James•5/31/23, 4:36 PM

each line

D

dave•5/31/23, 4:37 PM

ahhhhh

J

James•5/31/23, 4:37 PM

100 lines

D

dave•5/31/23, 4:37 PM

okay that's more sane

D

dave•5/31/23, 4:37 PM

ah yes I misread it

J

JFSIII•5/31/23, 4:40 PM

Is there any performance (or other) impact on as worker as KV bindings/size increase? I'm about to jump from 1 to 3 KVs (each w/a preview) and while the count and the physical size of the KVs isn't that large now, I realized I didn't know if there was any impact on the worker for adding them. Is startup/response time increased? Are there any thresholds or other guidance around this?

D

dave•5/31/23, 4:40 PM

does

/*

/*

/*

/* match

/hello/whoami

/hello/whoami

/hello/whoami

/hello/whoami?

D

dave•5/31/23, 4:45 PM

answer: looks like yes

JJFSIII Is there any performance (or other) impact on as worker as KV bindings/size incr...

U

Unsmart•5/31/23, 4:50 PM

From 1 -> 3 no. If you have like hundreds and hundreds of bindings then yes it can.

J

JFSIII•5/31/23, 4:53 PM

Thanks! That was my intuition/assumption but I wanted to check. Does the number of entries, or disk size of the KVs have any effect on the worker or the read/write perf of the KV?

U

Unsmart•5/31/23, 4:53 PM

No it doesnt

UUnsmart No it doesnt

J

JFSIII•5/31/23, 4:55 PM

ok, cool. Thanks again!

S

sdan•5/31/23, 5:30 PM

would be nice to have a "sort by requests in last 24 hours"

Screenshot_2023-05-31_at_10.29.53_AM.png

C

Chaika•5/31/23, 5:31 PM

it used to exist, in old workers unconverged

we've asked about it, hopefully will come back soontm

I

ItsWendell•5/31/23, 5:33 PM

Looking to build a system for sending reminders for open payments through push notifications, emails and potentially sms, thinking durable objects and alarms.

Any libraries, systems, readings that come to mind before designing this?

F

Felix || Flow-Like.com•5/31/23, 9:09 PM

has there been a change to how workers calculate initial cpu usage?

F

Felix || Flow-Like.com•5/31/23, 9:09 PM

my functions suddenly dont publish anymore

F

Felix || Flow-Like.com•5/31/23, 9:09 PM

just imports, nothing special, worked before

F

Felix || Flow-Like.com•5/31/23, 9:10 PM

+ didnt touch the imports

F

Felix || Flow-Like.com•5/31/23, 9:10 PM

if I runtime load them all via await import treeshaking wont work and the size will increase a lot...

F

Felix || Flow-Like.com•5/31/23, 9:11 PM

+ probably performance implications

F

Felix || Flow-Like.com•5/31/23, 9:19 PM

this either needs some good debugging utilities or serious rework.. suddenly all ci systems failing without reason is not great.

M

micromashor•5/31/23, 9:45 PM

is there any way to access bindings from the global scope?

F

Felix || Flow-Like.com•5/31/23, 9:47 PM

kind of

F

Felix || Flow-Like.com•5/31/23, 9:49 PM

let scoped : null | bindingType = null;

...
async fetch(env){
if(!scoped) scoped = env.whatever
}

let scoped : null | bindingType = null;

...
async fetch(env){
if(!scoped) scoped = env.whatever
}

let scoped : null | bindingType = null;

...
async fetch(env){
if(!scoped) scoped = env.whatever
}

let scoped : null | bindingType = null;

...
async fetch(env){
if(!scoped) scoped = env.whatever
}

F

Felix || Flow-Like.com•5/31/23, 9:50 PM

thats how I use the global scope for caching things

M

micromashor•5/31/23, 9:50 PM

ah

M

micromashor•5/31/23, 9:51 PM

I'm doing a similar thing, but I was hoping there was a way I could prime the "cache" without waiting for the first request to inevitably miss

F

Felix || Flow-Like.com•5/31/23, 9:51 PM

should not make much of a difference with the cold start times of workers

M

micromashor•5/31/23, 9:52 PM

wdym? (haven't looked at performance numbers much)

F

Felix || Flow-Like.com•5/31/23, 9:54 PM

workers run on lightweight v8 containers (please correct me), not nodejs environments like lambda. Coldstart basically does not exist

F

Felix || Flow-Like.com•5/31/23, 9:55 PM

https://upstash.com/blog/aws-lambda-vs-cloudflare-workers

AWS Lambda vs Cloudflare Workers

Articles and tutorials on serverless technologies from Upstash and community

M

micromashor•5/31/23, 9:55 PM

yeah I noticed that

M

micromashor•5/31/23, 9:55 PM

Coldstart basically does not exist

more curious what you mean by this

F

Felix || Flow-Like.com•5/31/23, 9:56 PM

lambda can be very slow to boot

Similar Threads

Similar Threads

Similar Threads