Requests: https://gist.github.com/hlpmenu/fc0a95f514a824a6b4e937a2169f306a Tried with a new db too.

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 Silverlock•7/3/24, 4:24 AM

Without the contents of the

cf

cf

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_timestampdefault 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 INTEGERINTEGER 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 infowrangler 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 offsettoo 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?

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

seems crazy I can't just insert 30 rows

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

do I need to do one by one?

oof2win2•7/5/24, 1:26 PM

so if you have over 10 columns you cant insert a row?

Vikash•7/6/24, 4:07 AM

What is offsetoffset in errors ?

I have just 100 lines in my insert file and it errors with message syntax error at offset 245syntax error at offset 245 On what line I should look for the error to correct it.

Unsmart•7/6/24, 4:14 AM

character 245

UUnsmart character 245

Vikash•7/6/24, 4:17 AM

Got it, thanks.

Vikash•7/6/24, 10:10 AM

New error: {"D1_RESET_DO":true}{"D1_RESET_DO":true} Any idea what is this?

Requests: https://gist.github.com/hlpmenu/fc0a95f514a824a6b4e937a2169f306a Tried with a new db too.

Similar Threads

Similar Threads

Similar Threads