(1 min read) I needed a reliable way to take the indexes from a staging instance and ensure they're replicated to production. The following _MONGOSH code loops over every collection and then every index in the collection, creating a "createIndex" command for each combination. This makes it trival to
(1 min read) From the postgres docs on unique indexes: When an index is declared unique, multiple table rows with equal indexed values are not allowed. Null values are not considered equal. A multicolumn unique index will only reject cases where all indexed columns are equal in multiple rows. Unfortunately, disabling distinct null
(4 min read) Building a serverless-friendly queue system continues to be an adventure. Recently, we had to say goodbye to our Redis queues and replace them with something more durable. The journey there involved a lot about time storage, visibility windows, and how the most popular queue solutions solve these problem. So, if
(3 min read) Before we had k-ordered ids (and in legacy systems) the sort order needed to be baked into your relay cursors.
(4 min read) When there's no amount of "or", "and", and "exists" that can make your Hasura permissions simple, pull out the postgres view and simplify a huge part of your permissions query.