Cloudflare Developers•12mo ago

the migrations is not even run, cause it throw error in the table

戴戴きますReina the migrations is not even run, cause it throw error in the table

Isaac McFadyen•1/24/25, 1:11 PM

It's trying to run the migration though, because otherwise there'd be no error.

Original message was deleted

Isaac McFadyen•1/24/25, 2:39 PM

That's what I mean. D1 is trying to apply the migration called 0002_create_position_table.sql but it's already been applied so it fails.

Isaac McFadyen•1/24/25, 2:39 PM

Migrations shouldn't be applied twice, the fact that it is indicates the table tracking which migrations have been applied isn't working.

IIsaac McFadyen That's what I mean. D1 is trying to apply the migration called 0002_create_posit...

戴

戴きますReinaOP•1/24/25, 3:03 PM

Hmmm maybe you kinda confused, the 002 is still not been applied cause i checked the number of table still on migration 001, moving 002 failed cause of double by of Prisma generate other table. Thus is due to prisma migrate diff cli, we can't do beside from --from-empty

戴

戴きますReinaOP•1/24/25, 3:03 PM

But we can't forgot this bro, i just restart all db at it works fine

戴

戴きますReinaOP•1/24/25, 3:07 PM

Have a a nice day

戴

戴きますReinaOP•1/24/25, 3:07 PM

https://tenor.com/view/sakurazaka46-yu-airi-murai-yu-taniguchi-airi-gif-7709416241403650097

Tenor

MMax (@rozenmd)Added a bit more data and sorting to D1 insights

Max (@rozenmd)•1/24/25, 11:11 PM

just gonna bump this here in case folks missed it

MMax (@rozenmd)just gonna bump this here in case folks missed it

Ashkan•1/25/25, 12:27 AM

I have some suggestions but I didn't share them I know you are so busy right now. I will share them soon.

MMax (@rozenmd)just gonna bump this here in case folks missed it

森

森@VerseLink (RW)•1/25/25, 12:51 AM

lovely, would similar features come to DO with sqlite backend too?

AAshkan I have some suggestions but I didn't share them I know you are so busy right now...

Max (@rozenmd)•1/25/25, 6:43 AM

feel free to share them here, it's why I post screenshots and ship iteratively

matt•1/25/25, 8:12 PM

When will cloudflare announce they have abandoned read replicas?

It’s been years now, and it doesn’t help that the blog post back in April talks about replicas as if they are already deployed, it’s the first result shown when you search for D1 replicas. Not a great look to be dangling this carrot for so long and provide so few/zero updates for nearly a year

Ashkan•1/25/25, 8:44 PM

Dear CF team I think Console Tab needs some improvements. in addition to notes in the picture. there some suggestions; 1- Use different background color for query input area. 2- it's better to not execute queries on ENTER Key Press Event and execute it on Mouse Hover and Mouse Click on Execute Button. it prevents on unwanted ENTER key press maybe for going to next line. (Personal Opinion)

Mmatt When will cloudflare announce they have abandoned read replicas? It’s been year...

1984 Ford Laser•1/25/25, 10:23 PM

There have been posts more recently than March mentioning replicas, and employees are in here mentioning it from time to time. It is not ready, and won't be released until it is. Feel free to move onto another suitable product, if this one doesn't suit you

11984 Ford Laser There have been posts more recently than March mentioning replicas, and employee...

matt•1/25/25, 10:25 PM

where can i find any updates provided since that blog post nearly a year ago? I've searched everywhere, i've searched for "replicas" in this discord and scrolled back through 6 months of messages

matt•1/25/25, 10:25 PM

has anyone heard of peter molyneux?

Mmatt has anyone heard of peter molyneux?

1984 Ford Laser•1/25/25, 10:26 PM

Is this relevant? There is an #off-topic

matt•1/25/25, 10:28 PM

its relevant with regards to the relationship between promising & delivering

1984 Ford Laser•1/25/25, 10:28 PM

Okay well it isn't ready, that's the update.

matt•1/25/25, 10:29 PM

gosh i feel for the developers, it must be a lot of pressure putting out announcements well before things are ready. i imagine it feels a bit like the crunch phase of game development

matt•1/25/25, 10:30 PM

reminds me of when i used to work in big orgs and the sales team would promise new customers that we had features which weren't built yet... so the PMs would come down on us hard to build something we didn't get the time to plan properly

Althaf•1/26/25, 12:50 PM

do anyone have any idea why i can't acess the d1 using demo as i have local d1 in .wrangler file and still this error occurs like the env.db is undefined like does the d1 doesn't work on server actions ? nextjs cloudflare pages

Althaf•1/26/25, 12:51 PM

In nextjs

AAlthaf do anyone have any idea why i can't acess the d1 using demo as i have local d1 i...

森

森@VerseLink (RW)•1/26/25, 2:33 PM

you should try to see if not using drizzle works first

森

森@VerseLink (RW)•1/26/25, 2:33 PM

if so, then potentially it is with your drizzle config

森森@VerseLink (RW)you should try to see if not using drizzle works first

Althaf•1/26/25, 2:39 PM

Oh thats a good point

森森@VerseLink (RW)if so, then potentially it is with your drizzle config

Althaf•1/26/25, 2:44 PM

my config is like this. i think the issue is like when i try to console.log env.DB or env.DATABASE both are undefined i have no idea why is that and i explicity add the file path still error occurs like } db.query.users
⨯ [TypeError: this.client.prepare is not a function] {
digest: '2881251540'
} is there any fix for it or like does d1 doesn't works on server actions ?

AAlthaf my config is like this. i think the issue is like when i try to console.log env....

