You are missing an 'await' for the query
You are missing an 'await' for the query
DI tried to follow this: https://developers.cloudflare.com/d1/platform/client-api/
got it, where do I put it, before platform?
got it, where do I put it, before platform?
DThank you .. I didn't realize I needed it cause it works sometimes.. Im gonna try it
DThanks so much @thiccvitalik I think it works fine now. I was so silly not adding it.
MIf you have specific queries that don’t run on the production backend, open a GitHub issue.
ITip for the future: there should almost never be a reason to cast into and then another type. If it won't cast without the unknown then it's likely something else is wrong. 
Duhm, can you help me overcome it? cause I followed the set up but on my app.d.ts, the D1Database isn't defined... so my platform.env.database.prepare.bind.run() is always unknown
K shouldn't actually return anything (https://developers.cloudflare.com/d1/platform/client-api/#await-stmtrun) but iirc it's broken and does.
K
KYeah - I have no idea when it stopped returning errors like but it's probably going to be a pain to return to it's original behaviour without breaking projects
KValve 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 overwrites and . That is not even the worst. I currently have set to null but I am 99% that when it's not null it's going to overwrite my
and I got. That presents a MASSIVE issue. Essentially that means that overwrites and . That is not even the worst. I currently have set to null but I am 99% that when it's not null it's going to overwrite my
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?