Ask HN: Has anybody shipped a web app at scale with 1 DB per account?
23 by bradgessler | 28 comments on Hacker News.
A common way of deploying a web application database at scale is to setup a MySQL or Postgres server, create one table for all customers, and have an account_id or owner_if field and let the application code handle security. This makes it easier to run database migrations and upgrade code per customer all at once. I’m curious if anybody has taken the approach of provisioning one database per account? This means you’d have to run migrations per account and keep track of all the migration versions and statuses somewhere. Additionally, if an application has custom fields or columns, the differences would have to be tracked somehow and name space collisions managed. Has anybody done this? Particularly with Rails? What kinda of tools or processes did you learn when you did it? Would you do it again? What are some interesting trade offs between the two approaches?
Post Top Ad
Monday, May 25, 2020

Home
Hacker News
New top story on Hacker News: Ask HN: Has anybody shipped a web app at scale with 1 DB per account?
New top story on Hacker News: Ask HN: Has anybody shipped a web app at scale with 1 DB per account?
Tags
# Hacker News
Share This
About Unknown
Templatesyard is a blogger resources site is a provider of high quality blogger template with premium looking layout and robust design. The main mission of templatesyard is to provide the best quality blogger templates which are professionally designed and perfectlly seo optimized to deliver best result for your blog.
Newer Article
New top story on Hacker News: SCI Runs OpenVMS on x86-64
Older Article
New top story on Hacker News: Wat-Sharp: A C# Wrapper Around Wat to Unit Test Your C# Godot Games
New top story on Hacker News: The Alien-Life Summit (2013)
AnonymousMay 23, 2023New top story on Hacker News: Show HN: I'm open sourcing Harmonic, the Android Hacker News client
AnonymousMay 23, 2023New top story on Hacker News: What It Was Like to Live Inside Habitat 67
AnonymousMay 22, 2023
Labels:
Hacker News
Subscribe to:
Post Comments (Atom)
तूने होंठो से पिलाई... पर 3 लड़कियों ने किया बारिश में डांस, बीच सड़क पर हुईं लोट-पोट
Panchayat Actress Rain Dance Video: पूरे देश में बारिश का मौसम है. हर जगह बारिश हो रही है. ऐसे में मुंबई की बारिश का तो क्या ही कहना. तमाम ट...
No comments:
Post a Comment