you're missing quotes around the id, should be `WHERE id = '...'`

you're missing quotes around the id, should be

WHERE id = '...'

WHERE id = '...'

WHERE id = '...'

WHERE id = '...'

MMax (@rozenmd)you're missing quotes around the id, should be `WHERE id = '...'`

Kartoffel🟢🟡🔴•7/17/24, 2:21 PM

not works

Max (@rozenmd)OP•7/17/24, 2:22 PM

single quotes*

MMax (@rozenmd)single quotes*

Kartoffel🟢🟡🔴•7/17/24, 2:23 PM

no ��

Max (@rozenmd)OP•7/17/24, 2:23 PM

wait why is it form-data

Max (@rozenmd)OP•7/17/24, 2:24 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

Kartoffel🟢🟡🔴•7/17/24, 2:28 PM

hmm OK, so raw works

Zeeshan•7/17/24, 7:42 PM

i see there are two tables in my database formsforms when i tried command npx wrangler d1 info formsnpx wrangler d1 info forms
but i dont know what is the command to get the name of each table so i can confirm.

when i checked in the dashboard, it says 2 tables but shows only one table.

how to get the table name?

Dean•7/18/24, 4:31 AM

wondering if the 10GB disk limit would be increased down the line or is that something unlikely to happen?

Ppeshakoo I've read in this channel that yes it will be increased to maybe 10s of GBs but ...

Dean•7/18/24, 5:47 AM

Thx for that, that’ll be perfect for my use case.

Wwataru Hello. I have a question. How would you connect a local Cloudflare D1 DB through...

wataru•7/18/24, 7:59 AM

Heyo! I couldn't find a solution for seeding local D1, so I wrote a workaround. Let me share it here for someone who wants to seed local D1 like me.

https://www.npmjs.com/package/seed-d1

npm

seed-d1

Workaround for seeding against local Cloudflare D1 database.. Latest version: 0.0.1, last published: 36 minutes ago. Start using seed-d1 in your project by running npm i seed-d1npm i seed-d1. There are no other projects in the npm registry using seed-d1.

ZZiga Zajc Sorry to bother you again, but is this soon in August, this year or next year? W...

boop•7/18/24, 8:12 PM

See the message that I'm going to quote in my next message

HHello, I’m Allie!Note, this was said in my capacity as a community member

boop•7/18/24, 8:12 PM

boop•7/18/24, 8:15 PM

Last update from an employee that works on D1

lifeiscontent•7/19/24, 9:08 AM

how do I create a Transaction in D1 using TypeScript?

Llifeiscontent how do I create a Transaction in D1 using TypeScript?

Hard@Work•7/19/24, 9:26 AM

Batches are automatically run in transactions. You cannot create transactions manually

ajgeiss0702•7/19/24, 4:36 PM

I'm trying to restore my database (because an error caused it to be wiped) but every time i try, I just get "There was a problem restoring your database, please try again later."
any help with this would be highly appreciated

ajgeiss0702•7/19/24, 4:43 PM

And I get this when trying it from wrangler:

⚡️ Time travel in progress...

✘ [ERROR] A request to the Cloudflare API (/accounts/f55b85c8a963663b11036975203c63c0/d1/database/221100ba-5ab9-4cda-8cfa-69c17ea546ab/time_travel/restore?bookmark=00003dd4-00000030-00004dd3-875d104537255313a0acac8125549dff) failed.

  {"D1_RESET_DO":true} [code: 7500]

⚡️ Time travel in progress...

✘ [ERROR] A request to the Cloudflare API (/accounts/f55b85c8a963663b11036975203c63c0/d1/database/221100ba-5ab9-4cda-8cfa-69c17ea546ab/time_travel/restore?bookmark=00003dd4-00000030-00004dd3-875d104537255313a0acac8125549dff) failed.

  {"D1_RESET_DO":true} [code: 7500]

Ben•7/19/24, 5:23 PM

Hello I have a question about future plans. Currently in the D1 limits page it says we can make 50,000 (Workers Paid) / 10 (Free)50,000 (Workers Paid) / 10 (Free) Databases.

This makes me think that you guys are heading towards making it very easy to create databases, ie database per tenant, similiar to Turso. Is this correct?

BBen Hello I have a question about future plans. Currently in the D1 limits page it s...

ajgeiss0702•7/19/24, 5:38 PM

d1-database

Isaac McFadyen•7/19/24, 5:39 PM

Yes. It's on the roadmap and actively being worked on but no timeline yet.

marko.333•7/19/24, 10:13 PM

