This is something they (CF) are working on, programmatically creating/binding. Needed for the other

This is something they (CF) are working on, programmatically creating/binding. Needed for the other services also

Anuraag•10/7/23, 5:20 PM

Hi, quick question, does D1 require connection pooling? I'm using Next.js for a project and it doesn't support singletons for the purpose of supporting serverless, and all of its docs point to connecting to the DB when a request is received, but will that be a problem with D1?

zegevlier•10/7/23, 5:22 PM

No, D1 is designed to work in serverless enviornmens where there are no persistent connection.s

Fforslunds This is something they (CF) are working on, programmatically creating/binding. N...

w3bcode•10/7/23, 5:22 PM

Got it. Till then I will do it manually.

Zzegevlier No, D1 is designed to work in serverless enviornmens where there are no persiste...

Anuraag•10/7/23, 5:23 PM

Oh, that's good news then. Thanks

w3bcode•10/7/23, 5:25 PM

I am just curious to know if I xan have multiple DB on same binding name or do i have to create seperate binding for each db.

Reason for this is because, I am not sure how multiple bindings for same service like d1 would work ?

Ww3bcode I am just curious to know if I xan have multiple DB on same binding name or do i...

forslundsOP•10/7/23, 5:30 PM

If you do an insert on DB-binding. Do you want it on all DBs or just the “current users” db? I guess you need separate for every DB you want to connect

Mmalone haha a rough estimate

Nikil•10/7/23, 6:48 PM

@malone yea Don't trust it for math @rozenmd

malone•10/7/23, 6:55 PM

when i gave it my schema and said "estimate how big the table would be with 3 million rows" it got it pretty spot on, said 500mb when it is 400mb (due to not taking up the full size of the columns)

malone•10/7/23, 6:55 PM

ymmv

malone•10/7/23, 6:57 PM

it estimating 1kb per row was definately a miss, im guessing it doesn't have enough context of your table schema bc that's way too high

NNikil @malone yea Don't trust it for math @rozenmd

malone•10/7/23, 6:57 PM

that math is correct

malone•10/7/23, 6:57 PM

anyway, ignore me lmao

Fforslunds If you do an insert on DB-binding. Do you want it on all DBs or just the “curren...

w3bcode•10/7/23, 10:18 PM

on Seperate DB depending on tenant

cristiandley•10/8/23, 3:39 AM

Hey Guys, i have a db and corresponding preview, but now i can't apply mirgations since it returns an error

✘ [ERROR] Can't find a DB with name/binding 'preview-mydb' in local config. Check info in wrangler.toml...

✘ [ERROR] Can't find a DB with name/binding 'preview-mydb' in local config. Check info in wrangler.toml...

but i have a definition like so

[[d1_databases]]
binding = "DB"
database_name = "mydb"
database_id = "main-id"
preview_database_id = "preview-id"

[[d1_databases]]
binding = "DB"
database_name = "mydb"
database_id = "main-id"
preview_database_id = "preview-id"

전전현우 Hi. Im trying to use Cloudflare D1 on Next.js Project. But I can't found any res...

James•10/8/23, 8:05 AM

You could use something like cf-bindings-proxy to access it in

next dev

next dev

Adi•10/8/23, 9:42 AM

The introduction of Hyperdrive got me thinking. Query caching is a very useful tool for any database. Are there plans to implement query caching in D1 at some point? Or is this something we would be expected to build ourselves?

Michał•10/8/23, 9:47 AM

Hi! Is global read replication already available for D1?

MMichał Hi! Is global read replication already available for D1?

Hello, I’m Allie!•10/8/23, 9:47 AM

Not yet

Michał•10/8/23, 9:48 AM

Thanks. Is there a timeline for that? Or maybe a closed alpha we could participate in?

MMichał Thanks. Is there a timeline for that? Or maybe a closed alpha we could participa...

Hello, I’m Allie!•10/8/23, 9:52 AM

is the only answer we can provide atm

w3bcode•10/8/23, 10:19 AM

Can anyone help me to access multiple D1 database from same worker ? I want to use the multiple database feature per tenant. But couldnt figure out how

Ww3bcode Can anyone help me to access multiple D1 database from same worker ? I want to u...

Michał•10/8/23, 10:23 AM

You should be able to add multiple bindings under different names

MMichał You should be able to add multiple bindings under different names

w3bcode•10/8/23, 11:24 AM

but with this, I wont be able to use same API for multitenant

I would need to deploy each worker seperately for each worker I guess.

Is there any better way to support multitenant with D1 database ?

Michał•10/8/23, 11:45 AM

You can have separate workers for each tenant. I'm not sure if that's the "official" way of doing things but that's how we're doing it.

MMichał You can have separate workers for each tenant. I'm not sure if that's the "offic...

w3bcode•10/8/23, 11:49 AM

got it. thanks

Mmalone that math is correct

Nikil•10/8/23, 11:59 AM

oh yea it is huh

Paul•10/8/23, 3:03 PM

Is d1 production ready?

Paul•10/8/23, 3:16 PM

I’m super pumped to switch things off supabase

bkyerv•10/8/23, 3:17 PM

hello everyone, I'm encountering a problem when applying drizzle generated migrations to Cloudflare D1. The initial migration is processed without any hiccups, but I run into an issue with subsequent migrations, especially those that modify existing columns. Here's the error I'm receiving:

/*
 SQLite does not support "Changing existing column type" out of the box, we do not generate automatic migration for that, so it has to be done manually
 Please refer to: https://www.techonthenet.com/sqlite/tables/alter_table.php
                  https://www.sqlite.org/lang_altertable.html
                  https://stackoverflow.com/questions/2083543/modify-a-columns-type-in-sqlite3

 Due to that we don't generate migration automatically and it has to be done manually
*/

