Gajus KuizinasHow 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
Gajus KuizinasLoad-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
Gajus KuizinasBuilding 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
Gajus KuizinasFully qualified names vs a jungle of importsOriginally published on ContraSep 11, 2022Sep 11, 2022
Gajus KuizinasMigrating 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
Gajus KuizinasValidating 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
Gajus KuizinasWhat makes a good commitFirst, the main goal of a commit is to introduce an atomic change.Jun 27, 20222Jun 27, 20222
Gajus KuizinasCTO 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
Gajus KuizinasRedesigning 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