Is anybody aware of this issue? Trying to use d1-dialect causes my tests to fail with- ```TypeError

Is anybody aware of this issue? Trying to use d1-dialect causes my tests to fail with-

TypeError: Cannot use require() to import an ES Module.

TypeError: Cannot use require() to import an ES Module.

TypeError: Cannot use require() to import an ES Module.

TypeError: Cannot use require() to import an ES Module.

https://github.com/aidenwallis/kysely-d1/issues/27 . Please help.

GitHub

Using D1Dialect causes worker tests to fail - Cannot use require() ...

Initializing D1Dialect causes my tests to not run as expected. private async initializeDb(db: D1Database) { this.db = new Kysely<Database>({ dialect: new D1Dialect({ database: db }), }); } Ha...

andrew•5/31/24, 7:56 AM

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=371151432834875400pack_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 371151432834875396371151432834875396

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!OP•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)

Is anybody aware of this issue? Trying to use d1-dialect causes my tests to fail with- ```TypeError

Similar Threads

Similar Threads

Similar Threads