Author

Lobster Programming

Sharing insights on technical analysis and exchange, making life better through technology.

153

Articles

Likes

517

Views

Comments

Latest from Lobster Programming

100 recent articles max

Lobster Programming

Apr 14, 2025 · Backend Development

Understanding RabbitMQ Architecture: Components, Exchanges, and Queues

RabbitMQ, an Erlang‑based open‑source message broker implementing AMQP, uses producers, consumers, exchanges, queues, virtual hosts, connections, and channels to enable scalable, reliable asynchronous communication, with various exchange types and binding mechanisms that organize message routing in microservice architectures.

AMQPMicroservicesRabbitMQ

0 likes · 7 min read

Understanding RabbitMQ Architecture: Components, Exchanges, and Queues

Lobster Programming

Apr 10, 2025 · Databases

Why Does MySQL Use Two-Phase Commit? Understanding Redo Log and Binlog Coordination

MySQL employs a two‑phase commit to synchronize InnoDB’s redo log with the server’s binlog, ensuring atomicity during transaction commits and preventing data inconsistencies during crash recovery or replication, while also introducing lock contention, extra I/O, and potential blocking.

binlogdatabase-consistencyredo log

0 likes · 5 min read

Why Does MySQL Use Two-Phase Commit? Understanding Redo Log and Binlog Coordination

Lobster Programming

Apr 8, 2025 · Frontend Development

Understanding Cookies, Sessions, Local Storage & Session Storage: A Frontend Guide

This article explains the concepts, purposes, and trade‑offs of Cookies, Sessions, Local Storage, and Session Storage, detailing how each stores data, their security attributes, typical use cases, and the differences between client‑side and server‑side state management in web development.

FrontendHTML5Session

0 likes · 7 min read

Understanding Cookies, Sessions, Local Storage & Session Storage: A Frontend Guide

Lobster Programming

Apr 3, 2025 · Databases

Why Is Redis So Fast? Deep Dive into Its Architecture and Data Structures

Redis achieves remarkable speed through in‑memory storage, I/O multiplexing, optimized data structures such as SDS strings, linked lists, ziplists, skip‑lists, and hash tables, a single‑threaded event loop, and intelligent data encoding, all of which eliminate disk I/O and reduce overhead.

I/O MultiplexingIn-Memory DatabaseRedis

0 likes · 8 min read

Why Is Redis So Fast? Deep Dive into Its Architecture and Data Structures

Lobster Programming

Apr 3, 2025 · Databases

How to Quickly Generate Batch SQL Statements Using Excel

This tutorial explains how to import data into Excel, craft formulas that concatenate cell values into UPDATE or INSERT SQL statements, and drag the formulas down to produce batch SQL commands for efficient database operations.

Batch ProcessingExcelSQL

0 likes · 2 min read

How to Quickly Generate Batch SQL Statements Using Excel

Lobster Programming

Mar 31, 2025 · Databases

How Does MySQL Store Data? Inside InnoDB Files, Pages, and Row Formats

This article explains where MySQL stores its data on disk, how the InnoDB engine organizes files, pages, extents, segments, and rows, and details the Compact, Dynamic, and Compressed row formats, including null‑value handling and overflow mechanisms.

DatabaseStorage Enginerow format

0 likes · 16 min read

How Does MySQL Store Data? Inside InnoDB Files, Pages, and Row Formats

Lobster Programming

Mar 24, 2025 · Backend Development

Boost Java File Copy Performance: 5 Proven Methods Compared

Learn five Java file copy techniques—from basic streams to NIO Files.copy, FileChannel, and RandomAccessFile—detailing their implementations, performance differences, and ideal use cases for small, large, and massive files, helping you choose the most efficient method for your project.

BufferedStreamFile I/OFileChannel

0 likes · 6 min read

Boost Java File Copy Performance: 5 Proven Methods Compared

Lobster Programming

Mar 21, 2025 · Databases

How to Count Website Visits Efficiently with Redis: Hash, Bitmap, and HyperLogLog

This article explains three Redis-based methods—Hash, Bitmap, and HyperLogLog—for tracking website user visits, detailing how each structure works, their implementation steps, memory and accuracy trade‑offs, and guidance on choosing the best approach for different traffic scenarios.

Database PerformanceHashHyperLogLog

0 likes · 6 min read

How to Count Website Visits Efficiently with Redis: Hash, Bitmap, and HyperLogLog

Lobster Programming

Mar 19, 2025 · Fundamentals

Handle vs Direct Pointer Access in the JVM: Which Is Faster?

An in‑depth look at how the JVM stores object references, comparing handle‑based access with direct pointer access, highlighting their performance trade‑offs, memory overhead, and impact on garbage collection to help developers choose the most suitable approach for their applications.

JVMMemory Managementdirect pointer

0 likes · 3 min read

Handle vs Direct Pointer Access in the JVM: Which Is Faster?

Lobster Programming

Mar 17, 2025 · Operations

How to Build a Lightweight Loki Logging Stack with Promtail and Grafana

This guide walks you through setting up a SpringBoot application, configuring Logback, installing and configuring Loki, Promtail, and Grafana, and comparing the lightweight Loki stack with the traditional ELK solution for efficient log collection and visualization.

ELKGrafanaLogging

0 likes · 14 min read

How to Build a Lightweight Loki Logging Stack with Promtail and Grafana