Blog

Blog

ASUS ProArt X870E-Creator WiFi: NIC Investigation and Wake-on-LAN on the Intel I226-V
ByRex Bytes May 8, 2026May 8, 2026

The ASUS ProArt X870E-Creator WiFi motherboard running Linux has a notable limitation: the onboard Intel I226-V 2.5GbE NIC does not support Wake-on-LAN, despite correct configurations, while the Aquantia AQC113CS 10GbE NIC functions properly. This issue stems from the chipset’s architecture, and users cannot update the NIC firmware without restricted access. The Aquantia NIC is recommended for reliable Wake-on-LAN functionality.

Read More ASUS ProArt X870E-Creator WiFi: NIC Investigation and Wake-on-LAN on the Intel I226-V
Blog

Autonomi Network: A Review Twenty Years in the Making
ByRex Bytes May 6, 2026May 8, 2026

Autonomi, launched in 2026, represents a breakthrough in decentralized data networks after two decades of development. It offers permanent storage with a one-time payment model and robust post-quantum cryptography. This innovative platform not only enables individuals to own their data securely but also eliminates reliance on centralized services, reshaping digital infrastructure.

Read More Autonomi Network: A Review Twenty Years in the Making
Blog

pgmonkey: One Config File to Rule All Your PostgreSQL Connections
ByRex Bytes February 17, 2026March 3, 2026

pgmonkey is a handy Python library that simplifies PostgreSQL connection management with just one YAML config file. It supports multiple connection types—like sync, async, and pooled—while handling caching and lifecycle tasks seamlessly. Ideal for projects with mixed connection needs, it saves developers from configuration chaos. Worth checking out!

Read More pgmonkey: One Config File to Rule All Your PostgreSQL Connections
Blog

Your Manager’s Spreadsheet Is Broken. Here’s the 3-Minute Fix.
ByRex Bytes February 11, 2026March 3, 2026

Tired of dealing with messy spreadsheets that complicate your data workflow? Enter xlfilldown — the ultimate solution for data engineers seeking clean, queryable data. This powerful tool efficiently fills hierarchical data, ensuring context is preserved without memory overload. With a simple command, you can cleanse and streamline large Excel files, saving precious time while avoiding tedious manual fixes. Embrace hassle-free data management today!

Read More Your Manager’s Spreadsheet Is Broken. Here’s the 3-Minute Fix.
Blog

OPNsense WAN Watchdog with Cooldown, Log Rotation & Cron Integration. PART 1
ByRex Bytes November 14, 2025March 3, 2026

This guide outlines the steps to create a cron-activated recovery script for OPNsense 25.7.7_4 to address DHCP outages. The script monitors connectivity, logs activity, and reconfigures the WAN interface as needed. It implements cooldown mechanisms to prevent reboot loops and integrates with the system’s configuration and scheduling functions.

Read More OPNsense WAN Watchdog with Cooldown, Log Rotation & Cron Integration. PART 1
Blog

The Secret Hierarchies of Excel: Why Managers Merge, and Engineers Cry
ByRex Bytes October 13, 2025March 3, 2026

Excel may appear simple, but it conceals a daunting data challenge: the hierarchical spreadsheet. Common among analysts, it presents issues like merged cells and hidden hierarchies that frustrate data processing. Enter xlfilldown—a powerful solution that transforms chaotic Excel files into clean, structured datasets for seamless analysis. By bridging the gap between visual reports and data integrity, xlfilldown revolutionizes the ETL process for data professionals.

Read More The Secret Hierarchies of Excel: Why Managers Merge, and Engineers Cry
Blog

One Million Rows: Testing xlfilldown Performance and Constant-Memory Design
ByRex Bytes October 6, 2025March 3, 2026

The content discusses the performance and reliability of the xlfilldown tool, which efficiently processes large Excel datasets without excessive memory usage. A stress test processing 1,000,000 rows demonstrated rapid speeds—13,800 rows/sec for Excel and 44,700 rows/sec for SQLite—while maintaining deterministic and auditable output. This enhances data integrity and workflow trust.

Read More One Million Rows: Testing xlfilldown Performance and Constant-Memory Design
Blog | Projects

xlfilldown: The Complete Guide to Excel Fill Down
ByRex Bytes September 23, 2025March 17, 2026

The xlfilldown tool is a CLI and Python library designed for processing Excel data into SQLite or new Excel workbooks. It efficiently handles hierarchical and independent fill modes to maintain data integrity. Key features include row hashing, constant-memory processing, and raw ingestion options. Users can choose between CLI commands or a Python API for seamless integration into their workflows.

Read More xlfilldown: The Complete Guide to Excel Fill Down
Blog

How I Repaired a DXRacer Tilt Mechanism When Spare Parts Were Unavailable
ByRex Bytes September 12, 2025March 3, 2026

⚠️ Disclaimer ⚠️ This guide is shared for informational purposes only. Attempt any repair at your own risk. I am not responsible for injury or damage that may result from following these instructions.⚠️ The Problem If you are an IT geek, you’ll know we spend a lot of time sitting. A good chair is invaluable….

Read More How I Repaired a DXRacer Tilt Mechanism When Spare Parts Were Unavailable
Blog

OPNsense: Automatic Recovery When WAN Fails
ByRex Bytes September 3, 2025March 3, 2026

This post addresses the absence of a built-in WAN recovery mechanism in OPNsense 25.7.7_4, which can lead to internet connection loss requiring manual reboot. The author presents a DIY solution: a shell script that pings a reliable host, attempts to renew DHCP leases, and reboots the system if necessary. The script can be scheduled via cron for regular monitoring, enhancing network reliability.

Read More OPNsense: Automatic Recovery When WAN Fails