SQL databases, NoSQL systems, data modeling, indexing, and storage optimization. Explore Systems & Architecture Academy.
DNF and YUM automatically download RPM packages and their dependencies during installation. If you need to build offline installation media, create local mirrors, or avoid repeated downloads across multiple systems, you’ll want to preserve those packages instead of letting them disappear from cache after installation. This is especially useful for: Building offline installation repositories Preparing…
Local port forwarding on the same host requires understanding how netfilter processes packets based on their origin. The critical distinction: traffic from external sources hits the PREROUTING chain, but packets originating locally traverse the OUTPUT chain instead. Miss either one, and your forwarding won’t work. The core problem When you forward UDP port 500 to…
iptables remains the standard firewall interface across most Linux distributions, though it’s technically a compatibility layer over nftables. Whether you’re managing legacy systems or prefer the familiar syntax, here’s what you need to know. Basic Command to Open a Port The fundamental syntax to allow inbound traffic on a specific port: sudo iptables -A INPUT…
Intercepting traffic before normal routing decisions requires understanding packet flow through iptables chains. If you need incoming packets to bypass the INPUT chain and process through FORWARD instead, you’ll use the PREROUTING chain with Destination NAT (DNAT). Packet Flow Through iptables When a packet arrives at your system, it traverses these chains in order: PREROUTING…
The LIMIT clause in MySQL lets you control how many rows a SELECT query returns. This is essential for pagination, performance tuning, and working with large datasets. Basic LIMIT Syntax To return only the first N rows from a table: SELECT * FROM qa_users LIMIT 10; This returns the first 10 rows from the qa_users…
Date comparison is one of the most common operations in SQL queries, whether you’re filtering orders, analyzing logs, or generating reports. The approach varies slightly across database systems, but the underlying principles remain consistent. Basic Date Comparison The simplest form uses standard comparison operators against a date string in YYYY-MM-DD format: SELECT * FROM orders…
Chrome aggressively caches HTTP redirects—especially 301 (permanent) and 308 redirects—as a performance optimization. The cache persists across browser sessions, which causes real problems when you’ve updated redirect rules and need to test them immediately. Understanding Chrome’s Redirect Cache Behavior Chrome stores redirect information at the browser level, separate from typical page caches. This means: 301…
If you need direct control over your firewall rules, you can disable firewalld and use iptables instead. This guide covers the setup process and best practices for maintaining persistent rules. Stop and disable firewalld If firewalld is currently running, stop it and prevent it from starting on boot: sudo systemctl stop firewalld sudo systemctl disable…
Transactional memory (TM) is a synchronization mechanism that simplifies concurrent programming by allowing multiple threads to execute code atomically without explicit lock management. If you’re getting into this area, here are the best resources and practical approaches to build solid understanding. Foundational Reading The classic reference is still Transactional Memory by James R. Larus and…
NoSQL databases have matured considerably and now handle a significant portion of production workloads. The landscape has shifted toward specialized solutions rather than one-size-fits-all approaches. Here’s a breakdown of the most widely deployed options: Document Stores MongoDB remains the most popular document database. It’s production-ready, well-documented, and offers strong consistency guarantees with replica sets. The…
ASCII stands for American Standard Code for Information Interchange. It’s a 7-bit character encoding standard mapping numeric values (0-127) to printable characters and control codes. Since computers work with numbers at the lowest level, ASCII provides a universal way to represent text—each character has a unique numeric value. Standardized in 1963, ASCII remains foundational to…