`run` shouldn't actually return anything (<https://developers.cloudflare.com/d1/platform/client-api/
run
K
KYeah - I have no idea when it stopped returning errors like
D1_ERROR: Error: SQL execute error: Execute returned results - did you mean to call query?Valve pls fix rapidfire
Knvm they did
DThanks!
Dit says it returns the metrics only
Dthis is so helpful.. what I previously did was to create my own type where I pass in the type of my rows
Dusing this knowledge, means that I really dont need this interface.. right?
Dbut I guess I'll keep it for cases like this.. so I dont have to write <row> everytime
Dor there's a proper method for this? where there are multiple bindings
DIm not sure it addresses my problem where I need to have multiple bindings
Dlike in my code... I have a condition where the query changes depending on the searchParams... basically, if there's a status given, the arguments in bind() will be status, from and to.. but if it doesn't, it will be from and to only
SHi, can someone explain me this please?
if D1 is "serverless" and this is billed by usage, why this limits? https://developers.cloudflare.com/d1/platform/limits/ i do not understand ... (mainly the maximum database size)
if D1 is "serverless" and this is billed by usage, why this limits? https://developers.cloudflare.com/d1/platform/limits/ i do not understand ... (mainly the maximum database size)
UWhat about it do you not understand? Every service has limits. Serverless doesnt mean no limits
WIs there any way to do joins in d1? I did
and I got. That presents a MASSIVE issue. Essentially that means that
and I got. That presents a MASSIVE issue. Essentially that means that
"version"."id""channels"."name""version"."name""channels"."secondVersion"version.*
Dyou can rename them to avoid the name collision:
select "channels"."version" as "channelversion"note that this isn't specific to D1
WOkay, thanks ^^
Wthis is not going to work
WI cannot get drizzle to remap this query like that
Dokay, so you're using drizzle, that was not clear to me before 
WSee
DDrizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
Wyes it does, for raw sql. But unfortunately not for something like I am doing (see screenshot above)
Wbesides, I need those fields to have the same name (at least in js)
Dyou get an object, and you can have one thing with a given name
Wso can I remap this in a way that would make d1 return this correctly (so remap
"secondVersion"."name"svName
WHi! 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?
Wthanks
SWhat is the error?
Wreturn "404 Not Found"
SWeird, also does D1 not support ON CONFLICT? You can have a single query using this, instead of the current 3
WA 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.
MD1 doesn't throw 404 - are you hitting the right URL of your API?
MAre you making a POST request? Your Hono route is
app.postOkay, thank you everyone. There is an extra bracket in the code, but the editor did not remind me.
MD1 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 …
MInteract with Cloudflare's products and services via the Cloudflare API
SIs 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?
SAlso, 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
KD1 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.
SIt 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?
ID1 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).
IIn the future there will be read replication support. But for now it's single location.
KSmart Placement will always run your Worker near the D1 DB
MI would use integers
SGood to know. Most of my data can also be modeled as key-value pairs so I'll use that + hyperdrive.
INote 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).
ZI would recommend ensuring R2 and D1 are in the same region, then enabeling smart placement.