# Multi-tenancy and Database-per-User Design in Postgres

DevFeed: [Multi-tenancy and Database-per-User Design in Postgres](<https://devfeed.tech/articles/multi-tenancy-and-database-per-user-design-in-postgres-5587.md>)

Original publisher: [Read original article](<https://neon.com/blog/multi-tenancy-and-database-per-user-design-in-postgres>)

Author: Dian M Fay

Published: 2024-08-29T18:00:25Z

Content type: article

Language: en

Sources: [Blog -- Neon Docs](<https://devfeed.tech/sources/blog-neon-docs.md>)

Topics: [Per-user Database](<https://devfeed.tech/topics/per-user-database.md>), [Multi-tenancy](<https://devfeed.tech/topics/multi-tenancy.md>), [data-architecture](<https://devfeed.tech/topics/data-architecture.md>), [Database](<https://devfeed.tech/topics/database.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [Serverless](<https://devfeed.tech/topics/serverless.md>), [Architecture & Design](<https://devfeed.tech/topics/architecture-design.md>)

Tags: [architectures](<https://devfeed.tech/tags/architectures.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [data-architecture](<https://devfeed.tech/tags/data-architecture.md>), [database](<https://devfeed.tech/tags/database.md>), [development](<https://devfeed.tech/tags/development.md>), [multi-tenancy](<https://devfeed.tech/tags/multi-tenancy.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [product](<https://devfeed.tech/tags/product.md>), [schema](<https://devfeed.tech/tags/schema.md>), [serverless](<https://devfeed.tech/tags/serverless.md>)

## AI overview

This article introduces a series about building database-per-user applications with Postgres and Neon. It outlines the evolution of multi-tenant architectures--shared schema, schema-per-user, and database-per-user--and explains the tradeoff between stronger data isolation and greater operational complexity. It also describes how Neon's serverless design and hierarchy of projects, branches, and databases may affect data architecture and application design.

## Source excerpt

Many Neon users aren't just storing their own information, but host data on behalf of many clients or customers, commonly called tenants. Over the decades, approaches to these multi-tenant data architectures have evolved in three main directions: shared schema, schema-per-user, a...