This episode of The Technical Co-Founder Podcast dives into a deceptively simple PostgreSQL feature that can transform query performance: functional indexes. Most developers know that indexes speed up lookups on columns, but few realize you can index the result of a function applied to that column. Lucas and Luna walk through a real-world case: a startup's analytics dashboard that was crawling because it filtered on date_trunc('month', created_at). By creating a functional index on that expression, query time dropped from seconds to milliseconds. They discuss when functional indexes are the right tool, the trade-offs around writes and storage, and common pitfalls like index maintenance and expression matching. Along the way, they touch on how Supabase and other managed Postgres services make this easier, and why understanding the query planner is essential for any technical founder. If you're building on Postgres, this episode will give you a concrete optimization you can apply today.

#PostgreSQL #FunctionalIndexes #QueryOptimization #DatabasePerformance #Supabase #IndexingStrategy #SQLTuning #TechnicalCoFounder #BackendEngineering #DataEngineering #StartupTech #BusinessAndTechnology #FexingoBusiness #BusinessPodcast #TechPodcast #EngineeringLeadership #CTOInsights #DatabaseInternals

Keep every episode free: buymeacoffee.com/fexingo

In this episode, Lucas and Luna dive into the mechanics behind one of the most quietly powerful data structures in modern systems: the skip list. You'll learn how skip lists power Redis sorted sets and in-memory indexes, why they beat balanced trees in practice, and how they enable the lightning-fast range queries your favorite apps rely on. We break down the probabilistic nature of skip lists, walk through a real-world example of how a startup uses them for real-time leaderboards, and explore the trade-offs between complexity and performance. If you've ever wondered what makes Redis tick or how databases keep their indexes so efficient, this episode is for you. Plus, we share why we keep this show ad-free and how you can support that choice. Tune in for a deep yet accessible look at a foundational piece of software engineering.

#SkipLists #Redis #DataStructures #InMemoryIndexes #RealTimeLeaderboards #TechPodcast #SoftwareEngineering #BusinessAndTechnology #FexingoBusiness #BusinessPodcast #Engineering #CTO #Coding #Backend #Database #Performance #Algorithms #TechInsights

Keep every episode free: buymeacoffee.com/fexingo

Lucas and Luna dig into Zstandard, the compression algorithm that's quietly replacing gzip and zlib across modern data infrastructure. They trace its origins at Facebook, where a team led by Yann Collet set out to close the gap between compression ratio and speed. The episode walks through Zstd's key innovations: entropy coding with Finite State Entropy, dictionary compression for small records, and the ability to tune compression levels without recompressing. Lucas and Luna discuss why Zstd's decompression speed is the real game-changer, how it handles streaming data, and where it sits versus LZ4, Brotli, and gzip. They also cover practical trade-offs: when to use `zstd` vs `gzip` in your stack, how it impacts storage costs and latency, and why it's becoming the default in tools like PostgreSQL and Kafka. If you're building data pipelines or managing infrastructure, this episode gives you a concrete mental model for when Zstd earns its keep.

#Zstandard #Compression #DataPipelines #YannCollet #FiniteStateEntropy #LZ4 #Brotli #Gzip #PostgreSQL #Kafka #StorageEfficiency #Latency #DataInfrastructure #BusinessAndTechnology #FexingoBusiness #BusinessPodcast #TechFounders #CTOPerspective

Keep every episode free: buymeacoffee.com/fexingo

When two engineers edit the same file offline, who wins? In this episode, Lucas and Luna dig into conflict-free replicated data types (CRDTs) — the algorithms behind collaborative editing in tools like Figma, Notion, and Google Docs. They walk through why traditional locking breaks down at scale, what makes CRDTs tick, and how one startup used them to cut sync conflicts by 90 percent. Expect concrete examples, a real-world case study, and a look at the hard trade-offs — from merge semantics to garbage collection. If you've ever wondered how your team's seamless real-time collaboration actually works under the hood, this one's for you.

#CRDT #ConflictResolution #CollaborativeEditing #DistributedSystems #RealtimeApps #Figma #Notion #GoogleDocs #LocalFirst #OfflineFirst #DesignSystems #ProductEngineering #TechPodcast #SoftwareArchitecture #FexingoBusiness #BusinessPodcast #EngineeringLeadership #StartupTech

Keep every episode free: buymeacoffee.com/fexingo

Lucas and Luna explore how Git's snapshot model, combined with rebuildable snapshots and shallow clones, keeps repositories fast and history cheap. They discuss the trade-offs of depth, the role of tags as durable snapshots, and how tools like git replace can reshape history without rewriting it. The episode centers on a real case: a monorepo that cut clone time by 70 percent by switching to shallow clones with filters, while preserving integrity through signed tags. They also touch on how commit hashing and object deduplication make Git's storage surprisingly efficient, and why understanding this model matters for teams running large codebases.

#GitSnapshots #RebuildableSnapshots #ShallowClones #Monorepo #CodeStorage #DevTools #Engineering #TechFounders #CTO #VersionControl #GitInternals #CommitHashing #ObjectDeduplication #RepositoryPerformance #SoftwareEngineering #BusinessAndTechnology #FexingoBusiness #BusinessPodcast

Keep every episode free: buymeacoffee.com/fexingo