森

森@VerseLink (RW)•1/26/25, 2:47 PM

what does your wrangler.toml look like

Mmatt When will cloudflare announce they have abandoned read replicas? It’s been year...

Max (@rozenmd)•1/26/25, 4:16 PM

it is actively being worked on, lol

森森@VerseLink (RW)what does your wrangler.toml look like

Althaf•1/27/25, 4:55 AM

i copied this when generating local d1

LLeesy Hi lambrospetrou, is there any more information on the read replication coming? ...

lambrospetrou•1/27/25, 10:08 AM

Folks, someone asks for replication every day. When we have more information to share publicly, we will share it here and make it noticeable for everyone. It's been actively worked on. We cannot give more details on release date now.

Llambrospetrou Folks, someone asks for replication every day. When we have more information to ...

Hello, I’m Allie!•1/27/25, 10:43 AM

Well, there is always

Hello, I’m Allie!•1/27/25, 10:43 AM

:soontm:

Rudi B.•1/27/25, 1:00 PM

Hello, any1 know If it is planned for the Feature to öfter Mongo DB Databases?

RRudi B.Hello, any1 know If it is planned for the Feature to öfter Mongo DB Databases?

Isaac McFadyen•1/27/25, 1:04 PM

It's not planned. MongoDB is a very very different architecture to D1 and there are no plans to make D1 Mongo compatible that I am aware of.

Stefan Stührmann•1/28/25, 3:50 PM

Hey, are there any plans to provide the possibility for data analytics. As far as I understand I can access D1 either via worker or via the proprietary http api. Sure someone can build an own etl solution around this but this requires own development efforts (and you have to take care about change data capture etc. yourself). Also you also have to break out of the cloudflare eco system as there is no analytics optimized data store. A good start would be to have the possiblity to etl d1 / kv etc. to R2 -> iceberg or managed Clickhouse (which is already there for workers analytics).

SStefan Stührmann Hey, are there any plans to provide the possibility for data analytics. As far a...

Max (@rozenmd)•1/28/25, 4:20 PM

change data capture is something we'd like to offer with D1, yeah

Robin Genz•1/28/25, 4:27 PM

Hey

Quick question: Is there any way to increase the 10 GB limit of Cloudflare D1 for my account? At the moment it is not a problem but we are growing very fast and will reach the limit in the next few months.

MMax (@rozenmd)change data capture is something we'd like to offer with D1, yeah

Stefan Stührmann•1/28/25, 4:31 PM

how would you implement it cdc -> r2 with append operation like S3 got recently or you plan to introduce a stream like Kafka?

Original message was deleted

iLearn•1/28/25, 9:59 PM

Is the hard-limit of 10GB also applicable in case of DO with "SQLite storage" (which is D1) ?

Original message was deleted

iLearn•1/28/25, 9:59 PM

Thanks for prompt and crisp answer.

Original message was deleted

iLearn•1/28/25, 10:00 PM

Agree.

Original message was deleted

iLearn•1/28/25, 10:01 PM

True. But, can be raised to 10GB on request and ofcourse, in GA it will automatically be raised to 10GB.

rufi•1/29/25, 3:20 PM

Say I read from D1 on every request for some config or the like, would this add something like 200ms latency on each one?

Rrufi Say I read from D1 on every request for some config or the like, would this add ...

lambrospetrou•1/29/25, 3:59 PM

it depends where your database is, and where your workers will be. Usual roundtrip latencies apply. If you query from Europe to a database in US 100-150ms is expected yes. Within the same region, like EEUR/WEUR you can get 20-60ms.

gaminski•1/29/25, 4:55 PM

I need help understanding something. On the D1 marketing page it states we can have up to 50,000 databases on the paid plan. I cannot find a way to bind multiple databases to one project. How is that done? I’ve searched this thread and I realise that dynamic binding isn’t yet a thing. Some people mention binding multiple databases to one worker but I’m not sure how that’s done

Devid•1/29/25, 4:57 PM

Hello, Is there any way to migrate aws rds mariadb database to cloudflare database?

Ggaminski I need help understanding something. On the D1 marketing page it states we can h...

lambrospetrou•1/29/25, 5:23 PM

You can have multiple D1 bindings in your

wrangler.toml

wrangler.toml

. Repeat the [[d1_databases]][[d1_databases]] section for each of your databases. That's defining an array, and each time you use it, it's an item in that array. The newer

wrangler.json

wrangler.json

format makes that a bit easier to really understand though if you are not familiar with TOML syntax.

Example:

[[d1_databases]]
binding = "DB_01"
database_name = "db-01"
database_id = "<unique-ID-for-your-database>"

[[d1_databases]]
binding = "DB_02"
database_name = "db-02"
database_id = "<unique-ID-for-your-database>"

[[d1_databases]]
binding = "DB_01"
database_name = "db-01"
database_id = "<unique-ID-for-your-database>"

[[d1_databases]]
binding = "DB_02"
database_name = "db-02"
database_id = "<unique-ID-for-your-database>"

DDevid Hello, Is there any way to migrate aws rds mariadb database to cloudflare databa...

lambrospetrou•1/29/25, 5:24 PM

Export/SQL dump your existing database and import it in D1: https://developers.cloudflare.com/d1/best-practices/import-export-data/

[[d1_databases]] binding = "DB_01" database_name = "db-01" database_id = "<unique-ID-for-your-database>" [[d1_databases]] binding = "DB_02" database_name = "db-02" database_id = "<unique-ID-for-your-database>"

the migrations is not even run, cause it throw error in the table

Similar Threads

Similar Threads

Similar Threads