/*
 SQLite does not support "Changing existing column type" out of the box, we do not generate automatic migration for that, so it has to be done manually
 Please refer to: https://www.techonthenet.com/sqlite/tables/alter_table.php
                  https://www.sqlite.org/lang_altertable.html
                  https://stackoverflow.com/questions/2083543/modify-a-columns-type-in-sqlite3

 Due to that we don't generate migration automatically and it has to be done manually
*/

I feel this is related to D1 than to drizzle as applying migrations locally runs smooth and raise errors only when attempting to run migrations to remote db

Bbkyerv hello everyone, I'm encountering a problem when applying drizzle generated migra...

Adi•10/8/23, 3:23 PM

That looks like the output of drizzle kit and not a D1 error.

The comment it's generated is accurate. Nothing to do with D1.

bkyerv•10/8/23, 3:26 PM

I see. why can it then apply them locally and raise error in case remote db is attempted?

cfanclub•10/8/23, 3:28 PM

Is it possible to download time-travel backup locally of new d1 database using wrangler ?

Michał•10/8/23, 4:26 PM

Is there a way to provide the primary location hint when creating a D1 database via the API? (POST

/accounts/{account-identifier}/d1/database

/accounts/{account-identifier}/d1/database

)
Right now DBs created this way get assigned to the

WNAM

WNAM

region but I'd prefer Europe

kian•10/8/23, 4:34 PM

Add primary_location_hint: <loc> to the body

Kkian Add primary_location_hint: <loc> to the body

Michał•10/8/23, 6:58 PM

Thank you and sorry for late response. That did the trick, even though the openapi schema doesn't mention it

MarkB•10/8/23, 7:29 PM

hi, what is health check region in load balancing? if region is 1 in load balancing, it doesn't work for request from other regions?

Noel•10/8/23, 8:27 PM

I started getting

 binding __D1_BETA__DB of type d1 failed to generate. Please try again later or contact support.
  [code: 10021]

 binding __D1_BETA__DB of type d1 failed to generate. Please try again later or contact support.
  [code: 10021]

on new deploy attempts. Is it related to the current incident? https://www.cloudflarestatus.com/incidents/64wsqjxnljn3

James•10/8/23, 8:33 PM

Very likely, yes. I'd recommend trying again once the incident is resolved

FFerry I get the same and in the cloudflare web 'dashboard' under workers and pages/d1 ...

James•10/8/23, 8:42 PM

yep that one is definitely related to https://www.cloudflarestatus.com/incidents/64wsqjxnljn3. Please try again once the incident is resolved, apologies for the issues!

Jadugar_Jaggu•10/9/23, 7:28 AM

Hey Guys, can we cache the D1 results ? and is it production ready ?

JJadugar_Jaggu Hey Guys, can we cache the D1 results ? and is it production ready ?

Max (@rozenmd)•10/9/23, 7:48 AM

D1 is in public beta. While we expect breaking changes and issues to be minimal, they may still occur. We generally do not recommend running large production workloads on beta products.

from https://developers.cloudflare.com/d1/

---

Being in a Worker, you have full access to the cache API: https://developers.cloudflare.com/workers/runtime-apis/cache/

Ddpeek I have a question about prepared statements: the docs state that prepared statem...

Max (@rozenmd)•10/9/23, 1:52 PM

prepared statements help protect you against sql injection and improve performance when a query is re-used, as the db doesn't need to re-parse the query each time

shixzie•10/9/23, 3:40 PM

I'd love an option to download a copy of the database to run and test locally

cfanclub•10/9/23, 3:54 PM

CREATE TABLE blog (
    id TEXT PRIMARY KEY,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    content_url TEXT,
    frontmatter JSON,
    slug TEXT UNIQUE,
    title TEXT,
    website_ref_id TEXT,
    FOREIGN KEY (website_ref_id) REFERENCES website(id)
);

CREATE TABLE blog (
    id TEXT PRIMARY KEY,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    content_url TEXT,
    frontmatter JSON,
    slug TEXT UNIQUE,
    title TEXT,
    website_ref_id TEXT,
    FOREIGN KEY (website_ref_id) REFERENCES website(id)
);

I have the given schema in d1 database, I am using the preprare statement as

DB.prepare('select * from blog').all()

DB.prepare('select * from blog').all()

But the stored frontmatter is returning json as string instead of automatically parsing it out as json.

Am I missing something ?

Ccfanclub ``` CREATE TABLE blog ( id TEXT PRIMARY KEY, created_at DATETIME DEFAULT...

Michał•10/9/23, 3:56 PM

SQLite stores JSON as ordinary text.

/* SQLite does not support "Changing existing column type" out of the box, we do not generate automatic migration for that, so it has to be done manually Please refer to: https://www.techonthenet.com/sqlite/tables/alter_table.php https://www.sqlite.org/lang_altertable.html https://stackoverflow.com/questions/2083543/modify-a-columns-type-in-sqlite3 Due to that we don't generate migration automatically and it has to be done manually */

CREATE TABLE blog ( id TEXT PRIMARY KEY, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, content_url TEXT, frontmatter JSON, slug TEXT UNIQUE, title TEXT, website_ref_id TEXT, FOREIGN KEY (website_ref_id) REFERENCES website(id) );

This is something they (CF) are working on, programmatically creating/binding. Needed for the other

Similar Threads

Similar Threads

Similar Threads