@sd141414: Most multitenant architecture decisions get made fast, early, and without enough context. The shared vs. separate schema question looks technical. It is actually a business model question. It determines what you can promise in a security review 18 months from now. Make the call deliberately, or let a procurement team make it for you later.

Steve | Systems & AI
Steve | Systems & AI
Open In TikTok:
Region: US
Monday 27 April 2026 13:40:23 GMT
39534
2144
94
263

Music

Download

Comments

diegojancic
Diego Jancic | Software & AI :
I've seen companies sell Enterprise licenses worth 100k+ per year with a shared schema. Vendor security questionnaires rarely change the outcome.
2026-04-28 01:29:29
27
vissjesdief
kachingkahahaha :
are there any ideas how you would do this for PostgreSQL? i have multi tenant structure at place with schema isolation works great yet when the customer base grows the amount of schema will grow and this can cause the connection pools to get exhausted. how would you solve this?
2026-04-28 01:29:41
1
ziggy.from.owise
ziggy from Owise :
Dude you are bringing us down. We want to believe we can just tell Claude to “do it right!” :-)
2026-04-27 16:54:36
12
hermit969
hermit969 :
isn’t this RLS?
2026-04-27 16:56:17
4
geekindad
GeekinDad :
Why are you pulling from my daily nightmares lol
2026-04-27 14:28:27
5
giggetygoober
giggetygoober :
I build literally everything multi tenant with tenant ID baked onto every table for plug and play sharding
2026-05-01 09:09:44
4
ramdaneoualitsen
Ramdane Oualitsen :
i do separate. it was easier cause that was mongodb
2026-04-27 20:38:12
0
christopherbundi
Topaz639 :
Learning database architect , deeper than before am tired of building software with AI I don't understand the architecture
2026-05-16 20:51:38
0
proficienttiktoker
proficienttiktoker :
I love all your videos. What do you recommend doing with all the info tho. Like do you have skills or aggregation of all this info somewhere? Like is the paid stuff on ur site all this info to give to an agent?
2026-04-30 03:16:52
5
izzizen
Dev :
How about shared DB for lower tiers and whole DB for enterprise tier 🤷‍♀️
2026-04-27 21:23:39
2
jmrooning
Jason Rooney :
Separate db, same instance. DI the db at the edge. Internals of the app doesn’t care. No data leakage, easy to backup/restore individually. Small cost in managing connection pools.
2026-05-10 00:24:44
0
larp_lore
LARP Lore :
So is logical isolation enterprise architecture?
2026-04-27 18:43:58
0
vanpancake77
vanpancake77 :
Are you basically saying that individual schemas require inherent separation whereas shared schemas require other evidence of logical separation
2026-04-28 05:12:33
1
conrad.bekondo
Conrad Bekondo :
I'd just enable RLS
2026-04-28 19:33:00
2
junatan11
junatan the man :
Im working on this right now 😂😂
2026-04-27 23:34:31
1
soleil_faith
Sheriff :
Oh boy this is a sign. Seeing this means I have to plan the architecture for implementation gradually .
2026-04-27 17:25:10
5
nitesh2.0
Nitesh2.0 :
So I shouldn’t be worried for a 500 user app about this if I have rls on
2026-04-28 04:17:55
1
hermit969
hermit969 :
separate schemas also nightmare to update
2026-04-27 17:00:40
17
tok_tango
No name :
Full isolation is not worth it unless you’re a specific size and you can spin up and manage a separate managed instance for a client the revenue from which is worth the hassle (and I’m talking north of 500k annually)
2026-04-27 16:32:38
4
basementpilot
Basement Pilot :
Also when it comes to banks, you mostly need to isolate on hardware level as well
2026-04-27 16:30:58
1
sanifu.run
David Ndungu :
What do you think of PostgreSQL row level security instead of separate schemas?
2026-04-27 18:32:52
1
erenklk11
Eren :
thank you for this knowledge. you don't really learn this in uni or AI. you learn this with experience.
2026-04-27 15:14:33
1
will3278
will :
Atlassian did database per tenant for their first go at cloud and it was a huge nightmare, had to rewrite it as a true multi tenant architecture. Just couldn’t get density otherwise, along with many other issues
2026-04-29 13:44:29
1
it_is_2023
NoMore :
I can say yes on PostgreSQL with RLS policies the only problem is platform users how to Give level of accesses
2026-04-28 18:23:41
1
nicolacaver
nicolacaver :
Nobody chooses shared schema. How is it easier to manage? It's harder to create (because you now have to think in the logical separation besides data), harder to manage(because you always have to take into consideration the tenant you are dealing with. That's like the perfect receipt for errors). The only thing it's easier is backup and migration. That's my opinion.
2026-05-13 11:53:16
0
To see more videos from user @sd141414, please go to the Tikwm homepage.

Other Videos


About