This is more about my journey into the web for understanding the nuances of custom word dictionaries and in the process coming across spell checker’s . Lets assume you have a misspelled word and you want a list of the possible corrections. Peter Norvig’s post is one of the famous…

How to avoid and what is max_standby_streaming_delay There are many references which describe how to fix the snapshot replica conflict.I will mention some of them at the end of this post. All the below tweaks are on the replica. max_standby_streaming_delay is one of those parameters which can be tweaked for…

Why do we get replica conflicts and the reason. Error We were occasionally seeing the below errors in our app logs when some queries run on the postgres replica. “Canceling statement due to conflict with recovery” Background There are many reasons why conflicts can occur on a hot standby(replica) as…

Postgres has 3 transaction isolation levels. Read Committed Repeatable Read Serializable Here I will be highlighting few points gleaned across the web which we might otherwise overlook.There is detailed explanation here. Repeatable Read Repeatable read though it sounds odd does not guarantee that reads are repeatable in a transaction.Phantom reads are…

Excerpts from the official docs I am just highlighting the points from this doc on concurrency. Transactions need correct behavior and performance “Correct behavior” basically means serializability. The transactions should appear to execute one at a time, in isolation. When two transactions physically overlap in time, we don’t care which…

Recently I was integrating an email api, and I was able to find the sample snippets in curl and other languages as well.That’s cool! But the API reference page did not mention the Content Type that their api’s accept.What do you accept ? application/json application/x-www-form-urlencoded multipart/form-data Ofcourse the curl snippets that they provided use -F flag which signifies multipart/form-data. And -d in curl signifies application/x-www-form-urlencoded.

Java String.replace replaces all occurrences of a given string with the replacement string. JS String.prototype.replace replaces only the first occurrence if the pattern is a string. Now before this proposal which became a part of ES12(2021), if we had to replace all occurrences of a given pattern with a replacement…

The corner case If you use node pg client to query postgres, it tries to map node data types to postgres data types and vice versa.Ofcourse to some extent. From the docs JavaScript has great support for JSON and node-postgres converts json/jsonb objects directly into their JavaScript object via JSON.parse…

traps to escape when database performance benchmarking I recently had to benchmark AWS Aurora and used pgbench for quick idea of the database performance without much ado. Below are few points which you might want to keep in mind. Setup Client Instance vCPU*| Mem (GiB)| Storage Dedicated EBS Bandwidth (Mbps) |…