```sql CREATE TABLE Players ( player_id INT PRIMARY KEY, player_name VARCHAR(50) NOT NULL, ser

CREATE TABLE Players (
  player_id INT PRIMARY KEY,
  player_name VARCHAR(50) NOT NULL,
  server_id INT,
  FOREIGN KEY (server_id) REFERENCES Servers(server_id)
);

CREATE TABLE Players (
  player_id INT PRIMARY KEY,
  player_name VARCHAR(50) NOT NULL,
  server_id INT,
  FOREIGN KEY (server_id) REFERENCES Servers(server_id)
);

CREATE TABLE Players (
  player_id INT PRIMARY KEY,
  player_name VARCHAR(50) NOT NULL,
  server_id INT,
  FOREIGN KEY (server_id) REFERENCES Servers(server_id)
);

CREATE TABLE Players (
  player_id INT PRIMARY KEY,
  player_name VARCHAR(50) NOT NULL,
  server_id INT,
  FOREIGN KEY (server_id) REFERENCES Servers(server_id)
);

Does D1 support this as well as junction tables

布布鲁诺普雷托 ```sql CREATE TABLE Players ( player_id INT PRIMARY KEY, player_name VARCHAR...

Matt Silverlock•7/15/24, 7:22 PM

Foreign keys? Yes. https://developers.cloudflare.com/d1/build-with-d1/foreign-keys/

Cloudflare Docs

Define foreign keys · Cloudflare D1 docs

D1 supports defining and enforcing foreign key constraints across tables in a database.

thipperz•7/16/24, 2:01 AM

i'm seeing some nice improvements to D1 dashboard (i.e. more rows per page and ordering finally) - keep it up!

wot•7/16/24, 12:55 PM

Won't let me select today for recovery. Earliest I could do was Yesterday at 23:59:59.

Wwot Won't let me select today for recovery. Earliest I could do was Yesterday at 23:...

Max (@rozenmd)•7/16/24, 1:54 PM

that's weird, if you go to your system's shell or terminal and type datedate, what's the output?

MMax (@rozenmd)that's weird, if you go to your system's shell or terminal and type `date`, what...

wot•7/16/24, 2:17 PM

Tue 16 Jul 2024 10:17:08 AM EDT

wot•7/16/24, 2:18 PM

It states I should be able to restore today but I can't unfortunately, right when I needed it.

Wwot It states I *should* be able to restore today but I can't unfortunately, right w...

Max (@rozenmd)•7/16/24, 2:44 PM

this might sound crazy, but can you change your system's timezone to London (UTC+1) and refresh?

Max (@rozenmd)•7/16/24, 2:44 PM

looks like a bug in how the UI has handled timezones

MMax (@rozenmd)this might sound crazy, but can you change your system's timezone to London (UTC...

wot•7/16/24, 2:57 PM

Yes that works... I should've never left the UK huh

wot•7/16/24, 2:58 PM

Thanks for figuring that out. I'll know for next time I botch a migration.

Wwot Thanks for figuring that out. I'll know for next time I botch a migration.

Max (@rozenmd)•7/16/24, 3:07 PM

Hopefully my hotfix lands before then

Kartoffel🟢🟡🔴•7/16/24, 5:18 PM

why is my rows read so high?

KKartoffel🟢🟡🔴why is my rows read so high?

Max (@rozenmd)•7/16/24, 5:24 PM

you're looking at the number of queries, not row metrics

Max (@rozenmd)•7/16/24, 5:24 PM

queries that don't use indexes often scan significantly more data than they return

Wwot Thanks for figuring that out. I'll know for next time I botch a migration.

Max (@rozenmd)•7/16/24, 8:11 PM

hotfix rolled out, you shouldn't see this happen again

MMax (@rozenmd)hotfix rolled out, you shouldn't see this happen again

wot•7/16/24, 8:17 PM

Yeah looks like it's working for me now. Thanks!

Kavatch•7/16/24, 9:53 PM

Which day is it now?

KKavatch Which day is it now? 😅

kian•7/16/24, 10:01 PM

I've raised it to the team :meowthinking:

MMax (@rozenmd)queries that don't use indexes often scan significantly more data than they retu...

Kartoffel🟢🟡🔴•7/17/24, 1:27 AM

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🟢🟡🔴•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🟢🟡🔴•7/17/24, 2:13 PM

Kartoffel🟢🟡🔴•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🟢🟡🔴•7/17/24, 2:21 PM

not works

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

single quotes*

MMax (@rozenmd)single quotes*

Kartoffel🟢🟡🔴•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🟢🟡🔴•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

```sql CREATE TABLE Players ( player_id INT PRIMARY KEY, player_name VARCHAR(50) NOT NULL, ser

Similar Threads

Similar Threads

Similar Threads