If i have an cloud app that has many customers, what is the Cloudflare architecture recommendation for stateful resources (like D1 and Queues)?
Is it better to stick with simple multi-tenancy (option-A), or is it better (or even possible) to use the Cloudflare API's to dynamically provision for each customer (option-B).
In the later case each customer would have their own set of D1 databases and Queues.
I don't see any doc or sample code demonstrating option-B?

Mmarko.333 If i have an cloud app that has many customers, what is the Cloudflare architect...

marko.333•7/19/24, 10:19 PM

Opps, appears a similar question was literally asked today!-)
It sounds like the answer to my question is that "option-B" is not currently supported?
I had the impression it may be, since there are API's that appear intended to dynamically provision resources?
https://developers.cloudflare.com/api/operations/cloudflare-d1-create-database

Mmarko.333 Opps, appears a similar question was literally asked today!-) It sounds like ...

Isaac McFadyen•7/20/24, 1:36 AM

So there are APIs to dynamically provision resources, but you can't bind them to use from a Worker without a redeploy of that Worker.

Isaac McFadyen•7/20/24, 1:36 AM

The "binding dynamically to the Worker" is what's on the roadmap/being worked on.

Isaac McFadyen•7/20/24, 1:36 AM

You can manually query D1 via the Cloudflare API but it's much slower than binding directly to a Worker and has very strict rate-limits (1200 calls per 5 minutes I believe?)

IIsaac McFadyen The "binding dynamically to the Worker" is what's on the roadmap/being worked on...

marko.333•7/20/24, 1:52 AM

Gotcha, thx. I got ahead of myself when Claude 3.5 gave me this hallucination...

db = env.__D1_BETA__D1DatabaseFactory(databaseId);

db = env.__D1_BETA__D1DatabaseFactory(databaseId);

Is there a formal Issue publicly accessible to track this work?
thx

BBen Hello I have a question about future plans. Currently in the D1 limits page it s...

Max (@rozenmd)OP•7/20/24, 11:14 AM

actively building it (during work hours anyway)

Max (@rozenmd)OP•7/20/24, 11:16 AM

also https://github.com/nora-soderlund/cloudflare-dynamic-bindings might be of interest

MMax (@rozenmd)also https://github.com/nora-soderlund/cloudflare-dynamic-bindings might be of i...

marko.333•7/20/24, 11:47 AM

i'm not sure i would call that github project "dynamic" (maybe "cloudflare-gen-bindings")? Regardless - cool hack.
I wish there was an open discussions page to discuss requests and future direction?
Besides being able to dynamically create resources, it would also be nice to build some higher-level abstractions (at least for common usecases), to help simplify the management.
For example, it would be great if there was some form of higher-level "sharding" support that only required a resource to be configured with a "sharding key" (Example: A D1 "foobar" db shared by "customer_id"). That resource (D1, or Queue, or ...) would then require the shard-key to operate on it.
Under the covers Cloudflare would then manage "foobar" by appropriately creating a D1 instance when a new key is referenced, or finding/binding the instance when it does exist, and Migrations could also be done across the entire "foobar" cluster?

Mmarko.333 i'm not sure i would call that github project "dynamic" (maybe "cloudflare-gen-b...

Max (@rozenmd)OP•7/20/24, 11:53 AM

that's roughly how we're designing d1 dynamic bindings

Max (@rozenmd)OP•7/20/24, 11:58 AM

the migrations story becomes "fun" with that though, since you can now make potentially millions of DBs, we don't want migrations to simultaneously wake up millions of DBs

MMax (@rozenmd)that's roughly how we're designing d1 dynamic bindings

marko.333•7/20/24, 1:19 PM

OK, great to know that more coolness is on the way.
To add another dimension of complexity - hopefully there is also some form of integration into "Gradual Deployments"?
https://developers.cloudflare.com/workers/configuration/versions-and-deployments/gradual-deployments/
Maybe that could be part of the story to ease the cost of migrations?
Btw, is there similar work in-progress to support dynamic binding (and sharding) for Queues?
Thx Max.

Cory•7/20/24, 8:51 PM

ARe there any plans to be able to subscribe to updates?

JoeDoe•7/21/24, 6:30 AM

Is there some client library or something that I can use to access D1 database remotely, but still use the local one for testing without having to write double queries for the remote and local one?

mohitgangrade•7/21/24, 7:09 AM

[ERROR] not authorized: SQLITE_AUTH

I've even tried creating a custom token and uploading the SQL file using the REST API. I keep getting this error after the file gets done uploading.

you're missing quotes around the id, should be `WHERE id = '...'`

Similar Threads

Similar Threads

Similar Threads