Hi! I have some issues here. There is no problem inserting data, but there was an error updating the

Hi! I have some issues here. There is no problem inserting data, but there was an error updating the data. Could you please help me check if I made a mistake?

websellcnOP•12/18/23, 7:44 AM

thanks

Wwebsellcn Hi! I have some issues here. There is no problem inserting data, but there was a...

Sam•12/18/23, 8:32 AM

What is the error?

SSam What is the error?

websellcnOP•12/18/23, 9:35 AM

return "404 Not Found"

Wwebsellcn return "404 Not Found"

Sam•12/18/23, 9:39 AM

Weird, also does D1 not support ON CONFLICT? You can have a single query using this, instead of the current 3

SSam Weird, also does D1 not support *ON CONFLICT*? You can have a single query using...

websellcnOP•12/18/23, 9:49 AM

A single query still returns the same result. There is too little information about updates in the official documents. I’m not sure if I wrote it correctly.

Wwebsellcn return "404 Not Found"

Max (@rozenmd)•12/18/23, 10:11 AM

D1 doesn't throw 404 - are you hitting the right URL of your API?

Wwebsellcn return "404 Not Found"

Matt Silverlock•12/18/23, 11:15 AM

Are you making a POST request? Your Hono route is

app.post

app.post

and you don’t appear to have any other routes.

websellcnOP•12/18/23, 11:37 AM

Okay, thank you everyone. There is an extra bracket in the code, but the editor did not remind me.

Original message was deleted

Matt Silverlock•12/18/23, 11:45 AM

D1 has a REST API - see the docs: https://developers.cloudflare.com/d1/

Cloudflare D1 · Cloudflare D1 docs

D1 is Cloudflare’s native serverless database. D1 allows you to build applications that handle large amounts of users at no extra cost. With D1, you …

Original message was deleted

Max (@rozenmd)•12/18/23, 12:20 PM

https://developers.cloudflare.com/api/operations/cloudflare-d1-query-database

Cloudflare API Documentation

Interact with Cloudflare's products and services via the Cloudflare API

Shroom•12/18/23, 4:05 PM

Is there any way to interleave two tables on disk? I have a table that has a 1 to many relationship with another table. I'm never going to query the "many" table to ask if it connects to the "one" table, always the other way around. I'd like to tell Cloudflare that they can optimize it by keeping the records from the 1 table next to the corresponding records from the many table by interleaving the rows on disk. That way it only needs to pull 1 disk block up when I query for data. Is this possible?

Shroom•12/18/23, 4:06 PM

Also, any way to bump up the 2 GB limit? Ikr it's not production ready, but I'd like to use it for a purely non-profit idea and I'm not sure if I'll stay under that limit

SShroom Is there any way to interleave two tables on disk? I have a table that has a 1 t...

kenton•12/18/23, 5:37 PM

D1 is built on SQLite, so this is only possible if SQLite itself contains such a feature. I don't think it does. But at the same time, I suspect this kind of feature would not have so much benefit given we're running SQLite backed by a local SSD. It'd be more important for a distributed database that might split data across many machines, but D1 doesn't do that.

Shroom•12/18/23, 8:16 PM

It doesn't do that? I thought the big advantage of d1 is that it's present at all your cdns. Does it just replicate the whole db everywhere?

SShroom It doesn't do that? I thought the big advantage of d1 is that it's present at al...

Isaac McFadyen•12/18/23, 8:21 PM

D1 is currently single location (either close to where you are when you create your DB, or in a geographic area of your choosing selected when you create the DB).

Isaac McFadyen•12/18/23, 8:22 PM

In the future there will be read replication support. But for now it's single location.

kian•12/18/23, 8:25 PM

Smart Placement will always run your Worker near the D1 DB

Original message was deleted

Max (@rozenmd)•12/18/23, 8:29 PM

I would use integers

