Monthly Archives: August 2023

SQL Antipatterns: Then and Now

Posted on August 30, 2023 by Siddharth Jain

I am an absolute fan of Bill Karwin’s SQL Antipatterns book. I rate it amongst my top 3 database books together with Martin Kleppmann’s Designing Data-Intensive Applications. However, its good to think twice about some of the advice in the … Continue reading →

Posted in Computers, programming, Software | Tagged , | Leave a comment

Understanding concurrency control in Postgres and comparing with MySQL

Posted on August 20, 2023 by Siddharth Jain

Concurrency control is one of the key things to understand in any database. It is the I in ACID. From MySQL docs (applies to Postgres as well): the isolation level is the setting that fine-tunes the balance between performance and … Continue reading →

Posted in Computers, programming, Software | Tagged | Leave a comment

Do we need NUMERIC data type to store financial data in Postgres?

Posted on August 8, 2023 by Siddharth Jain

TL;DR: Conventional wisdom dictates that one should use the NUMERIC data type to store financial data to protect from rounding errors that happen with floating point arithmetic (refer IEEE 754 standard). And on JS side we should use a library … Continue reading →

Posted in Computers, programming, Software | Tagged | Leave a comment

If you could only install 10 applications on your Mac

Posted on August 3, 2023 by Siddharth Jain

what would they be? here is my list: let me know yours.

Posted in Computers, programming, Software | Tagged | Leave a comment