Tag: database
All the articles with the tag "database".
-
Row-Level Security in PostgreSQL: Keep Tenant Data in the Database
A practical guide to PostgreSQL Row-Level Security (RLS): tenant isolation, policies, application identity, common pitfalls, and a production-ready setup.
-
JSON vs JSONB in PostgreSQL
PostgreSQL offers both JSON and JSONB types for flexible schemas. Discover how JSONB binary format, TOAST compression, and GIN indexes make it the superior choice for querying, while JSON remains ideal for simple storage.
-
Multi-Tenant CRM Schema Design: Typed Columns vs JSONB
How do you design a database schema for a multi-tenant CRM where each company has different fields and data requirements? Explore two proven approaches: typed columns with EAV pattern and flexible JSONB documents.
-
Binary Trees vs B-Trees in Databases
At first glance, binary trees seem perfect for databases with their O(log n) complexity. But when data moves from memory to disk, everything changes. Discover why databases choose B-Trees over binary trees and how I/O costs reshape algorithmic efficiency.
-
Database Isolation Levels: Performance Impact and Trade-offs
Understanding the impact of different isolation levels on database performance and how to choose the right one for your application needs.