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, 20224Oct 7, 20224
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, 20221Oct 6, 20221
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, 20223Sep 7, 20223
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, 20222Jun 27, 20222
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, 202110Aug 10, 202110
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