👋 I'm excited about potentially building my next app fully native on CF. My only blocker is d1's st

I'm excited about potentially building my next app fully native on CF. My only blocker is d1's storage limits. to work around i'd have to support db/customer. my question is making the migration story and dynamically creating dbs more ergonomic on the roadmap?

Aandrew 👋 I'm excited about potentially building my next app fully native on CF. My onl...

Max (@rozenmd)•5/31/24, 8:08 AM

it is indeed on the roadmap - i just (yesterday) drafted the specification for how dynamic bindings and migrations will fit together

Denni•5/31/24, 12:05 PM

Hey all! I'm having some trouble with my D1 database. It looks like it's using a cached result, both using the CLI and in my wrangler and I'm quite unsure why

Denni•5/31/24, 12:05 PM

Denni•5/31/24, 12:05 PM

This is the actual data, as you can see there are total_usages which are much high than what the cli is returning. Am I doing something wrong here? I simply want to get the highest total_usage from the database

Original message was deleted

Denni•5/31/24, 12:06 PM

--remote

--remote

is in there already

Denni•5/31/24, 12:06 PM

My deployed wrangler also returns the same incorrect result

Denni•5/31/24, 12:07 PM

It's also coincidentally the latest result from when I dumped the db yesterday and recreated it (the pack_id column was an INTEGER before, but it's usually above the max_safe_int)

DDenni It's also coincidentally the latest result from when I dumped the db yesterday a...

Max (@rozenmd)•5/31/24, 12:40 PM

are they definitely querying the same database id?

DDenni Hey all! I'm having some trouble with my D1 database. It looks like it's using a...

Matt Silverlock•5/31/24, 12:47 PM

wrangler

wrangler

and/or D1 don't cache results (at all). As Max said: can you confirm it's the same database ID here? Your screenshot shows it starting with 50a19e5e50a19e5e - is that the same DB you're looking at in the dash?

MMax (@rozenmd)are they definitely querying the same database id?

Denni•5/31/24, 12:48 PM

They're both using the same wrangler.toml I'd think

DDenni They're both using the same wrangler.toml I'd think

Matt Silverlock•5/31/24, 12:48 PM

Share it with us (redact anything - but IDs are safe to share) to be sure.

Denni•5/31/24, 12:49 PM

[[d1_databases]]
binding = "USAGE_DB"
database_name = "sticker-usage"
database_id = "50a19e5e-a287-41ea-b908-b27ed1cb4787"

[[d1_databases]]
binding = "USAGE_DB"
database_name = "sticker-usage"
database_id = "50a19e5e-a287-41ea-b908-b27ed1cb4787"

Denni•5/31/24, 12:49 PM

Denni•5/31/24, 12:49 PM

Both the same

Denni•5/31/24, 12:49 PM

The wrangler.toml is in the same directory as where I'm running the wrangler commands from

Matt Silverlock•5/31/24, 12:51 PM

There's no caching (concretely, absolutely, in no way is there result caching) , so I'm curious as to why this is showing different data.

Matt Silverlock•5/31/24, 12:51 PM

Are the row counts the same?

Denni•5/31/24, 12:51 PM

Yeah so am I, anything I can try here to make sure the right things are being queried? Some verbose output of the queries

Max (@rozenmd)•5/31/24, 12:52 PM

can you try run that query in the console tab?

MMatt Silverlock Are the row counts the same?

Denni•5/31/24, 12:52 PM

They are not

MMax (@rozenmd)can you try run that query in the console tab?

Denni•5/31/24, 12:53 PM

I'm sorry, the console tab? My browser console?

DDenni I'm sorry, the console tab? My browser console?

Matt Silverlock•5/31/24, 12:53 PM

In the D1 dashboard [from your screenshot]

Matt Silverlock•5/31/24, 12:53 PM

DDenni I'm sorry, the console tab? My browser console?

Max (@rozenmd)•5/31/24, 12:53 PM

Denni•5/31/24, 12:54 PM

Denni•5/31/24, 12:54 PM

This is the wrong count again

Denni•5/31/24, 12:55 PM

OH I think I get it, I'm querying using WHERE pack_id=... and the new results are numbers(?) so they are not included

Denni•5/31/24, 12:55 PM

If I remove the WHERE the counts do match

Denni•5/31/24, 12:55 PM

But cloudflare shows both data types as the sme even though they are different somehow

Max (@rozenmd)•5/31/24, 12:57 PM

ah that's the trouble with sqlite, even if you specify types, you can insert anything you want

MMax (@rozenmd)ah that's the trouble with sqlite, even if you specify types, you can insert any...

Denni•5/31/24, 1:01 PM

But now I'm hella confused why it is returning the rows where pack_id is a string with

pack_id=371151432834875400

pack_id=371151432834875400

but not where pack_id is a number with the same where clause

Denni•5/31/24, 1:01 PM

:denkpoes_animated:

Denni•5/31/24, 1:01 PM

I'm guessing because the number is larger than max_safe_int?

Denni•5/31/24, 1:05 PM

It's actually that value

Original message was deleted

Denni•5/31/24, 1:17 PM

Also no, you're actually right

Denni•5/31/24, 1:17 PM

In the export it's

371151432834875396

371151432834875396

Denni•5/31/24, 1:22 PM

So it should be all resolved now, thanks for the help all

SSuman!Is anybody aware of this issue? Trying to use d1-dialect causes my tests to fai...

Suman!•5/31/24, 2:09 PM

Folks , any idea here? Appreciate any help here.

Max (@rozenmd)•5/31/24, 3:00 PM

Say you need to delete a few rows of data from a D1 DB - do you use the dashboard UI, dashboard console (SQL), wrangler (SQL) or something else?

MMax (@rozenmd)Say you need to delete a few rows of data from a D1 DB - do you use the dashboar...

...•5/31/24, 3:04 PM

wrangler typing a query

SSuman!Folks , any idea here? Appreciate any help here.

Max (@rozenmd)•5/31/24, 3:17 PM

Original message was deleted

Max (@rozenmd)•5/31/24, 3:19 PM

working on that - we just shipped a query param to let you skip pages (and go back to where you were after modifying data)

MMax (@rozenmd)Say you need to delete a few rows of data from a D1 DB - do you use the dashboar...

Chaika•5/31/24, 3:28 PM

dash console

Original message was deleted

Max (@rozenmd)•5/31/24, 3:43 PM

surprisingly, i'm not seeing it incur any writes when dropping a table, only reads

Max (@rozenmd)•5/31/24, 3:43 PM

not sure if thats a bug

Original message was deleted

Max (@rozenmd)•5/31/24, 3:51 PM

but you'd still have to write a value

Max (@rozenmd)•5/31/24, 3:51 PM

may as well UPDATE lol

Original message was deleted

roftt•5/31/24, 4:41 PM

"In the future, Time Travel will allow you to fork (clone) an existing database into a new database, or overwrite an existing database." https://developers.cloudflare.com/d1/reference/time-travel

But what will the pricing look like for such an operation, and what are the limits, if any?

jepp•6/1/24, 8:17 AM

Hi I am seeing strange behaviour in D1. Inserting two rows of data and the API reporting back 34 rows inserted (and billed)

Jjepp Hi I am seeing strange behaviour in D1. Inserting two rows of data and the API r...

Max (@rozenmd)•6/1/24, 12:27 PM

how many indexes do you have?

👋 I'm excited about potentially building my next app fully native on CF. My only blocker is d1's st

Similar Threads

Similar Threads

Similar Threads