what does GA mean? - Cloudflare Developers

© 2026 Hedgehog Software, LLC

More

Communities Docs About Terms Privacy

bun

Bbun what does GA mean?

Unsmart

U

Unsmart•2/27/24, 9:55 PM

generally available aka production ready

bun

B

bunOP•2/27/24, 9:56 PM

so they just mean that those features will be available once its production ready ? like not in beta?

Unsmart

U

Unsmart•2/27/24, 9:56 PM

Yes, and its more of a plan to have them so it might be ready might be after

bun

B

bunOP•2/27/24, 9:57 PM

ok but why does this not work

await this.db.batch([
      this.db.insert(blobs).values({ hash: blobHash }),
      this.db
        .insert(assets)
        .values({ projectId, blobId: sql`last_insert_rowid()` })
        .returning({ assetId: assets.id }),
    ]);

await this.db.batch([
      this.db.insert(blobs).values({ hash: blobHash }),
      this.db
        .insert(assets)
        .values({ projectId, blobId: sql`last_insert_rowid()` })
        .returning({ assetId: assets.id }),
    ]);

[cause]: Error: FOREIGN KEY constraint failed [cause]: Error: FOREIGN KEY constraint failed
like what

Unsmart

U

Unsmart•2/27/24, 9:57 PM

No clue I dont use SQL

bun

B

bunOP•2/27/24, 9:57 PM

what do you use then

Unsmart

U

Unsmart•2/27/24, 9:57 PM

On cloudflare I use durable objects :NODDER:

bun

B

bunOP•2/27/24, 10:00 PM

idk i couuldnt ever get used to workin with durable objects. they seem great at first but even for a simple key value store i have to write a class? like what

bun

B

bunOP•2/27/24, 10:01 PM

yeah its probably the blobIdblobId, but shouldnt last_insert_rowid()last_insert_rowid() return the

id

id

of the latest inserted blobblob ? as in the first batch statement?

bun

B

bunOP•2/27/24, 10:02 PM

bun

B

bunOP•2/27/24, 10:03 PM

do you prefer raw sql ?

bun

B

bunOP•2/27/24, 10:03 PM

CREATE TABLE `assets` (
    `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
    `ref_count` integer DEFAULT 1 NOT NULL,
    `blob_id` integer NOT NULL,
    `user_id` integer NOT NULL,
    `created_at` integer DEFAULT (CURRENT_TIMESTAMP) NOT NULL,
    FOREIGN KEY (`blob_id`) REFERENCES `blobs`(`id`) ON UPDATE cascade ON DELETE restrict,
    FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON UPDATE cascade ON DELETE restrict
);

CREATE TABLE `blobs` (
    `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
    `hash` text NOT NULL
);

CREATE TABLE `assets` (
    `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
    `ref_count` integer DEFAULT 1 NOT NULL,
    `blob_id` integer NOT NULL,
    `user_id` integer NOT NULL,
    `created_at` integer DEFAULT (CURRENT_TIMESTAMP) NOT NULL,
    FOREIGN KEY (`blob_id`) REFERENCES `blobs`(`id`) ON UPDATE cascade ON DELETE restrict,
    FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON UPDATE cascade ON DELETE restrict
);

CREATE TABLE `blobs` (
    `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
    `hash` text NOT NULL
);

bun

B

bunOP•2/27/24, 10:06 PM

hm

bun

B

bunOP•2/27/24, 10:07 PM

ah ye. i renamed the column to project_id without changing the reference. i will fix that and see if the issue's still thare

Beyondo

B

Beyondo•2/28/24, 2:33 PM

Hello! Is it an expected behavior for an UPDATE query to always take 1 rows_read?

Beyondo

BBeyondo Hello! Is it an expected behavior for an UPDATE query to always take 1 rows_read...

Max (@rozenmd)

M

Max (@rozenmd)•2/28/24, 3:05 PM

Is it just an UPDATE, or perhaps an UPDATE ... RETURNING *UPDATE ... RETURNING *?

Mongy

M

Mongy•2/28/24, 3:45 PM

Anyone here have made API calls to a D1 instance to query the db?

The error im receiving: The request is malformed: failed to decode idThe request is malformed: failed to decode id

url: https://api.cloudflare.com/client/v4/accounts/{account_id}/d1/database/{db_id}/queryhttps://api.cloudflare.com/client/v4/accounts/{account_id}/d1/database/{db_id}/query

const insertStatement = `INSERT INTO table (column1, column2) VALUES ('value1', 'value2');`;

