Cloudflare Developers•3y ago

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.com•8/26/23, 11:32 AM

yes.

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

(12 bits).

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