Use Node v16 and run

npm add --no-save better-sqlite3

. We need

better-sqlite3

to local dev D1. However, don't add

better-sqlite3

to

package.json

because Pages will try to install it on deployment which will throw an error.

and don't forget to seed your sqlite DB as the doc mentions.

None of that is anything to do with the error they're getting?

It's just that

pages dev

doesn't use your production database because it runs it locally with miniflare - meaning you'll need to make the table locally too

So you need

--persist

in your pages dev command to use the file system, not an in-memory database, and then

wrangler d1 execute --local

can help your create your tables locally

thanks it worked

Does anyone have a guide or article on automated testing for functions. I'm using Jest.

I'm working on one. tl;dr; Use vitest or Jest with the miniflare plugin. https://miniflare.dev/testing/jest

However, since each Function is not a full worker, you have to load it and test it in isoation. Compose a Request Object -- the Jest-miniflare environment gives you that. Import your Function and call it's handler. It gives you isolated storage for KV, D1, and Durable Objects. If you have everything configured right,

getMiniflareBindings()

will give you the env parameter for your call to the handler. You'll have to compose your own params parameter for the handler call from your test.

There are a few more details, but that should be enough to get you started.

Hi guys! I develop an e-commerce app with a payment gateway integration. At some point payment gateway sends payment status to the Cloudflare serverless function. But this request fails with the following error:

code (ERROR): 403, Response: "error code: 1010"

. Can somebody help me to resolve the issue?

Larry, thank you for the response. How close are you with the article? There are a bunch of questions on this. Do you have any code snippets, especially in Typescript?

Hi everyone new here and having some problems with functions middleware. I have a file described but I can hit the endpoint without a log statement in the middleware firing. I tried different variations of directory structure and exports but nothing 😦

So I have a function that works localy - i.e. when I run

wrangler pages dev out

but fails when I deploy to production. What's the best way to go about debugging this?

hi i'm new to pages. but i'm currently using next.js, is it better to move all apis into workers / functions ? currently, next.js defines api conventions. sometimes i can't tell whether i should use worker or use apis in nextjs. especially for those involves pure data access.

It is better to not use next.js with cf pages

That depends on your requirements. Cons:

next-on-pages

has some outstanding issues right now, and isn't given as much attention as e.g. someone like Vercel would. It works but it's not as integrated into the platform as competitors. Pros: Pages is free, and Functions pricing (what

next-on-pages

runs on) is much cheaper than competitors.

If you need more help making a decision you can look at the

next-on-pages

Github issues to see if any apply to you: https://github.com/cloudflare/next-on-pages/issues

Hi everyone. Is it possible to use _routes.json to specify a file extension that should be ignored. I'm trying to put my .spec.ts test files next to my functions.

Hi, is there any way I can use remote mysql database with prisma?

If a file in the Functions folder doesn't export

onRequest

,

onRequestGet

,

onRequestPost

, etc, it will be ignored.

Is it possible to custom esbuild options for functions ?

Natively, only what is available on the CLI. Otherwise, you can invoke ESBuild yourself, and then use Advanced Mode

Static pages are fine but SSR apps that rely on the nodejs eco-system is not supported today.

Are the preview bindings shared across all non-main branch prs? Is there a way to have different bindings in different prs, like having a different environment per pr much like workers can have multiple environments?

Multiple envs are not supported today unfortunately

Or I can esbuild myself with

bundle: false

I think

Okay cool, thanks

any idea why I'd get a 405 when trying to hit a function defined with

onRequestPost

using a

fetch()

with method set to

POST

?

Sounds like you aren't hitting the function