I also don’t understand if you are saying the curl works or not. Does it work?

MMatt Silverlock I also don’t understand if you are saying the curl works or not. Does it work?

Oli•7/2/24, 11:07 PM

Sorry, i was a bit unclear, curl does not work..
What i meant was that every endpoint works, except query and raw.

wrangler d1 list shows all listed db:s.
I got the id from the dashboard to make sure wrangler was not outputting any local uuids.

The db id, db name ia all set by env vars.

OOli Sorry, i was a bit unclear, curl does not work.. What i meant was that every en...

Matt SilverlockOP•7/2/24, 11:12 PM

Set them directly, just to remove any env var expansion mistakes.

OOli Sorry, i was a bit unclear, curl does not work.. What i meant was that every en...

Matt SilverlockOP•7/2/24, 11:13 PM

It’s also unclear why curl doesn’t work. What error?

Matt SilverlockOP•7/2/24, 11:13 PM

My suggestion:

1. Get the basic curl working first.
2. Then you can move to env vars
3. Then your Go app.

Oli•7/2/24, 11:23 PM

I think you misunderstood, no method works, the error is the api response:
"message": "The request is malformed: failed to decode id"

Nope, tried it multiple times now, including removing any linebreaks, same issue.

The response is:
{
"result": null,
"success": false,
"errors": [
{
"code": 7400,
"message": "The request is malformed: failed to decode id"
}
],
"messages": []
}

Oli•7/3/24, 12:11 AM

Ok, so i managed to get it to work, but not with that db..?

Its super inconstent..

il sanitize some logs and upload

Oli•7/3/24, 12:38 AM

Requests:
https://gist.github.com/hlpmenu/fc0a95f514a824a6b4e937a2169f306a

Tried with a new db too.
Same thing, works for those, not for that one.
Obviosly doublechecked id with both wrangler and dashboard

Gist

req.log

GitHub Gist: instantly share code, notes, and snippets.

OOli Requests: https://gist.github.com/hlpmenu/fc0a95f514a824a6b4e937a2169f306a Trie...

Matt SilverlockOP•7/3/24, 4:24 AM

Without the contents of the cfcf script or the database ID there’s not much we can do to help. Are you running an old alpha database at all? (see the docs for instructions on how to discern)

I suggest opening an issue on the workers-sdk repo with the database ID (which is safe to post publicly), account ID, and your script exactly as you are running it.

Otherwise - flying blind.

temporaryatearth•7/3/24, 8:43 AM

is the type TIMESTAMP really a timestamp without timezone? I would have to use this to check records several minutes later after they are created

temporaryatearth•7/3/24, 8:43 AM

since I can't find documents on what data types that D1 supports.

Ttemporaryatearth is the type TIMESTAMP really a timestamp without timezone? I would have to use t...

Max (@rozenmd)•7/3/24, 8:43 AM

TIMESTAMP isn't an sqlite type, i'm guessing this is a library on top of D1?

Ttemporaryatearth since I can't find documents on what data types that D1 supports.

Max (@rozenmd)•7/3/24, 8:44 AM

https://www.sqlite.org/datatype3.html

temporaryatearth•7/3/24, 8:44 AM

I don't know, i created the table with a

default current_timestamp

default current_timestamp

and it is working well

Max (@rozenmd)•7/3/24, 8:45 AM

If the default value of a column is CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP, then the value used in the new row is a text representation of the current UTC date and/or time. For CURRENT_TIME, the format of the value is "HH:MM:SS". For CURRENT_DATE, "YYYY-MM-DD". The format for CURRENT_TIMESTAMP is "YYYY-MM-DD HH:MM:SS".

from https://www.sqlite.org/lang_createtable.html

temporaryatearth•7/3/24, 8:47 AM

OK, I think it is better to use

INTEGER

INTEGER

and maintain the value by code logic..

temporaryatearth•7/3/24, 8:47 AM

thank you @Max (@rozenmd)

maguayo•7/4/24, 7:37 AM

I have an SQLite on my VPS. Can I create an script or something to push my whole database (50MB) to Coudflare D1? That way having a similar version in the edge as kind of cache?

Mmaguayo I have an SQLite on my VPS. Can I create an script or something to push my whole...

Hard@Work•7/4/24, 9:12 AM

Maybe do an initial sync, then mirror all commands to the local SQLite db to D1?

WillTolmie•7/4/24, 10:17 AM

Strange one this - my worker still seems to have access to a deleted database. I was wondering why my API was working fine (new rows being added and being queried fine) but new rows weren't showing in the CF dashboard

WillTolmie•7/4/24, 10:17 AM

I tried D1 export from the root of the worker via wrangler and it complained the database didn't exist

WillTolmie•7/4/24, 10:20 AM

Then I realised I hadn't updated the D1 binding with the new ID

WillTolmie•7/4/24, 10:21 AM

But it still works!

WillTolmie•7/4/24, 10:50 AM

anyway FWIW the deleted months ago db id is 8001ccc4-1a33-435e-bbb5-7d8723a3a58a

Original message was deleted

boop•7/4/24, 4:56 PM

No replication at the moment, your db sits where you put it and stays there

