Database Tech with Fexingo: SQL, NoSQL, and Data Storage Conversations Titelbild

Database Tech with Fexingo: SQL, NoSQL, and Data Storage Conversations

Database Tech with Fexingo: SQL, NoSQL, and Data Storage Conversations

Von: Fexingo
Jetzt kostenlos hören, ohne Abo

Lucas and Luna explore the landscape of database technology, from relational SQL systems to document-based NoSQL and emerging storage paradigms. Each episode examines a specific database model—columnar stores, graph databases, time-series engines, or serverless SQL—and dissects its architecture, performance characteristics, and real-world tradeoffs. Lucas brings a journalist's rigor, questioning vendor claims and surfacing benchmark data; Luna pushes back with practitioner experience, asking how these systems behave under production loads. Together they compare when PostgreSQL's mature indexing wins over MongoDB's flexible schema, or why Snowflake's cloud-native approach may not suit every analytical workload. The show also probes deeper: the economics of data storage, the rise of NewSQL, and the implications of data gravity. Listeners will walk away understanding not just which database to choose, but why one design philosophy beats another for a given problem. What happens when your application's read pattern shifts from row-based to columnar? How do you evaluate consistency models without oversimplifying? This is the conversation for data engineers, architects, and technical leaders who need to make informed storage decisions. #SQL #NoSQL #DatabaseTech #DataStorage #PostgreSQL #MongoDB #Snowflake #TimeSeriesDB #GraphDatabase #ColumnarStorage #NewSQL #DataEngineering #Technology #FexingoBusiness #BusinessPodcast #DatabaseArchitecture #DataGravity #Benchmarking Keep every episode free: buymeacoffee.com/fexingo© 2026 Fexingo. All rights reserved. Ökonomie
Folgen
  • Why Database Snapshot Isolation Breaks at Write Skew

    Why Database Snapshot Isolation Breaks at Write Skew
    Jul 17 2026
    Episode 116 of Database Tech with Fexingo. Lucas and Luna dive into write skew, a subtle concurrency anomaly that breaks snapshot isolation even when individual transactions are consistent. Using the classic doctor-on-call scheduling example, they explain how PostgreSQL's default snapshot isolation can allow two overlapping transactions to violate a business rule without ever reading each other's data. They contrast this with serializable isolation, which uses predicate locks and serialization anomalies to catch write skew, and discuss real-world tradeoffs: performance cost versus correctness. If you've ever assumed MVCC means no conflicts, this episode will change your mind. Perfect for engineers using PostgreSQL, MySQL (with InnoDB), or any database relying on snapshot isolation. Includes concrete steps to test for write skew and when to escalate isolation levels. #WriteSkew #SnapshotIsolation #PostgreSQL #MVCC #ConcurrencyControl #DatabaseAnomalies #SerializableIsolation #PredicateLocks #DoctorOnCall #BusinessLogic #TransactionIsolation #SQL #NoSQL #DatabasePerformance #FexingoBusiness #TechnologyPodcast #DatabaseEngineering #Episode116 Keep every episode free: buymeacoffee.com/fexingo
    Mehr anzeigen Weniger anzeigen
    8 Min.
  • Why Database Multi-Tenancy Needs Tenant Isolation Not Shared Tables

    Why Database Multi-Tenancy Needs Tenant Isolation Not Shared Tables
    Jul 16 2026
    Episode 115 of Database Tech with Fexingo. Lucas and Luna drill into multi-tenant database design, using a real SaaS case: a mid-market CRM that hit a noisy-neighbor crisis when one tenant's bulk import saturated disk I/O for everyone. They contrast shared-table vs. schema-per-tenant vs. database-per-tenant architectures, explain why connection pooling and query plan caching break across tenants, and walk through the trade-offs of row-level security policies vs. dedicated pools. The episode lands on a hybrid pattern: tenant-aware routing with per-tenant connection pools and a shared metadata store. Listeners get a concrete decision framework for choosing isolation levels without over-engineering. Plus: why the ad-free model matters to a show that treats listeners like engineers, not audiences. #MultiTenancy #DatabaseArchitecture #TenantIsolation #SaaS #PostgreSQL #RowLevelSecurity #ConnectionPooling #NoisyNeighbor #SchemaPerTenant #DatabasePerTenant #SharedTable #Technology #FexingoBusiness #BusinessPodcast #DataEngineering #DatabasePerformance #CRMSystem #QueryPlanCaching Keep every episode free: buymeacoffee.com/fexingo
    Mehr anzeigen Weniger anzeigen
    10 Min.
  • Why Database Row-Level Security Hurts Query Performance

    Why Database Row-Level Security Hurts Query Performance
    Jul 16 2026
    Row-level security (RLS) is a powerful feature for multi-tenant databases, but it comes with a hidden cost: query performance can degrade significantly if not implemented carefully. In this episode, Lucas and Luna explore how RLS policies interact with query planners, indexing strategies, and connection pooling, using a real-world example of a SaaS platform that saw query latency spike by 300% after enabling RLS. They discuss why predicate pushdown fails, how to design policies that leverage partial indexes, and when to move security logic to the application layer instead. For any engineer dealing with multi-tenant architectures, this is a must-listen on balancing security with speed. #RowLevelSecurity #QueryPerformance #DatabaseSecurity #MultiTenant #PostgreSQL #PredicatePushdown #PartialIndex #QueryPlanner #ConnectionPooling #SaaS #DatabaseOptimization #TechPodcast #Technology #FexingoBusiness #BusinessPodcast #DatabaseDesign #SecurityVsPerformance #DataEngineering Keep every episode free: buymeacoffee.com/fexingo
    Mehr anzeigen Weniger anzeigen
    5 Min.
adbl_web_anon_alc_button_suppression_t1
Noch keine Rezensionen vorhanden