Cloudflare Developers•2y ago

preview_database_id is used when wrangler dev --remote is used, and is a real D1 DB -- just only us

preview_database_id is used when wrangler dev --remote is used, and is a real D1 DB -- just only used in dev

CChaika preview_database_id is used when wrangler dev --remote is used, and is a real D...

ALECKS•1/9/24, 9:49 PM

I see, so sharing state with other devs would be a usecase

MMatt Silverlock Keep in mind that each Dynamo replica adds to your storage costs + adds addition...

Negative•1/10/24, 2:24 AM

Sorry to bring up an old convo... but I'm curious if there will be options to disable replication? Say I only want my data to stay in the EU? I know there is an entire data privacy suite dedicated to this stuff, but we're trying to start off a bit smaller than enterprise if possible.

K•1/10/24, 5:13 AM

There are location hints but there is no mentioning about what happens when replication will be turned on.

NNegative Sorry to bring up an old convo... but I'm curious if there will be options to di...

K•1/10/24, 5:13 AM

https://developers.cloudflare.com/d1/learning/data-location/

Data location · Cloudflare D1 docs

Learn how the location of data stored in D1 is determined, including where the leader is placed and how you optimize that location based on your …

NNegative Sorry to bring up an old convo... but I'm curious if there will be options to di...

Max (@rozenmd)•1/10/24, 7:52 AM

It'll be possible to limit replication within an area (like the EU for GDPR)

Will•1/10/24, 9:17 AM

I tried this query to check if it's using index or not

EXPLAIN QUERY PLAN select * from professional_list where business_id = "9984587b-8505-4737-8b83-309c7b1642ab" AND professional_id = "a67a2dfd-3128-4667-8605-6b1fbc2f768b"

EXPLAIN QUERY PLAN select * from professional_list where business_id = "9984587b-8505-4737-8b83-309c7b1642ab" AND professional_id = "a67a2dfd-3128-4667-8605-6b1fbc2f768b"

Will•1/10/24, 9:17 AM

but I only get this as the result

Will•1/10/24, 9:17 AM

implying only professional_id is used as the index

Will•1/10/24, 9:17 AM

while business_id is indexed too

Will•1/10/24, 9:18 AM

and it's the left most column

Will•1/10/24, 9:18 AM

is this an expected behavior?

kian•1/10/24, 9:21 AM

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

kian•1/10/24, 9:21 AM

Take a look at the Multiple AND-Connected WHERE-Clause Terms heading

kian•1/10/24, 9:22 AM

The sections below that are also relevant.

Will•1/10/24, 9:35 AM

Thanks!

Will•1/10/24, 9:35 AM

I get where I was wrong now

Will•1/10/24, 9:38 AM

I created an index for each column

Will•1/10/24, 9:38 AM

while the correct way should be making one index but covering two column

SumitK0069•1/10/24, 9:55 AM

hello everyone i am new here i just to know can anyone help me setup my react project with D1Database

Ping for toast•1/10/24, 1:13 PM

Is there any way to search a D1 database?

Ping for toast•1/10/24, 1:14 PM

Ah https://www.sqlite.org/fts5.html

Ping for toast•1/10/24, 1:17 PM

Also what is the recommended use case for D1? Because my databases are usually much larger than 2gb

Ping for toast•1/10/24, 1:23 PM

The 50,000 database limit is interesting, some of my products are largely single player so this could work, but ideally there is some first class support for this (a “group”, and again the 50,000 is a scary limit, even though im not close to hitting this)

Ping for toast•1/10/24, 1:23 PM

What I’m thinking is that I’m not the target customer, but I’m curious who that is

PPing for toast Also what is the recommended use case for D1? Because my databases are usually m...

kian•1/10/24, 1:27 PM

This is a beta limitation, but there’s no estimate on what the cap will be in GA.

Kkian This is a beta limitation, but there’s no estimate on what the cap will be in GA...

Ping for toast•1/10/24, 1:35 PM

obviously it's safe to assume there will be a cap, so the question is just what sort of applications would a customer not be worried about hitting the cap in?

PPing for toast obviously it's safe to assume there *will* be a cap, so the question is just wha...

Max (@rozenmd)•1/10/24, 2:17 PM

the underlying tech (DOs) is currently being used by services doing real-time stuff with 200 million monthly active users, it scales really well if you can figure out the right way to split up your schema

Original message was deleted

Max (@rozenmd)•1/10/24, 2:18 PM

basically this

Original message was deleted

Max (@rozenmd)•1/10/24, 4:19 PM

not yet but is on our radar

kian•1/10/24, 5:09 PM

I'd say I wonder if it's just increased load from scheduled Workers kicking off at that time as well but that wouldn't have been a 'since Monday' thing

kian•1/10/24, 5:09 PM

