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…3 min read·Oct 7, 2022--4--4
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.4 min read·Oct 6, 2022--1--1
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:1 min read·Sep 30, 2022----
Gajus KuizinasFully qualified names vs a jungle of importsOriginally published on Contra3 min read·Sep 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…1 min read·Sep 7, 2022--3--3
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…4 min read·Aug 5, 2022----
Gajus KuizinasWhat makes a good commitFirst, the main goal of a commit is to introduce an atomic change.3 min read·Jun 27, 2022--2--2
Gajus KuizinasCTO vs Head of EngineeringWhat is the difference between CTO and Head of Engineering / VP of Technology at a 30–100 people company?4 min read·Aug 10, 2021--10--10
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.3 min read·Oct 26, 2020----