I get this error tho: TypeError: env.clickDB.put is not a function - Cloudflare Developers

© 2026 Hedgehog Software, LLC

More

Communities Docs About Terms Privacy

rob

Rrob I get this error tho: TypeError: env.clickDB.put is not a function

itsmatteomanf

I

itsmatteomanf•8/26/23, 1:06 AM

Because it's not

itsmatteomanf

I

itsmatteomanf•8/26/23, 1:06 AM

Read the docs.
https://developers.cloudflare.com/d1/platform/client-api/

D1 client API · Cloudflare D1 docs

As part of our Client API, both static and prepared statements are supported. Best practice is to use prepared statements which are precompiled …

rob

R

robOP•8/26/23, 1:06 AM

oo

rob

R

robOP•8/26/23, 1:06 AM

Oh

rob

R

robOP•8/26/23, 1:07 AM

got it

chientrm.com

C

chientrm.com•8/26/23, 8:50 AM

Although I only have 12 users registered,
How would you recommend me to implement Snowflake Ids with multiple D1 databases binded?

chientrm.com

C

chientrm.com•8/26/23, 8:51 AM

Replace

Worker ID

Worker ID

with

DatabaseId

DatabaseId

?

chientrm.com

Cchientrm.com Although I only have 12 users registered, How would you recommend me to implemen...

Matt Silverlock

M

Matt Silverlock•8/26/23, 11:22 AM

Generate it in your app at insert time? Do you want to use it as the primary key column?

Matt Silverlock

MMatt Silverlock Generate it in your app at insert time? Do you want to use it as the primary key...

chientrm.com

C

chientrm.com•8/26/23, 11:32 AM

yes.

chientrm.com

C

chientrm.com•8/26/23, 11:36 AM

so there are

timestamp

timestamp

,

worker_id

worker_id

and

sequence_id

sequence_id

.
Because

sequence_id

sequence_id

is autoincrement and reset to 0 when it touch the highest value

(12 bits).

chientrm.com

C

chientrm.com•8/26/23, 11:36 AM

I can't find an sql function implementation for

snowflake_id(worker_id)

snowflake_id(worker_id)

chientrm.com

C

chientrm.com•8/26/23, 11:38 AM

and idk how to

kian

K

kian•8/26/23, 3:05 PM

https://github.com/cloudflare/workers-sdk/blob/main/packages/wrangler/src/deployment-bundle/create-worker-upload-form.ts, https://developers.cloudflare.com/cloudflare-for-platforms/workers-for-platforms/get-started/configuration/#4-upload-user-workers-to-a-namespace and https://developers.cloudflare.com/cloudflare-for-platforms/workers-for-platforms/platform/metadata/ are the best references for the Upload Worker API

kian

K

kian•8/26/23, 3:07 PM

Wrangler is effectively the source of truth for that API.

kian

K

kian•8/26/23, 3:23 PM

You can just do it all with

publish

publish

and CLI flags

kian

K

kian•8/26/23, 3:24 PM

Well,

deploy

deploy

now

kian

K

kian•8/26/23, 3:25 PM

I would recommend it - iirc they'll eventually provide a

deploy

deploy

API similar to https://developers.cloudflare.com/workers/wrangler/api/#unstable_dev so you can just do stuff like

import { deploy } from "wrangler";

import { deploy } from "wrangler";

and do it in JS but currently the CLI is the best way

kian

K

kian•8/26/23, 3:26 PM

It'll figure it out based on the JS file having a default export

kian

K

kian•8/26/23, 4:22 PM

keep-vars

keep-vars

is only for

[vars]

[vars]

kian

K

kian•8/26/23, 4:23 PM

I was under the impression that

deploy

deploy

had

--kv

--kv

/

--r2

--r2

/etc but it doesn't seem to

josh025

J

josh025•8/26/23, 4:36 PM

Trying to check to see the possibilities of heirs again in one x15. See if there’s any correlation between negative cloud fare in positive affirmation.

Matt Silverlock

MMatt Silverlock Generate it in your app at insert time? Do you want to use it as the primary key...

chientrm.com

C

chientrm.com•8/26/23, 10:06 PM

I mean, I'm running app on Workers as well so that there's no place to store

sequence_id

sequence_id

.

Ian

I

Ian•8/27/23, 12:58 AM

is the 500MB table size a hard limit atm ?

Ian

I

Ian•8/27/23, 12:58 AM

Looking for at least 10GB Copium

Copium

Ian

IIan Looking for at least 10GB <:Copium:839843826650972182>

chientrm.com

C

chientrm.com•8/27/23, 1:07 AM

maybe snowflake id can help you by spliting data into multiple database (500 MB each)

Ian

IIan is the 500MB table size a hard limit atm ?

Cyb3r-Jak3

C

Cyb3r-Jak3•8/27/23, 1:08 AM

It is a DB size not table size. Right now it is a hard limit and only reported increase size is to 1 GB per DB

chientrm.com

Cchientrm.com maybe snowflake id can help you by spliting data into multiple database (500 MB ...

Ian

I

Ian•8/27/23, 1:09 AM

It's .. gonna be a pain, I have to bind every db

Cyb3r-Jak3

CCyb3r-Jak3 It is a DB size not table size. Right now it is a hard limit and only reported i...

Ian

I

Ian•8/27/23, 1:09 AM

yikes ...

Ian

IIan It's .. gonna be a pain, I have to bind every db

chientrm.com

C

chientrm.com•8/27/23, 1:09 AM

you can bind databases into an array

Ian

I

Ian•8/27/23, 1:10 AM

max is 10

Ian

chientrm.com

C

chientrm.com•8/27/23, 1:10 AM

is the 10GB required by now or in the future?

Ian

I

Ian•8/27/23, 1:11 AM

now I need at least 3gb, and it is expected to grow to 100gb+ in the future

Ian

I

Ian•8/27/23, 1:11 AM

sweatguy