boop•7/4/24, 4:59 PM

Yup, it's one of the features that they're planning on rolling out :soontm:

boop•7/4/24, 5:01 PM

I don't think they have ever set a date in stone for any of the features, it's just a waiting game

HHello, I’m Allie!Afaik it isn’t available in any capacity atm

boop•7/4/24, 5:02 PM

Judging by this message though I wouldn't keep your hopes on it coming soon

boop•7/4/24, 5:03 PM

But yes, workers is a completely separate product and is in every available DC

Original message was deleted

boop•7/4/24, 5:03 PM

You could try your luck with smart placement, although CloudFlare often times still gets the location wrong

boop•7/4/24, 5:04 PM

Sorry for tagging you HardlyWorking, I meant to just quote your message

Bboop Judging by this message though I wouldn't keep your hopes on it coming soon

Hello, I’m Allie!•7/4/24, 5:04 PM

Note, this was said in my capacity as a community member

Hello, I’m Allie!•7/4/24, 5:04 PM

And thus I can’t speak to when exactly this feature may or may not be coming

boop•7/4/24, 5:04 PM

Gotcha, I misunderstood your orange CloudFlare role

Bboop Gotcha, I misunderstood your orange CloudFlare role

Hello, I’m Allie!•7/4/24, 5:05 PM

Yeah, it can be a tad confusing, sorry for adding to it. I’m on the #r2 team, but even questions around R2 I am not 100% knowledgeable

Original message was deleted

Hello, I’m Allie!•7/4/24, 5:06 PM

KV is replicated US/EU. R2 isn’t replicated yet, but you can do manually replication by copying between buckets in different regions

Original message was deleted

boop•7/4/24, 5:06 PM

KV is replicated, it's just a key-value store though

Original message was deleted

boop•7/4/24, 5:09 PM

KV is pretty dang expensive

boop•7/4/24, 5:10 PM

Besides, even without replication, on single-query database operations D1 is pretty speedy

Original message was deleted

boop•7/4/24, 5:18 PM

You're battling the speed of light here unfortunately

boop•7/4/24, 5:18 PM

In the known universe that is currently unachievable

boop•7/4/24, 5:21 PM

They do have Argo, not sure if they implement it in the worker to d1 communication though

Bboop They do have Argo, not sure if they implement it in the worker to d1 communicati...

Chaika•7/4/24, 5:24 PM

it'd help inbound (ent like inbound routing), but shouldn't matter for communication to D1 afaik. Smart Placement can help though, by making your worker run close

engi.dev•7/4/24, 11:19 PM

Hello everyone
I am using free account. I have deployed my next.js project on cloudflare D1.
I tried many times, but they said that project was deployed successfully then I can't see website.
I dont know that 's why.
if someone knows this error. pls messag me.

SteffTek•7/5/24, 5:19 AM

Can we check where our d1 database is created?

SteffTek•7/5/24, 5:19 AM

ive used terraform to instantiate it and we cannot give a location hint there

SteffTek•7/5/24, 5:23 AM

and the "message wait time" settings say 0-60, but you cannot actually set it to 0

Eengi.dev Hello everyone I am using free account. I have deployed my next.js project on cl...

harshil1712•7/5/24, 9:19 AM

Hey, answered on your thread

SSteffTek Can we check where our d1 database is created?

harshil1712•7/5/24, 9:22 AM

You can use the

wrangler d1 info

wrangler d1 info

command. https://developers.cloudflare.com/workers/wrangler/commands/#info

Cloudflare Docs

Commands - Wrangler · Cloudflare Workers docs

Create, develop, and deploy your Cloudflare Workers with Wrangler commands.

Hharshil1712 You can use the `wrangler d1 info` command. https://developers.cloudflare.com/wo...

SteffTek•7/5/24, 9:26 AM

thanks, looks like my databases are running in WNAM... great for european users /s

cosbgn•7/5/24, 11:31 AM

hey I'm getting a lot of

too many SQL variables at offset

too many SQL variables at offset

seems d1 supports only 10 parameters, so even simple inserts like this will fail:

const sqlite = new Database("db.sqlite");

const db = drizzle<typeof schema>(sqlite, { schema });

const books = new Array(35).fill({}).map((b, i) => ({
  id: i.toString(),
  title: "The Great Gatsby",
  description: "A book about a rich guy",
}));

await db.insert(schema.books).values(books);

const sqlite = new Database("db.sqlite");

const db = drizzle<typeof schema>(sqlite, { schema });

const books = new Array(35).fill({}).map((b, i) => ({
  id: i.toString(),
  title: "The Great Gatsby",
  description: "A book about a rich guy",
}));

await db.insert(schema.books).values(books);

Is there any workaround?

const sqlite = new Database("db.sqlite"); const db = drizzle<typeof schema>(sqlite, { schema }); const books = new Array(35).fill({}).map((b, i) => ({ id: i.toString(), title: "The Great Gatsby", description: "A book about a rich guy", })); await db.insert(schema.books).values(books);

I also don’t understand if you are saying the curl works or not. Does it work?

Similar Threads

Similar Threads

Similar Threads