Cloudflare Developers•3y ago

does d1 support foreign keys?

Ccodebam does d1 support foreign keys?

Cyb3r-Jak3•7/29/23, 2:54 AM

Yeah it does. See WIP docs d1-database

CCyb3r-Jak3 Yeah it does. See WIP docs https://discord.com/channels/595317990191398933/99206...

codebamOP•7/29/23, 2:55 AM

thank you

codebamOP•7/29/23, 2:56 AM

what about auto increment? is that supported or do I just have to use random uuids?

Hyper•7/29/23, 3:51 AM

Hey guys. Im wondering when transactions will be supported on D1. Would love to be able to simplify database integrity maintenance

Ccodebam what about auto increment? is that supported or do I just have to use random uui...

Matt Silverlock•7/29/23, 11:43 AM

By default there is an automatic rowid column. You can also specify your own col_name INT PRIMARY KEYcol_name INT PRIMARY KEY which will also be auto incrementing. We haven’t yet published docs on this, but this applies: https://www.sqlite.org/rowidtable.html

HHyper Hey guys. Im wondering when transactions will be supported on D1. Would love to ...

Matt Silverlock•7/29/23, 11:43 AM

Do you mean JS transactions? We don’t have an ETA we can share.

MMatt Silverlock Do you mean JS transactions? We don’t have an ETA we can share.

Hyper•7/29/23, 12:07 PM

I’m a little confused. I thought transactions were not supported at all. Does this mean I can write transactions in SQL and they would work fine? For example if i’m using an orm that generates SQL of the transaction and executes it against D1, will that work normally?

HHyper I’m a little confused. I thought transactions were not supported at all. Does th...

Matt Silverlock•7/29/23, 1:10 PM

All queries are in an implicit transaction for D1.

HHyper I’m a little confused. I thought transactions were not supported at all. Does th...

Matt Silverlock•7/29/23, 1:11 PM

Some folks want a separate, callback-driven JS API that allows you to combine SQL + JS —> that part is further out.

Hyper•7/29/23, 6:29 PM

Gotcha

john mcafee•7/29/23, 8:22 PM

is there a graphical way of working with D1?

Jjohn mcafee is there a graphical way of working with D1?

Cyb3r-Jak3•7/29/23, 8:22 PM

There is a console with dashboard

john mcafee•7/29/23, 8:26 PM

hmmm

john mcafee•7/29/23, 8:26 PM

trying to find the easiest way to manage like 1,000,000 rows

Jjohn mcafee trying to find the easiest way to manage like 1,000,000 rows

Cyb3r-Jak3•7/29/23, 8:33 PM

Manage how? Like query them?

john mcafee•7/29/23, 8:38 PM

like configure / edit

Cyb3r-Jak3•7/29/23, 8:39 PM

Probabaly the console in the dasboard

john mcafee•7/29/23, 8:39 PM

currently managin my database via google sheets, exporting to csv then importing into my sql database lol

john mcafee•7/29/23, 8:39 PM

its a nightmare

ZZiga Zajc It's possible to move old D1 to new one?

Matt Silverlock•7/30/23, 11:11 AM

Manually, yes. Take a backup, import it into a new DB. https://developers.cloudflare.com/d1/learning/backups/#downloading-a-backup-locally

Backups (Legacy) · Cloudflare D1 docs

D1 has built-in support for creating and restoring backups of your databases, including support for scheduled automatic backups and manual backup …

Cyb3r-Jak3•7/30/23, 12:19 PM

I believe there is no planned auto migration.
The new backend will no longer have backups and only time travel

Cyb3r-Jak3•7/30/23, 12:27 PM

My guess is you missed the converting step https://developers.cloudflare.com/d1/learning/importing-data/#converting-sqlite-database-files

CCole Xemi Is there a way to export a DB from the experimental backend?

Matt Silverlock•7/30/23, 3:53 PM

Not at the moment. Prioritizing larger DBs, performance, and bringing branching & cloning to Time Travel first.

MMatt Silverlock Not at the moment. Prioritizing larger DBs, performance, and bringing branching ...

Sameer Ali•7/30/23, 8:37 PM

First one is the most exciting and much needed! Larger DBs!

MMatt Silverlock Not at the moment. Prioritizing larger DBs, performance, and bringing branching ...

Bram•7/30/23, 9:22 PM

question on the "larger databases" part, is the plan to (eventually) to support large databases of 100GB - 500GB?

Unsmart•7/30/23, 9:25 PM

This was the last message in regards to DB size and based on it I'd assume under 100GB d1-database

Unsmart•7/30/23, 9:28 PM

(also scroll down a bit for the talk about adding some form of way for you to shard a db)

Bram•7/30/23, 9:39 PM

thx, sharding would be completely reasonable of course

λ.ςζ•7/31/23, 4:04 PM

is it possible to get a dump of D1 (alpha) database?

λ.ςζ•7/31/23, 4:09 PM

could you point me how? i couldn't find anything helpful

λ.ςζ•7/31/23, 4:11 PM

oh. i've tried that.

Experimental DBs do not support backups yet

Experimental DBs do not support backups yet

does d1 support foreign keys?

Similar Threads

Similar Threads

Similar Threads