const insertStatement = `INSERT INTO table (column1, column2) VALUES ('value1', 'value2');`;

const options = {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
      Authorization: 'Bearer {api_token}'
    },
    body: `{"sql": ${insertStatement}`
  }

const options = {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
      Authorization: 'Bearer {api_token}'
    },
    body: `{"sql": ${insertStatement}`
  }

I'm not exactly where to go from here unfortunately. Any assistance would be greatly appreciated.

kian

K

kian•2/28/24, 3:46 PM

Are you sure

db_id

db_id

is right?

kian

K

kian•2/28/24, 3:46 PM

You're also missing a closing bracket in your bodybody from the looks of it

Mongy

M

Mongy•2/28/24, 3:46 PM

copied straight from the d1 instance

kian

K

kian•2/28/24, 3:47 PM

the AuthorizationAuthorization header also doesn't seem to be actually interpolating the api_tokenapi_token variable

Mongy

M

Mongy•2/28/24, 3:48 PM

ive tried using X-Auth-KeyX-Auth-Key but i get an error that it doesn't exist in the request

kian

Kkian You're also missing a closing bracket in your `body` from the looks of it

Mongy

M

Mongy•2/28/24, 3:48 PM

that's embarresing. Added the bracket but the error still persists

kian

K

kian•2/28/24, 3:48 PM

It's probably an issue with the URL path or the API token

kian

K

kian•2/28/24, 3:49 PM

What did you put in for

account_id

account_id

and

db_id

db_id

? They're not sensitive.

Mongy

M

Mongy•2/28/24, 3:49 PM

Account id:

4f6d1970bc967b2c2a90b643bbb5ac94

4f6d1970bc967b2c2a90b643bbb5ac94

db id:

0e35121-f3cc-4e24-b5c1-4d758860a69d

0e35121-f3cc-4e24-b5c1-4d758860a69d

Mongy

M

Mongy•2/28/24, 3:50 PM

permissions for api token has read and write for D1

kian

K

kian•2/28/24, 3:50 PM

Does the URL look correct if you

console.log

console.log

it?

Mongy

M

Mongy•2/28/24, 3:52 PM

looks good

https://api.cloudflare.com/client/v4/accounts/4f6d1970bc967b2c2a90b643bbb5ac94/d1/database/0e35121-f3cc-4e24-b5c1-4d758860a69d/query

https://api.cloudflare.com/client/v4/accounts/4f6d1970bc967b2c2a90b643bbb5ac94/d1/database/0e35121-f3cc-4e24-b5c1-4d758860a69d/query

kian

K

kian•2/28/24, 3:53 PM

and if you log

options

options

then you see

Authorization: Bearer ...

Authorization: Bearer ...

?

Mongy

M

Mongy•2/28/24, 3:53 PM

the account id came from the pages/workers overview dashboard

kian

K

kian•2/28/24, 3:53 PM

It all seems fine, the error is pretty vague.

Mongy

M

Mongy•2/28/24, 3:53 PM

yes i see the bearer when logging

kian

Kkian It all seems fine, the error is pretty vague.

Mongy

M

Mongy•2/28/24, 3:54 PM

Yeah that's why I've come here to see if anyone has experienced something similar. It is offly vague

Original message was deleted

Mongy

M

Mongy•2/28/24, 4:11 PM

the uuid matches to what im putting in the url

Original message was deleted

Mongy

M

Mongy•2/28/24, 4:19 PM

Still receiving the same message

Mongy

M

Mongy•2/28/24, 4:22 PM

const D1URL = 'https://api.cloudflare.com/client/v4/accounts/4f6d1970bc967b2c2a90b643bbb5ac94/d1/database/0e35121-f3cc-4e24-b5c1-4d758860a69d/query';

const insertStatement = `INSERT INTO table (c1, c2, c3) VALUES (v1, v2, v3)`;

const options = {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
      Authorization: 'Bearer GAQjclxUayPOaHhn5Nx1CGdyN2Pt08COkmFTFBjm'
    },
    body: JSON.stringify({
      sql: insertStatement
    })
  }

fetch(D1URL, options)
    .then( res => res.json())
    .then( data => console.log(data))

const D1URL = 'https://api.cloudflare.com/client/v4/accounts/4f6d1970bc967b2c2a90b643bbb5ac94/d1/database/0e35121-f3cc-4e24-b5c1-4d758860a69d/query';

const insertStatement = `INSERT INTO table (c1, c2, c3) VALUES (v1, v2, v3)`;

