does D1 binding act like a VPC? Some people suggest putting our databases inside a VPC for security

does D1 binding act like a VPC? Some people suggest putting our databases inside a VPC for security reasons, so that the databases are not accessible through the internet.

MrinankOP•5/30/24, 6:11 PM

and can we expose our database_id in git publically?

MMrinank does D1 binding act like a VPC? Some people suggest putting our databases inside...

Hello, I’m Allie!•5/30/24, 6:18 PM

All bindings are only accessible on your account, yes

Hello, I’m Allie!•5/30/24, 6:18 PM

So it is safe to publish to git

Suman!•5/31/24, 7:28 AM

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.

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

wranglerwrangler 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