ALECKS•1/10/24, 8:39 PM

can the migrate command be ran with a --force or such to avoid having to type "y" to confirm, for ex if you want to automatically run migrations in CI

AALECKS can the migrate command be ran with a --force or such to avoid having to type "y...

Cyb3r-Jak3•1/10/24, 8:57 PM

It should skip confirmation if wrangler detects it’s in CI. Try setting an environment variable of CI=1CI=1

CCyb3r-Jak3 It should skip confirmation if wrangler detects it’s in CI. Try setting an envir...

ALECKS•1/10/24, 8:58 PM

That's it! Thank you

yeehow•1/10/24, 10:09 PM

Just tried this example for using D1 in Svelte: https://developers.cloudflare.com/d1/examples/d1-and-sveltekit/

platformplatform seems to be undefined locally so it doesn't work.

On another project before I had used Miniflare locally to fix this. Is that still the way to do it? Was hoping for a simpler solution

Query D1 from SvelteKit · Cloudflare D1 docs

SvelteKit is a full-stack framework that combines the Svelte front-end framework with Vite for server-side capabilities and rendering. You can query …

yeehow•1/10/24, 10:11 PM

Yeah this looks similar to what I had done before with Miniflare. Just wondering if that is still the way to go?

Gagan Suie•1/10/24, 10:27 PM

How do i connect to a D1 database when using jest tests?

Gagan Suie•1/10/24, 10:29 PM

im using miniflare via
const env = getMiniflareBindings()const env = getMiniflareBindings()

Zuma•1/10/24, 10:38 PM

Hello, I've seen that dumping a DB to an sqlite file was supported during the alpha, but not now during the beta. Are there plans to add this (or something similar) back in later?

ZZuma Hello, I've seen that dumping a DB to an sqlite file was supported during the al...

yeehow•1/10/24, 10:45 PM

This what you are looking for? https://developers.cloudflare.com/d1/learning/backups/#downloading-a-backup-locally

Backups (Legacy) · Cloudflare D1 docs

D1 has built-in support for creating and restoring backups of your databases, including support for scheduled automatic backups and manual backup …

GGagan Suie im using miniflare via `const env = getMiniflareBindings()`

Gagan Suie•1/10/24, 11:07 PM

found this, but its not working for ESM
https://www.npmjs.com/package/@miniflare/d1

npm

@miniflare/d1

Workers D1 module for Miniflare: a fun, full-featured, fully-local simulator for Cloudflare Workers. Latest version: 2.14.1, last published: 5 months ago. Start using @miniflare/d1 in your project by running npm i @miniflare/d1npm i @miniflare/d1. There are 3 other projects in the npm registry using @miniflare/d1.

Original message was deleted

yeehow•1/10/24, 11:23 PM

Trying this example right now and running into weird issues when changing the database_iddatabase_id in the

wrangler.toml

wrangler.toml

file.

Only able to get it to work when bindingbinding and database_iddatabase_id are the same...

Confused why the ID would effect anything. Shouldn't it grab the database based on the binding?

Original message was deleted

yeehow•1/10/24, 11:26 PM

Yeah that works for me, but would like to use the actual DB id for migrations and stuff

kian•1/10/24, 11:29 PM

are you using wrangler dev or miniflare

Kkian are you using wrangler dev or miniflare

yeehow•1/10/24, 11:33 PM

Miniflare. Basically using this repo except changed the database_iddatabase_id in the wrangler file

https://github.com/jculvey/svelte-cf-bindings-poc

GitHub

GitHub - jculvey/svelte-cf-bindings-poc

Contribute to jculvey/svelte-cf-bindings-poc development by creating an account on GitHub.

kian•1/10/24, 11:34 PM

d1Databases in the Miniflare constructor needs to be changed to a Record<string, string> where its binding: id

kian•1/10/24, 11:34 PM

otherwise it’ll assume the id is the binding name

Kkian d1Databases in the Miniflare constructor needs to be changed to a Record<string,...

yeehow•1/10/24, 11:36 PM

That worked! thank you

Kkian otherwise it’ll assume the id is the binding name

yeehow•1/10/24, 11:38 PM

Is this documented anywhere? (if not i can make a PR)

All I see is https://miniflare.dev/storage/d1
Looks like the example there has the same problem

💾 D1 · Miniflare

Fun, full-featured, fully-local simulator for Cloudflare Workers

kian•1/10/24, 11:39 PM

probably just at https://github.com/cloudflare/workers-sdk/blob/4a925629238c9244d0fcf058301f46fc8fb64da2/packages/miniflare/README.md?plain=1#L510

preview_database_id is used when wrangler dev --remote is used, and is a real D1 DB -- just only us

Similar Threads

Similar Threads

Similar Threads