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
Unknown User•8mo ago
Message Not Public
Sign In & Join Server To View
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"
Unknown User•8mo ago
Message Not Public
Sign In & Join Server To View
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
Unknown User•8mo ago
Message Not Public
Sign In & Join Server To View
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•8mo 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•8mo ago
Message Not Public
Sign In & Join Server To View
joins work in sqlite
Unknown User•8mo 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•8mo ago
Message Not Public
Sign In & Join Server To View