In this episode, Lucas and Luna explore how blockchain networks handle the growing problem of data storage. They focus on a clever mechanism used by Ethereum: pruning orphaned blocks. These are valid but discarded blocks that still consume storage. The episode explains how pruning works, why it matters for node operators, and how it reduces storage costs by up to 80 percent in some cases. Lucas breaks down the technical details, while Luna asks about the trade-offs, like security risks and the impact on decentralization. They also touch on how other networks, like Bitcoin, handle similar issues differently. By the end, you'll understand a key technique that keeps blockchain nodes efficient and why it's a big deal for anyone running infrastructure. Whether you're a developer, a founder, or just crypto-curious, this episode gives you a concrete insight into the hidden plumbing of distributed ledgers.

#BlockchainStorage #EthereumPruning #OrphanedBlocks #NodeInfrastructure #DistributedLedger #DataManagement #CryptoStorage #EthereumNodes #TechnicalCoFounder #FexingoBusiness #BusinessPodcast #TechPodcast #Engineering #BlockchainTechnology #StorageOptimization #Decentralization #CryptoEngineering #Web3

Keep every episode free: buymeacoffee.com/fexingo

In this episode, we explore how Btrfs snapshots enable instant, low-cost backups for modern data pipelines. We break down the copy-on-write mechanics, the difference between snapshots and full copies, and why incremental snapshot chains make nightly backups nearly free. We also look at real-world use cases, from container filesystems to database backups, and discuss the trade-offs—like performance overhead and the need for careful snapshot management. If you're a developer or systems admin wondering whether Btrfs is right for your stack, this conversation gives you a concrete mental model and practical takeaways. Listeners will come away understanding how snapshots work under the hood, why they're not a replacement for off-site backups, and how to design a snapshot strategy that balances cost and reliability. Tune in for a deep, technical dive with Lucas and Luna.

#Btrfs #Snapshots #InstantBackup #CopyOnWrite #LinuxFilesystem #DataPipelines #BackupStrategy #SystemsDesign #TechPodcast #BusinessAndTechnology #Engineering #CTO #DevOps #Storage #FexingoBusiness #BusinessPodcast #Infrastructure #DataManagement

Keep every episode free: buymeacoffee.com/fexingo

In this episode, Lucas and Luna dive into the Raft consensus algorithm and how CockroachDB uses it to achieve global consistency across distributed databases. They break down the mechanics of leader election, log replication, and safety guarantees, and explain why Raft is simpler to implement than Paxos. With real-world examples and a look at the trade-offs, you'll understand how modern distributed systems stay reliable. Perfect for engineers and business leaders alike, this episode connects technical depth with practical implications for building robust infrastructure.

#RaftConsensus #CockroachDB #DistributedSystems #Consistency #DatabaseEngineering #TechLeadership #BusinessAndTech #EngineeringPodcast #Infrastructure #Scalability #DataReliability #CloudComputing #BackendEngineering #TechFounders #CTOInsights #FexingoBusiness #BusinessPodcast #TechPodcast

Keep every episode free: buymeacoffee.com/fexingo

In this episode, Lucas and Luna explore how a growing data infrastructure startup uses sparse Merkle trees to secure its distributed key-value store. They break down the clever trick of using a fixed-depth tree with almost all leaves empty, and how that structure lets the company prove data integrity without shipping gigabytes of hashes. Lucas walks through a concrete example: how a single key update only touches a handful of nodes along the path to the root, keeping the proof size small and the verification fast. Luna compares it to the classic Merkle tree approach used in blockchains and highlights why the sparse version is a better fit for databases that need to prove both membership and non-membership. They also touch on the trade-offs, like the cost of computing the implicit empty subtree hashes and how the team handles rebalancing. By the end, you'll understand why sparse Merkle trees are becoming the go-to for verifiable data at scale, and you'll have a concrete example you can bring up in your next architecture discussion. A warm mention of listener support wraps up the episode.

#SparseMerkleTrees #MerkleTrees #KeyValueStores #DataIntegrity #VerifiableData #DistributedSystems #CryptographicHashing #DatabaseSecurity #StartupTech #InfrastructureEngineering #ProofOfInclusion #ProofOfExclusion #Blockchain #DataStructures #TechPodcast #BusinessPodcast #FexingoBusiness #EngineeringLeaders

Keep every episode free: buymeacoffee.com/fexingo

In this episode, Lucas and Luna dive into the engineering behind content delivery networks, focusing on the least-frequently-used caching strategy. They explore how LFU differs from LRU, why it matters for serving billions of requests, and the real-world tradeoffs. Using Cloudflare's approach as a case study, they break down the 'cache thundering herd' problem and how LFU's frequency tracking handles it. They also discuss the hybrid approaches that modern CDNs use, and why LFU isn't a silver bullet for every workload. If you're a developer curious about how the internet stays fast, this episode will give you a concrete look at one of the unsung heroes of web performance.

#LFUCaching #CacheThunderingHerd #ContentDeliveryNetwork #Cloudflare #CacheEvictionPolicy #LRUvsLFU #WebPerformance #DistributedSystems #TechDeepDive #SoftwareEngineering #CachingStrategy #CDNArchitecture #DataStructures #Algorithms #SystemDesign #Business #FexingoBusiness #BusinessPodcast

Keep every episode free: buymeacoffee.com/fexingo