Writing

Since I subscribed to Claude Max (about half a year ago, I think), I have been much more productive. Some might laugh and say AI just gives you a false sense

I recently brought PJHoon back as part of my portfolio showcase (I'd applied for a Data Engineering role but forgot to include it, LOL).

Humans have biases based on how they perceive things.

I failed many technical interviews, but one of them hit hard, I guess because the full feedback was available to me. Part of the reasons was also because it

It is undeniable that I code much less now. AI has done most of the "painful" work in Software Development, coding and fathering informations, arguably much

It might be ridiculous to brag about this, and yes it is.

Generosity seems a good thing, but sometimes it ruins relationships.

Initially I built PJHoon with 2 goals: consolidate my technical knowledge, and create a, part of, so-called "legacy". This project is the most passionate one

A client (such as a web service, application, or custom ETL pipeline) sends an HTTP POST request to Doris's Stream Load API endpoint. The request contains the

To simplify the life of programmers, the CPU has a set of predefined actions and calculations called the instruction set or ISA (instruction set architecture).

At server side, the deployment and schema migration might conflict to each other as: Application might have its components scaled. However, schema migration

There are trade offs between program performance and code cleanliness: clean code, which allows for better maintainability, usually introduces more

iVim is vim for iPad and is actually really good, as it (and its plugins, most of them) has already been compiled when installing (even plugins that are

Fonts can be encoded entirely into base64 and bundled into .css files for portable usages. ^ab4b9f

Databases have long tried to hide concurrency issues from application developers by providing Transaction Isolation. In theory, isolation should make your life

There is a background process runs in Databases to reclaim redundant space in tables, including removing dead tuples from deletions and updates. This process

The main difference between B+-Tree and B-Tree is that, for B+-Tree, all pointers to actually records must be in the leaf nodes. The non-leaf nodes, though

One of the reasons why Macbook's speaker sounds really good lies in the Driver Implementation, letting it boosts the volume high than the safe threshold when

This is what I know (up to the point of writing) about Elasticsearch: It is based on Apache Lucene (obvious but still surprising). It leverages the Log

A transaction executing under Snapshot Isolation appears to operate on a personal snapshot of the database, taken at the start of the transaction. When the

Two phases locking (2PL) the transactions handles its locking in 2 phases: The expanding phase: No lock can be released The shrinking phase: No lock can be

Being a software engineer also helps a lot in how I organize and clean my room.

Dijkstra's algorithm: Prerequisites: All edges are weighted positively (as paths between vertices are assumed to be increasing, leading to a greedy step