what does it mean migrations are not run in production ?
what does it mean migrations are not run in production ?
17 Replies
you can migrate your prod db by providing
--remote flagThis is why marketing is so important to be explicit. Some people still believe to this day that D1 is (actually) globally distributed:
- https://www.reddit.com/r/CloudFlare/comments/1c2a7im/is_d1_rest_api_performant_and_production_ready/kz8u3i5/
Reddit
cortadomaltese's comment on "Is D1 rest api performant and producti...
Explore this conversation and more from the CloudFlare community
sadly, yes, same misleading marketing problem
Then what does "Globally distributed" means here?
Yeah. It's globally distrubuted in the sense that I can create a DB in EU, US, etc. but individual DBs are not "distributed", or "replicated"
lol
Read replication is coming, and was talked about briefly in https://blog.cloudflare.com/making-full-stack-easier-d1-ga-hyperdrive-queues, but it's not here yet
In the case of D1 i understand its upcoming
But for R2 thats a bad look
Not the kind of thing i usually expect from Cloudflare, to be honest
whats the eta on d1 read replicas?
Yes, definitely. I enabled that and it solved my issue completely. Now the whole page load time is faster than on my VPS with a local mysql db.
Unknown User•9mo ago
Message Not Public
Sign In & Join Server To View
The concept is that you should be giving each of your users (or system components) their own database for only their data, rather than having one huge database everyone's combined data is stored in. It's about changing the way you think about the data storage in your application.
Understandably the 10GB limit sounds small, but in reality it is a lot of space for a database. You can fit millions of records into it while remaining under the limit. My biggest db for example has 15 million records across 200 tables, and is just over 2.5 GB.
Unknown User•9mo ago
Message Not Public
Sign In & Join Server To View
joins work in sqlite
Unknown User•9mo ago
Message Not Public
Sign In & Join Server To View
No, it's not possible at the moment. There is an ATTACH command in sqlite which can load in more databases but D1 hasn't implemented it, and I doubt they'll add it
Unknown User•9mo ago
Message Not Public
Sign In & Join Server To View