Category Archives: Computers

Measuring the OLTP Performance of AlloyDB against Postgres using sysbench

Posted on December 25, 2022 by Siddharth Jain

AlloyDB is a new HTAP database that Google claims to give 4x better OLTP performance than Postgres. Here, we describe a performance test to compare its performance to Postgres as I wanted to see it for myself. TL;DR: For the … Continue reading →

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

AlloyDB Test Drive

Posted on December 20, 2022 by Siddharth Jain

TL;DR: Background Historically two distinct database access patterns emerged – OLTP and OLAP – and databases were developed to cater to either OLTP or OLAP. OLTP databases would capture data from transactional systems (e.g., sales orders) and the data would … Continue reading →

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

MySQL – 10 Performance Tips

Posted on December 15, 2022 by Siddharth Jain

Misc

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

Measuring performance of BigQuery vs. Clickhouse

Posted on December 10, 2022 by Siddharth Jain

This post summarizes results of a performance test to compare BigQuery vs. Clickhouse – two high-performance analytics databases. Later on I performed same tests on DuckDB but as we shall see it cannot compete with CH or BQ so main … Continue reading →

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

Java vs. Node.js: Performance comparison of blocking vs. non-blocking I/O

Posted on December 5, 2022 by Siddharth Jain

There are many online articles touting the advantages of non-blocking I/O over blocking I/O. But I wanted to see the difference for myself. So to do that, I developed an application two ways: one using Spring WebMVC + JPA which … Continue reading →

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

Step by step guide to profiling Java applications with VisualVM

Posted on November 20, 2022 by Siddharth Jain

VisualVM is a great tool to profile your Java applications. Here I describe the steps I followed to get it working. The steps are wrt Visual VM 2.1.4. I installed VisualVM by downloading the dmg file from their website. Then … Continue reading →

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

Explaining VPC Service Controls to a 3 yr old

Posted on November 15, 2022 by Siddharth Jain

Imagine someone steals your Social Security number, Date of Birth and other identifying information. They then call your bank to transfer money into their account but the bank tells them it does not recognize the phone number from which they … Continue reading →

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

Java Programming Tips

Posted on November 10, 2022 by Siddharth Jain

Learn JShell Java 9 ships with jshell which provides an interpretive shell-like environment (a REPL) for Java. This is extremely useful for prototyping, testing and learning how to use a new library. Here I describe how to use it in … Continue reading →

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

Running Java in a Jupyter Notebook

Posted on October 30, 2022 by Siddharth Jain

Yes it is possible using IJava or Ganymede. In this post I describe all the steps I followed to get it to work on a Macbook using IJava. The post assumes you have python3, pip3 and JDK >= 9 installed. … Continue reading →

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

How to measure memory in Java?

Posted on October 20, 2022 by Siddharth Jain

Unlike C#, Java does not have a built-in sizeof operator that can return the memory (bytes) consumed by an object. You can however do-it-yourself. The steps are a bit involved and hence summarized below. Here is link to SO answer … Continue reading →

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