Cloudflare Developers•2y ago

Does watching db on dashboard also read rows ? or sorting?

Hharshil1712 You want to use D1 outside of a worker/pages project? Did I understand it correc...

Disciple of Caoximeihao•7/17/24, 5:03 AM

yes

Disciple of Caoximeihao•7/17/24, 5:03 AM

help

RMR•7/17/24, 5:36 AM

Hi CF Team
I just trying do a simple query (select * from table) from my local that use d1 remote, and it give me response 2s in avg, is this normal?
Will this happen also if the code deployed to cloudflare worker?
Thank you

KKartoffel🟢🟡🔴Does watching db on dashboard also read rows ? or sorting?

Max (@rozenmd)•7/17/24, 6:12 AM

yep, reading your db in the dash counts as reads

PPerry Sahnow Is there a specific reason that old D1 databases can't be auto migrated? Will th...

Max (@rozenmd)•7/17/24, 6:14 AM

many reasons, not just one - new dbs run requests about 40x faster to start with

Max (@rozenmd)•7/17/24, 6:35 AM

also we recently optimised backups for alpha, so if before your DB was too large to backup (a common bug in alpha dbs), you should be able to manually create a backup and see it show up in your list of backups for download

DDisciple of Caoximeihao yes

harshil1712•7/17/24, 9:08 AM

One that I can think of is using the REST API (https://developers.cloudflare.com/api/operations/cloudflare-d1-create-database). But this would not performant. Another approach is to deploy a Worker and use it as a proxy

Cloudflare API Documentation

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

Kartoffel🟢🟡🔴OP•7/17/24, 1:57 PM

I'm using restful API query, why always got this?

KKartoffel🟢🟡🔴I'm using restful API query, why always got this?

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

whats your input

MMax (@rozenmd)whats your input

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

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

I also changed other sql command, but not working as well

KKartoffel🟢🟡🔴Click to see attachment

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

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

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

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

not works

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

single quotes*

MMax (@rozenmd)single quotes*

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

no ��

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

wait why is it form-data

Max (@rozenmd)•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🟢🟡🔴OP•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

Does watching db on dashboard also read rows ? or sorting?

Similar Threads

Similar Threads

Similar Threads