Avoid pinning for AWS RDS Proxy for PostgreSQL
The Problem
When using AWS RDS Proxy for PostgreSQL for the first time, I see many pieces of the following logs
Consider moving session configuration to the proxy’s initialization query. Digest: “set extra_float_digits = $1”.
and
The client session was pinned to the database connection [dbConnection=2678093940]
AWS said
RDS Prox...
Usage of Regular Expression
Overview
Regular Expression is good in many cases like log analysis, and quick searching etc. However, 9 out of 10 Regular Expressions are not correct when they are used for specific business purpose in my working experience, such as the email address validation.
It’s good to learn basic Regular Expression, while it’s more important to know the...
Java Exception 201: NullPointerException and Its Mitigations
What is NullPointerException (NPE)
null is a reserved value for indicating that the pointer does not refer to a valid object. In Java, access of null will trigger NullPointerException.
The history of null dates back to 1965, Tony Hoare (known for Quicksort) introduced null references in an object oriented language. In 2009 at a conference, he a...
Java Exception 101
Overview
The most ‘fantastic’ usage of exception in Java I saw around 3 years ago is, a guy throws Exception in an inner loop in order to exit the outer loop.
Exception is fundamental knowledge in Java. However, someone analyzed half a million Java projects in GitHub, the result shows the usage is not good.[1]
Weekly Report
Overview
Weekly report is usually used for task/project in an organization, the objectives include
For the organization
Help monitor and control the task/project
Improve communication in the organization and keep stakeholders informed
Gain more organizational support for the task/project
For the reporter
...
File Naming Convention
Purpose
Look at the file names
untitled.txt
lib.zip
123.doc
tmp.txt
myidea.txt
Even if we can remember the content of the files temporarily, we will forget soon.
A good file naming convention is good for organizing and retrieving our documents efficiently.