How a few lines of code reduced database load by a few million queriesBack when I originally published Slonik PostgreSQL client for Node.js, I was working with large datasets, inserting tens of millions of…Oct 7, 2022A response icon4Oct 7, 2022A response icon4
Load-balancing PostgreSQL queries between read-only and read-write instancesScaling databases is hard. However, perhaps the lowest hanging fruit is introducing read-only replicas.Oct 6, 2022A response icon1Oct 6, 2022A response icon1
Building advanced SQL search from a user text inputWe are going to build a program that parses user search query and serializes it into a SQL statement. Here is an example of a search query:Sep 30, 2022Sep 30, 2022
Migrating from Cypress to Playwright using GPT3Cypress and @playwright/test are two competing integration testing frameworks. We have been using Cypress for a long time but recently made…Sep 7, 2022A response icon3Sep 7, 2022A response icon3
Validating PostgreSQL results & inferring query static typesMost of the bugs come from misaligned expectations. When working with databases, the first line of defense is to type the expected query…Aug 5, 2022Aug 5, 2022
What makes a good commitFirst, the main goal of a commit is to introduce an atomic change.Jun 27, 2022A response icon2Jun 27, 2022A response icon2
CTO vs Head of EngineeringWhat is the difference between CTO and Head of Engineering / VP of Technology at a 30–100 people company?Aug 10, 2021A response icon10Aug 10, 2021A response icon10
Redesigning Remote Team CultureAs the world becomes “virtual first”, businesses need to step up their company culture game beyond motivational posters in the office.Oct 26, 2020Oct 26, 2020