const options = {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
      Authorization: 'Bearer GAQjclxUayPOaHhn5Nx1CGdyN2Pt08COkmFTFBjm'
    },
    body: JSON.stringify({
      sql: insertStatement
    })
  }

fetch(D1URL, options)
    .then( res => res.json())
    .then( data => console.log(data))

Mongy

M

Mongy•2/28/24, 4:23 PM

just simplified the insert statement

Mongy

M

Mongy•2/28/24, 4:24 PM

already did when i realized lol

Mongy

M

Mongy•2/28/24, 4:25 PM

but the api token has both read and write permissions for d1 instance

Mongy

M

Mongy•2/28/24, 4:25 PM

they are actual strings

Mongy

M

Mongy•2/28/24, 4:25 PM

i just renamed them

Mongy

M

Mongy•2/28/24, 4:26 PM

i ran the same sql directly through the d1 dashboard

Mongy

M

Mongy•2/28/24, 4:26 PM

and populated just fine

Mongy

M

Mongy•2/28/24, 4:26 PM

same one im using in this script, not the one i posted here

Mongy

M

Mongy•2/28/24, 4:27 PM

its an id problem but its not specifying what id its trying to decode

kian

K

kian•2/28/24, 4:30 PM

Your DB ID is wrong

kian

K

kian•2/28/24, 4:30 PM

It isn't formatted properly

kian

K

kian•2/28/24, 4:30 PM

Yeah

kian

K

kian•2/28/24, 4:30 PM

It's 7-4-4-4-12 when it should be 8-4-4-4-12

const D1URL = 'https://api.cloudflare.com/client/v4/accounts/4f6d1970bc967b2c2a90b643bbb5ac94/d1/database/0e35121-f3cc-4e24-b5c1-4d758860a69d/query';

const insertStatement = `INSERT INTO table (c1, c2, c3) VALUES (v1, v2, v3)`;

const options = {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
      Authorization: 'Bearer GAQjclxUayPOaHhn5Nx1CGdyN2Pt08COkmFTFBjm'
    },
    body: JSON.stringify({
      sql: insertStatement
    })
  }

fetch(D1URL, options)
    .then( res => res.json())
    .then( data => console.log(data))

const D1URL = 'https://api.cloudflare.com/client/v4/accounts/4f6d1970bc967b2c2a90b643bbb5ac94/d1/database/0e35121-f3cc-4e24-b5c1-4d758860a69d/query';

const insertStatement = `INSERT INTO table (c1, c2, c3) VALUES (v1, v2, v3)`;

const options = {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
      Authorization: 'Bearer GAQjclxUayPOaHhn5Nx1CGdyN2Pt08COkmFTFBjm'
    },
    body: JSON.stringify({
      sql: insertStatement
    })
  }

fetch(D1URL, options)
    .then( res => res.json())
    .then( data => console.log(data))

await this.db.batch([
      this.db.insert(blobs).values({ hash: blobHash }),
      this.db
        .insert(assets)
        .values({ projectId, blobId: sql`last_insert_rowid()` })
        .returning({ assetId: assets.id }),
    ]);

await this.db.batch([
      this.db.insert(blobs).values({ hash: blobHash }),
      this.db
        .insert(assets)
        .values({ projectId, blobId: sql`last_insert_rowid()` })
        .returning({ assetId: assets.id }),
    ]);

CREATE TABLE `assets` (
    `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
    `ref_count` integer DEFAULT 1 NOT NULL,
    `blob_id` integer NOT NULL,
    `user_id` integer NOT NULL,
    `created_at` integer DEFAULT (CURRENT_TIMESTAMP) NOT NULL,
    FOREIGN KEY (`blob_id`) REFERENCES `blobs`(`id`) ON UPDATE cascade ON DELETE restrict,
    FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON UPDATE cascade ON DELETE restrict
);

CREATE TABLE `blobs` (
    `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
    `hash` text NOT NULL
);

CREATE TABLE `assets` (
    `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
    `ref_count` integer DEFAULT 1 NOT NULL,
    `blob_id` integer NOT NULL,
    `user_id` integer NOT NULL,
    `created_at` integer DEFAULT (CURRENT_TIMESTAMP) NOT NULL,
    FOREIGN KEY (`blob_id`) REFERENCES `blobs`(`id`) ON UPDATE cascade ON DELETE restrict,
    FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON UPDATE cascade ON DELETE restrict
);

CREATE TABLE `blobs` (
    `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
    `hash` text NOT NULL
);