The latest articles on DEV Community by Giritharan (@giri14mct). https://dev.to/giri14mct https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F641479%2F7f31b88e-e952-4f36-ab3f-5d48e4f67bfa.png https://dev.to/giri14mct en Giritharan Fri, 15 Sep 2023 16:00:05 +0000 https://dev.to/giri14mct/answer-how-do-i-switch-from-1-database-to-1-database-per-subdomain-rails-1bp https://dev.to/giri14mct/answer-how-do-i-switch-from-1-database-to-1-database-per-subdomain-rails-1bp <div class="ltag__stackexchange--container"> <div class="ltag__stackexchange--title-container"> <div class="ltag__stackexchange--title"> <div class="ltag__stackexchange--header"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--AoTUKOcU--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_800/https://dev.to/assets/stackoverflow-logo-b42691ae545e4810b105ee957979a853a696085e67e43ee14c5699cf3e890fb4.svg" alt=""> <a href="https://stackoverflow.com/questions/76929516/how-do-i-switch-from-1-database-to-1-database-per-subdomain-rails/77113782#77113782" rel="noopener noreferrer"> <span class="title-flare">answer</span> re: How do I switch from 1 database to 1 database per subdomain rails </a> </div> <div class="ltag__stackexchange--post-metadata"> <span>Sep 15 '23</span> </div> </div> <a class="ltag__stackexchange--score-container" href="https://stackoverflow.com/questions/76929516/how-do-i-switch-from-1-database-to-1-database-per-subdomain-rails/77113782#77113782" rel="noopener noreferrer"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--oeieW07A--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_800/https://dev.to/assets/stackexchange-arrow-up-eff2e2849e67d156181d258e38802c0b57fa011f74164a7f97675ca3b6ab756b.svg" alt=""> <div class="ltag__stackexchange--score-number"> 0 </div> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--h2-sXgSn--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_800/https://dev.to/assets/stackexchange-arrow-down-4349fac0dd932d284fab7e4dd9846f19a3710558efde0d2dfd05897f3eeb9aba.svg" alt=""> </a> </div> <div class="ltag__stackexchange--body"> <p>Instead of making seperate database try to do with different schema.</p> <p>It means create different tenant for each customer in db. In <em><strong>psql</strong></em> by default it supports the multitenancy concept.</p> <p>When you are planned to use <em><strong>apartment gem</strong></em> that was the best choice for requirement. Because it makes much easier…</p> </div> <div class="ltag__stackexchange--btn--container"> <a href="https://stackoverflow.com/questions/76929516/how-do-i-switch-from-1-database-to-1-database-per-subdomain-rails/77113782#77113782" class="ltag__stackexchange--btn" rel="noopener noreferrer">Open Full Answer</a> </div> </div> Giritharan Fri, 15 Sep 2023 13:50:25 +0000 https://dev.to/giri14mct/answer-how-to-avoid-n1-when-reindexing-models-with-searchkick-53a8 https://dev.to/giri14mct/answer-how-to-avoid-n1-when-reindexing-models-with-searchkick-53a8 <div class="ltag__stackexchange--container"> <div class="ltag__stackexchange--title-container"> <div class="ltag__stackexchange--title"> <div class="ltag__stackexchange--header"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--AoTUKOcU--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_800/https://dev.to/assets/stackoverflow-logo-b42691ae545e4810b105ee957979a853a696085e67e43ee14c5699cf3e890fb4.svg" alt=""> <a href="https://stackoverflow.com/questions/77052828/how-to-avoid-n1-when-reindexing-models-with-searchkick/77112744#77112744" rel="noopener noreferrer"> <span class="title-flare">answer</span> re: How to avoid N+1 when reindexing models with Searchkick </a> </div> <div class="ltag__stackexchange--post-metadata"> <span>Sep 15 '23</span> </div> </div> <a class="ltag__stackexchange--score-container" href="https://stackoverflow.com/questions/77052828/how-to-avoid-n1-when-reindexing-models-with-searchkick/77112744#77112744" rel="noopener noreferrer"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--oeieW07A--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_800/https://dev.to/assets/stackexchange-arrow-up-eff2e2849e67d156181d258e38802c0b57fa011f74164a7f97675ca3b6ab756b.svg" alt=""> <div class="ltag__stackexchange--score-number"> 0 </div> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--h2-sXgSn--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_800/https://dev.to/assets/stackexchange-arrow-down-4349fac0dd932d284fab7e4dd9846f19a3710558efde0d2dfd05897f3eeb9aba.svg" alt=""> </a> </div> <div class="ltag__stackexchange--body"> <p>Hopefully in searchkick eager load method is available, we can use includes with help of the <em>search_import</em> method.</p> <p>You can refer more about on searchkick documentation <a href="https://github.com/ankane/searchkick#performant-conversions" rel="nofollow noreferrer">here</a>.</p> <p>From above sample data, i have seen your program table have has one association with provider, category, etc. with help of that…</p> </div> <div class="ltag__stackexchange--btn--container"> <a href="https://stackoverflow.com/questions/77052828/how-to-avoid-n1-when-reindexing-models-with-searchkick/77112744#77112744" class="ltag__stackexchange--btn" rel="noopener noreferrer">Open Full Answer</a> </div> </div>