Although I only have 12 users registered, How would you recommend me to implement Snowflake Ids with

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

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

Replace Worker IDWorker ID with DatabaseIdDatabaseId?

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

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?

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

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

yes.

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

so there are

timestamp

timestamp

, worker_idworker_id and sequence_idsequence_id.
Because sequence_idsequence_id is autoincrement and reset to 0 when it touch the highest value 40964096 (12 bits).

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

I can't find an sql function implementation for snowflake_id(worker_id)snowflake_id(worker_id)

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

and idk how to

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•8/26/23, 3:07 PM

Wrangler is effectively the source of truth for that API.

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

You can just do it all with

publish

publish

and CLI flags

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

Well,

deploy

deploy

now

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•8/26/23, 3:26 PM

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

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

keep-varskeep-vars is only for [vars][vars]

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•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.

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

chientrm.comOP•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_idsequence_id.