Category Archives: Computers

Clean Code

Posted on November 20, 2023 by Siddharth Jain

Clean code is code that looks like it was written by someone who cares. Software is meant to be soft – changeable, malleable. Well architected code is easy to change. Not every change takes 6 months. Software is about two … Continue reading →

Posted in Computers, programming, Software | Leave a comment

How to read/write HDF5 files in Java

Posted on November 6, 2023 by Siddharth Jain

there are 2 things you need for this: WARNING: You will need JDK 20 because the Java wrapper has been compiled with JDK 20 (when I wrote this blog post). If you have earlier version of JDK you will get … Continue reading →

Posted in Computers, programming, Software | Tagged hdf5, java | 1 Comment

How to stop postgres server on MacOS

Posted on October 30, 2023 by Siddharth Jain

This post describes how I was able to stop pg 14 server on macos that I installed from EDB website. The commonly described solution is to use brew but that did not work for me. E.g., when I ran following … Continue reading →

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

Postgres timestamp without time zone vs. timestamp with time zone

Posted on October 20, 2023 by Siddharth Jain

the difference between these two is nicely illustrated by below example: What it means: timestamp without time zone ignores any time zone offset specified when inserting data. So it doesn’t matter whether you are inserting ‘2011-01-01 00:00:00+03’ or ‘2011-01-01 00:00:00-03’. … Continue reading →

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

TypeScript: Pros and Cons

Posted on October 10, 2023 by Siddharth Jain

TypeScript is a popular language these days and a hugely successful project as evidenced in latest SO Developer Survey. Another feather in the cap for Anders Hejlsberg for whom I have great respect. I myself make my team use it … Continue reading →

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

How to read/write HDF5 files in C#

Posted on October 2, 2023 by Siddharth Jain

There are 2 things you need for this: I won’t go into details of .net installation. Let’s get started. The HDF5 library can be installed on Mac in two ways: Method 1: Using brew (I don’t recommend it). sample install … Continue reading →

Posted in Computers, programming, Software | Tagged c#, hdf5 | Leave a comment

Testing MySQL SERIALIZABLE Isolation Level

Posted on September 30, 2023 by Siddharth Jain

This post illustrates testing MySQL’s (version 8.0.30 was used in the tests) SERIALIZABLE with the 3 examples given on Postgres wiki. Black and White MySQL handles this correctly. Below is the sequence of events: In summary, the second transaction is … Continue reading →

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

Illustrating write skew in Postgres with Repeatable Read (Snapshot Isolation)

Posted on September 20, 2023 by Siddharth Jain

In this post we will see write skew in action using Node.js, Postgres and Sequelize. We will use the example given in wikipedia where there are two accounts (tables) V1 and V2 with a single balance column. The tables are … Continue reading →

Posted in Computers, programming, Software | Tagged concurrency, postgres, sequelize | Leave a comment

Handling Postgres Serialization errors in Sequelize

Posted on September 10, 2023 by Siddharth Jain

When using the REPEATABLE READ or SERIALIZABLE isolation levels, you should be prepared to handle serialization (error code 40001) and deadlock failures (error code 40P01) in your code. Well this is how you do it: where That’s it for this … Continue reading →

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