Cloudflare Developers•2y ago

Do I have to use cloudflare pages to use d1 on a website?

MMrxbox98 Do I have to use cloudflare pages to use d1 on a website?

Hello, I’m Allie!•2/15/24, 7:08 PM

No, you can use Workers too

HHello, I’m Allie!No, you can use Workers too

Mrxbox98OP•2/15/24, 7:09 PM

Can I use d1 with a website that I host elsewhere?

SShyim what is the best way to export the db? 🤔 The request is malformed: Experiment...

Max (@rozenmd)•2/15/24, 8:45 PM

https://github.com/nora-soderlund/cloudflare-d1-backups until we build the feature natively

GitHub

GitHub - nora-soderlund/cloudflare-d1-backups: A package to dump a ...

A package to dump a copy of your experimental D1 database through a worker. - nora-soderlund/cloudflare-d1-backups

Santosh•2/15/24, 10:19 PM

How come D1 would be so much cheaper as compared to DO from a pricing perspective? I am contrasting DO Transaction storage API (reads) + a DO call with D1 reads. Dont they all use the same tech behind the scenes?

clearwater4227•2/15/24, 10:37 PM

is d1 having any kind of issues? My api is getting rows_read as positive but no results array is returned...

clearwater4227•2/15/24, 10:45 PM

thanks! testing now...

clearwater4227•2/15/24, 10:49 PM

hmm.....still not working...

