๐Ÿ“˜ Exception Definition Language (EDL)

Structured exception specification with category owned code prefixes ๐ŸŽฏ 1. Key design rules โœ… Category owns the code prefix โœ… Error defines only a numeric suffix โœ… Final error code is derived โœ… Error names use camelCase This enforces semantic ownership and prevents code drift. ๐Ÿง  2. Core concepts Concept Definition Root exception Single abstract …

More

PostgreSQL vs MySQL: A Comprehensive Developer-Focused Technical Comparison

1. Introduction PostgreSQL and MySQL remain the two dominant open-source relational databases. While both can serve general-purpose workloads, they diverge significantly in: This document compares them specifically from the angle of software engineers writing their own SQL queries, using Java/Spring or Node.js backends. 2. SQL and Standards Compliance PostgreSQL PostgreSQL is considered one of the …

More

MSI X670E/X870E 128gb RAM settings

2x64GB (Crucial 5600MT/s, Corsair 6400MT/s) Corsair SKU CMK128GX5M2B6400C42, Crucial SKU CP2K64G56C46U5 I used the same settings for both sets, the Crucial is working fine at 6000MT/s, 4 passes on Memtest, all good. Crucial test bed Component Name Link Motherboard MSI X670E GAMING PLUS WIFI https://amzn.eu/d/gbp41xZ CPU Ryzen 9 9950X https://amzn.eu/d/cbxvdRz Corsair test bed Component Name …

More

AM5 Motherboard options

Motherboard M.2 Slot Gen / Count Exact Slot Mapping / Lane-Sharing Details Notes / Implication for Use MSI X870E Gaming Plus WiFi 3 slots: 1ร— Gen5 ร—4 + 2ร— Gen4 ร—4 (Paradigit) Manual shows three M.2 slots; deeper lane-sharing details not clearly documented publicly. (ManualsLib) Good value board; if you install multiple M.2s plus heavy …

More

Super K3S internet test setup

Cluster-A ๐ŸŒ in cloud (Hetzner control plane) + workers across 3+ home sites ๐Ÿก๐Ÿš๐Ÿ  over VPN ๐ŸŒ High-Level Architecture โœ… Core Principles Feature Design Cluster-A Distributed across sites via VPN Cluster-B Local to main home Networking Tailscale or WireGuard DNS Joker.com Dynamic DNS DB CNPG primary @ home + async replicas at other sites Storage …

More

๐Ÿ–ฅ๏ธ Linux Development Workstation Setup Guide

This article explains how to configure a high-performance Linux development workstation running Debian 13 (Trixie) or Debian 12 (Bookworm). ๐Ÿ“‘ Table of Contents ๐Ÿงฉ Introduction This guide prepares a workstation optimized for local development, build pipelines, and database workloads on fast NVMe storage. It focuses on reproducibility, speed, and maintainability. ๐Ÿ–ง Hardware & Network ๐Ÿ–ง …

More

Fixing โ€œSystem Wakes Immediately After Suspendโ€ on Linux

Root cause: Mediatek MT7921E Wi-Fi driver preventing suspend Overview Some Linux systems equipped with Mediatek MT7921/MT7922 Wi-Fi + Bluetooth cards fail to remain suspended.When you attempt systemctl suspend, the machine briefly enters sleep and then instantly wakes back up. Typical kernel logs show: The mt7921e driver is known to hang during suspend, causing an โ€œearly …

More

Local LLM for coding

๐Ÿ–ฅ๏ธ Dual-GPU LLM Workstation Build Spec Target use case: Repo-aware coding assistant (30โ€“34B models, fine-tuning, RAG) on local hardware. 1. Core Components ๐Ÿ”น Motherboard MSI MEG X670E ACE (Recommended) ๐Ÿ”น GPUs 2ร— NVIDIA GeForce RTX 5070 Ti 16 GB ๐Ÿ”น CPU AMD Ryzen 9 7950X / 9950X ๐Ÿ”น Memory 128 GB DDR5 (2ร—64 GB) ๐Ÿ”น …

More

Workhorse Systems Limited โ€“ History & Fate

1. Origins (1980s) At the time, this was pioneering: most office automation was paper-based or tied into mainframes; Workhorse brought structured workflow to UNIX servers with graphical clients. 2. AT&T Rhapsody (Early 1990s) The AT&T Rhapsody launch was significant because it pushed workflow into the mainstream โ€œgroupwareโ€ discussion of the early 1990s. 3. Acquisition by …

More