IIsaac McFadyen D1 is currently single location (either close to where you are when you create y...

Shroom•12/18/23, 8:30 PM

Good to know. Most of my data can also be modeled as key-value pairs so I'll use that + hyperdrive.

Kkian Smart Placement will always run your Worker near the D1 DB

Isaac McFadyen•12/18/23, 8:43 PM

Note that Smart Placement places the Worker near the D1 DB. You'll still have to talk to the Worker back in Canada (in your example).

zegevlier•12/18/23, 9:26 PM

I would recommend ensuring R2 and D1 are in the same region, then enabeling smart placement.

Zzegevlier I would recommend ensuring R2 and D1 are in the same region, then enabeling smar...

Max (@rozenmd)•12/18/23, 10:09 PM

Smart placement should automagically do that for you (as in decide the optimal place to put the Worker)

zegevlier•12/18/23, 10:12 PM

It wouldn't put R2 and D1 in the same place, right?

SShroom It doesn't do that? I thought the big advantage of d1 is that it's present at al...

kenton•12/19/23, 2:11 AM

We are working on replication for D1, but even when it is replicated, each replica will store the entire database, so there's no need for a query to gather data from multiple machines. We might later add support for sharding, which puts different data on different machines, but we'll likely do this based on an explicit shard key provided by the application, so you'll be able to control which data lives together using shard keys rather than by interleaving tables.

Unsmart•12/19/23, 4:23 AM

I dont even want to know what the cost of D1 would be if it was every datacenter LUL

IIsaac McFadyen In the future there will be read replication support. But for now it's single lo...

riskiidrus•12/19/23, 7:06 AM

I created a database and chose a location in asia pacific. But why is the latency still so high? It even took up to 1 minute just to view the home page of my web application.

I am in Indonesia and My Web Application targets Users from Southeast Asian Countries.

I have selected the right location for My Database but the Latency is still so High. I don't know where in the Asia Pacific Region the D1 Data Center is located.

Kkenton We are working on replication for D1, but even when it is replicated, each repli...

huw•12/19/23, 7:26 AM

+1 for jurisdictional control over those shards

MMustafa Akın Since D1 supports 50k DBs now, but I want to employ a per-tenant database, in th...

GuillaumeLakano•12/19/23, 8:53 AM

The temporary solution is to PATCH the settings of your worker to attach new bindings ( REST API ) and then you can uses D1 through without the REST API

GGuillaumeLakano The temporary solution is to PATCH the settings of your worker to attach new bin...

Matt Silverlock•12/19/23, 12:10 PM

These are still bindings.

MMatt Silverlock These are still bindings.

GuillaumeLakano•12/19/23, 12:25 PM

Indeed, I've misread the question of @Mustafa Akın
Can you share with us any news about your future solutions?

GGuillaumeLakano Indeed, I've misread the question of @Mustafa Akın Can you share with us any ne...

Matt Silverlock•12/19/23, 12:28 PM

Not yet. We’ve shared a lot here already - it’s something we’re working on and will be part of/ahead of GA.

kian•12/19/23, 8:37 PM

D1 is SQLite, and doesn't really have the concept of users that you'd apply RLS to anyways.

kian•12/19/23, 8:45 PM

I'm not sure what you mean by that.

kian•12/19/23, 8:45 PM

You use the REST API or bind a Worker to the database.

Original message was deleted

Max (@rozenmd)•12/19/23, 9:17 PM

it's up to you to add application logic to show data based on authentication/authorization

Original message was deleted

Max (@rozenmd)•12/19/23, 9:19 PM

I recommend you go through the getting started guide to understand how it works: https://developers.cloudflare.com/d1/get-started/

Get started · Cloudflare D1 docs

This guide will instruct you through:

MMax (@rozenmd)You've pretty much identified all the sharp edges with working with multiple dat...

huw•12/19/23, 11:31 PM

(FYI for the discussion above this is how you PATCH extra bindings into a worker—cheers Max!)

mw10013•12/20/23, 1:38 AM

Is there a way to "reset" a database (ie. get it into the same state as if just created). This would be helpful with prototyping where I would like to reset the database and run the single migration I have that I'm editing. Currently, I'm deleting the database, creating another a new one with the same name, binding it to the pages app, updating the database id in the wrangler.toml, and finally applying the edited migration. Would be great to simply reset the database and then apply the edited migration. With local dev, I delete the

.wrangler

.wrangler

directory. Longing for a way to reset databases in the cloud

Max (@rozenmd)•12/20/23, 9:53 AM

I just throw a

DROP TABLE IF EXISTS...

DROP TABLE IF EXISTS...

at the start of my migrations

Cy•12/20/23, 11:07 AM

For anyone that’s used D1, what’s the performance look like?

Cy•12/20/23, 11:07 AM

I’m using turso and planetscale right now and I’m thinking about making the switch

CCy For anyone that’s used D1, what’s the performance look like?

JustinNoel•12/20/23, 1:17 PM

I was using Planetscale and switched to D1. much lower latency (improved about 50-100ms) for most areas I tested against.

Faster DB queries too but planetscale wAs pretty fast. Sorry, can't recall numbers.

Cy•12/20/23, 1:31 PM

Yeah I’m thinking latency will be the biggest thing given that I usually use pages

Cy•12/20/23, 1:32 PM

But I’m just worried about the query time tbh

CCy But I’m just worried about the query time tbh

Max (@rozenmd)•12/20/23, 1:34 PM

query time is fast with an index, getting data out rapidly is still a

NNico Hey, you've probably been asked this question many times, but I couldn't find an...

Chaika•12/20/23, 6:24 PM

D1 DBs are only accessible via bound workers or via the API/API Tokens you make. The only Workers that can access them are ones which are bound. IP Restrictions would be something you could do in the worker/firewall level

Chaika•12/20/23, 6:25 PM

It's not like they're normal SQL DBs that you can connect to externally, D1 is based on SQLite, no connection strings

Vy•12/20/23, 9:22 PM

@Nico What type of access controls are you interested in from a bound Worker itself?