Secondary indices on associative entities in PostgreSQL vs. MySQLTL;DR: When modeling many-to-many relationships in MySQL, the secondary index on the associative entity should only contain the second…Apr 22Apr 22
Published inBluecore EngineeringLessons Learned SpelunkingEvery organization I’ve ever worked for, no matter how large or small, no matter how functional or dysfunctional, has had something that…Aug 23, 2022Aug 23, 2022
Published inBluecore Engineeringlazylru/generic — Proving ItWay back in the long-forgotten days of June 2021, I put up a post about LazyLRU, a least-recently-used cache that focuses on reducing lock…Mar 30, 2022Mar 30, 2022
Published inBluecore EngineeringLazyLRU: Laughing All the Way to ProductionUnderstanding our access patterns led Bluecore to consider a more efficient caching strategy. The whole thing started as a fun little joke…Jun 2, 2021Jun 2, 2021