that's weird, if you go to your system's shell or terminal and type `date`, what's the output?
that's weird, if you go to your system's shell or terminal and type
date, what's the output?
WTue 16 Jul 2024 10:17:08 AM EDT
WIt states I should be able to restore today but I can't unfortunately, right when I needed it.
Mthis might sound crazy, but can you change your system's timezone to London (UTC+1) and refresh?
Mlooks like a bug in how the UI has handled timezones
WYes that works... I should've never left the UK huh
WThanks for figuring that out. I'll know for next time I botch a migration.
MHopefully my hotfix lands before then 
Kwhy is my rows read so high?
Myou're looking at the number of queries, not row metrics
Mqueries that don't use indexes often scan significantly more data than they return
Mhotfix rolled out, you shouldn't see this happen again
WYeah looks like it's working for me now. Thanks!
KWhich day is it now?
KI've raised it to the team :meowthinking:
KDoes watching db on dashboard also read rows ? or sorting?
Dhelp
RHi 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
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
Myep, reading your db in the dash counts as reads
Mmany reasons, not just one - new dbs run requests about 40x faster to start with
Malso 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
HOne 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
Interact with Cloudflare's products and services via the Cloudflare API
KI'm using restful API query, why always got this?
Mwhats your input
K
KI also changed other sql command, but not working as well
Myou're missing quotes around the id, should be
WHERE id = '...'Knot works
Msingle quotes*
Kno ��
Mwait why is it form-data
MInteract with Cloudflare's products and services via the Cloudflare API
Khmm OK, so raw works
Zi see there are two tables in my database
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?
forms when i tried command npx 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?
Dwondering if the 10GB disk limit would be increased down the line or is that something unlikely to happen?
DThx for that, that’ll be perfect for my use case.
WHeyo! 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
https://www.npmjs.com/package/seed-d1
npm
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-d1. There are no other projects in the npm registry using seed-d1.
BSee the message that I'm going to quote in my next message
B^
BLast update from an employee that works on D1
