Cloudflare Developers•12mo ago

sql statement is generated via prisma cli

戴戴きますReina anyone have project with hono with d1 prisma? how get the url for the db1 databa...

戴

戴きますReinaOP•1/24/25, 12:46 PM

like this

戴戴きますReina sql statement is generated via prisma cli

Isaac McFadyen•1/24/25, 12:46 PM

Does the Prisma CLI connect to your D1 DB to verify that the table doesn't already exist? It shouldn't be giving you SQL to create the table if the table already exists.

IIsaac McFadyen Does the Prisma CLI connect to your D1 DB to verify that the table doesn't alrea...

戴

戴きますReinaOP•1/24/25, 12:48 PM

we using prisma migrate diff like in the docs,
https://www.prisma.io/docs/orm/overview/databases/cloudflare-d1

Cloudflare D1 | Prisma Documentation

Guide to Cloudflare D1

IIsaac McFadyen Does the Prisma CLI connect to your D1 DB to verify that the table doesn't alrea...

戴

戴きますReinaOP•1/24/25, 12:48 PM

yup its should not generate create table, even we change manual still not work

戴戴きますReina yup its should not generate create table, even we change manual still not work

Isaac McFadyen•1/24/25, 12:52 PM

It's very hard to troubleshoot unless you give the (manually changed) statement. The error you shared indicates that it's trying to do something it shouldn't be.

IIsaac McFadyen It's very hard to troubleshoot unless you give the (manually changed) statement....

戴

戴きますReinaOP•1/24/25, 12:52 PM

for now i think i am gonna restart all the d1 since its still the beginning huhu

IIsaac McFadyen It's very hard to troubleshoot unless you give the (manually changed) statement....

戴

戴きますReinaOP•1/24/25, 12:54 PM

for example 002 migrations already make table "CREATE TABLE "Single" but if we change manual (cause cli not working) is like this "CREATE TABLE IF NOT EXIST "Single""

戴戴きますReina for example 002 migrations already make table "CREATE TABLE "Single" but if we c...

Isaac McFadyen•1/24/25, 12:55 PM

Is there any other statement in there that might be trying to create a key (that's what the error is)? Maybe a CREATE INDEXCREATE INDEX or similar?

IIsaac McFadyen Is there any other statement in there that might be trying to create a key (that...

戴

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

nothing

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

An error is still returned if the table cannot be created because of an existing index, even if the "IF NOT EXISTS" clause is specified.

戴戴きますReina we using prisma migrate diff like in the docs, https://www.prisma.io/docs/orm/ov...

戴

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

i got lock in here, if you read this if we use --from-schema-datamodel --from-url we cant since binding is via wrangler not url like postgress, we also cant use

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

Ah, actually, looks to be a SQLite thing.

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

TLDR if there's an index in the table you can't even use CREATE IF NOT EXISTS

IIsaac McFadyen TLDR if there's an index in the table you can't even use CREATE IF NOT EXISTS

戴

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

wait let me check

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

From https://www.sqlite.org/lang_createtable.html

戴

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

we need to reset all data inside database ?

戴戴きますReina we need to reset all data inside database ?

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

The root issue is that you're trying to create a table when one already exists... Prisma shouldn't be generating/running queries to create a table if it's already present.

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

You don't need to delete the table, just don't run the migration if it's already in the DB

IIsaac McFadyen The root issue is that you're trying to create a table when one already exists.....

戴

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

yeah bro thats the problem

when we migrate the db/wrangler cant do it since already existed table

戴

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

i am gonna move away for now, maybe too much work, thanks bro

戴戴きますReina yeah bro thats the problem 😂 when we migrate the db/wrangler cant do it since a...

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

No, what I mean is that you should never be running a migration twice.

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

That kinda defeats the point of migrations which is to bring your DB to a certain schema version.

IIsaac McFadyen No, what I mean is that you should never be running a migration twice.

戴

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

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 ?

sql statement is generated via prisma cli

Similar Threads

Similar Threads

Similar Threads