const db = drizzle(env.user_prefs_database);
var res = await db
.select()
.from(user_preferences)
.where(eq(user_preferences.account_id, account_id))
.all();
if (res.results.length == 0) {

thats the code. It works running locally with wrangler...

clearwater4227•2/15/24, 10:49 PM

actually.... .all() does not work locally.... .run() works locally

Original message was deleted

clearwater4227•2/15/24, 10:57 PM

Any thoughts? it seems like .run() works locally.... .all() does not, locally or deployed...

clearwater4227•2/15/24, 11:00 PM

ah.... using this as compatibiltiy date:

compatibility_date = "2023-08-28"

clearwater4227•2/15/24, 11:00 PM

looking into it ...thank you

clearwater4227•2/15/24, 11:49 PM

hmmm...yeah, dosent look like it....might need to switch off drizzle..

MMax (@rozenmd)if you add caching to your Worker so it doesn't have to wait for the request fro...

Santosh•2/16/24, 12:09 AM

Not a D1 issues as is, more with the toolkit around it. I tried using d1-manager. Added all DB_* variables to point settings to my D1 database. Still cant see databases at the top on UI. Anyone else encountered this? What did you do to fix this?

Cyb3r-Jak3•2/16/24, 4:49 AM

Please don’t ping people directly

Cyb3r-Jak3•2/16/24, 4:51 AM

Also, I just checked and my D1 databases are fine

Original message was deleted

Cyb3r-Jak3•2/16/24, 4:51 AM

I know, pinging people and asking to escalate isn’t going to help.

artakiel•2/16/24, 5:04 AM

artakiel•2/16/24, 5:09 AM

Can you speak french community ?

oof2win2•2/16/24, 9:50 AM

is there a way to get the URL to the local d1 database for tools such as prisma?

Ooof2win2 is there a way to get the URL to the local d1 database for tools such as prisma?

Hello, I’m Allie!•2/16/24, 9:51 AM

There isn't one

oof2win2•2/16/24, 9:53 AM

but when you run it with --local it creates the local db

Ooof2win2 but when you run it with --local it creates the local db

Hello, I’m Allie!•2/16/24, 9:58 AM

Oh, if you mean the file path, then you can build it yourself with the database ID

oof2win2•2/16/24, 9:59 AM

okay, thanks

oof2win2•2/16/24, 9:59 AM

the annoying thing for prisma is it can't introspect the db and see if rows would be deleted or not since there isn't a URL

MMatt Silverlock Official change-log and updated documentation for breaking changes to `all()`, `...

Ashkan•2/16/24, 10:53 AM

Hi, wish there was an warning email about the changes in my email inbox. I got shocked why my web application was totally out of service.

ammarriq•2/16/24, 12:40 PM

It is mentioned on Cloudflare d1 page that it supports SQLite triggers.

Anyone here who knows how to create triggers?

Aammarriq It is mentioned on Cloudflare d1 page that it supports SQLite triggers. Anyone ...

Max (@rozenmd)•2/16/24, 1:20 PM

https://www.sqlite.org/lang_createtrigger.html might help

Ɽ

ⱤØ₥₳₦•2/16/24, 1:29 PM

Is there any specific write/read per second limit on D1? Docs says nothing like that

MMatt Silverlock Changelog going out soon, but for those here: * D1's `.raw()`, `.all()` and `.r...

Isaac McFadyen•2/16/24, 1:31 PM

Is there a reason this couldn't have been a compat-date gated change? Seems quite a few people are running into this breaking change, and having a Worker in prod break when not expected is exactly what compat dates were designed to solve...

ⱤⱤØ₥₳₦Is there any specific write/read per second limit on D1? Docs says nothing like ...

Max (@rozenmd)•2/16/24, 2:02 PM

It's not a "limit" we set, as much as a beta architectural limitation - your D1 database currently runs from a single durable object instance, and there's only so much work a single thread can do per second before overloading

IIsaac McFadyen Is there a reason this couldn't have been a compat-date gated change? Seems quit...

James•2/16/24, 2:12 PM

Agreed, R2 and Vectorize had similar changes to their data structures and things and just introduced those with a compat date/flag. Feels weird for a product like D1 that’s even further along to not have done that.

IIsaac McFadyen Is there a reason this couldn't have been a compat-date gated change? Seems quit...

Max (@rozenmd)•2/16/24, 2:25 PM

We saw it as a bug fix - the correct behaviour was documented, and

.run()

.run()

used to work as documented

MMax (@rozenmd)We saw it as a bug fix - the correct behaviour was documented, and `.run()` used...

James•2/16/24, 2:30 PM

It still broke people’s workers though unfortunately, and especially if they’re not in discord or don’t know to manually check changelogs, they’re left confused and frustrated that code that they previously had working, no longer does, with no change of their own. Unless there were alerts sent to people impacted outside of that?

JJames It still broke people’s workers though unfortunately, and especially if they’re ...

Vy•2/16/24, 2:56 PM

We're looking into a resolution here to restore the previous

.run

.run

behvaior and I'll report back. Apologies and yes we should/will be applying compatibility dates to D1 breaking chnages

kenton•2/16/24, 3:00 PM

Yes, apologies everyone, this was a mistake. Changes like this should absolutely be guarded by a compat flag, even in beta/alpha, even if the behavior was undocumented, but we screwed up. We're working on restoring the previous behavior now and will find ways to make sure this doesn't happen again.

Rrenzor has anyone noticed when you delete a db row in the UI, it deletes the entire thi...

Max (@rozenmd)•2/16/24, 5:25 PM

is the primary key null?

Rrenzor it is possible. I have a compound primary key set via a drizzle schema, and have...

Max (@rozenmd)•2/16/24, 5:45 PM

It's a bug - it shouldn't be showing you the delete button here because deleting a row with more than one column as a PK isn't implemented yet

Max (@rozenmd)•2/16/24, 5:45 PM

it's basically just deleting by the first column in your compound key

Vy•2/16/24, 5:46 PM

Sharing that we've gone back to previous

.run

.run

behavior where it does return results. We will be differentiating .run (no results) vs .all (with results) behind a compatibility date in the future

VVy Sharing that we've gone back to previous `.run` behavior where it does return re...

kenton•2/16/24, 6:26 PM

To clarify,

.run

.run

now once returns results as it used to.

mllnd•2/16/24, 6:30 PM

hey, quick question - would it make more sense to set up D1 connection on the server side of a cloudflare pages app or move all db interactions on the cloudflare functions side?

Mmllnd hey, quick question - would it make more sense to set up D1 connection on the se...

Hello, I’m Allie!•2/16/24, 6:32 PM

On Pages, Functions is the server

Hello, I’m Allie!•2/16/24, 6:32 PM

So both

Do I have to use cloudflare pages to use d1 on a website?

Similar Threads

Similar Threads

Similar Threads