Should you use a Single Database or Multiple Databases for your SaaS project?

Originally published at:

Have you ever wondered how large SaaS applications are built? Do they use a single database for all clients or multiple databases? Let’s say you have a SaaS-based application that has data stored in a database and multiple customers, also known as tenants or clients, using the same application. Each tenant has their own set…

1 Like

Great share! An additional advantage of multiple databases is that it makes it easier to perform a refresh of client databases.

1 Like

Definitely, I tend to do this using laravel…

php artisan migrate:refresh --tenant=1

There’s also this great talk by Tom Schlick on multitenancy strategies. Give it a what when u get the time.