ITFROMZERO – Share tobe shared!

MySQL Query Rewrite Plugin: Optimize and Fix SQL Queries Without Touching Your Application Code

By admin May 21, 2026

MySQL Query Rewrite Plugin lets you intercept and modify SQL statements at the database layer without changing any application source code. This guide covers installation, configuration, and practical use cases for production environments.

Fedora

Optimizing Power Management on Fedora Workstation with power-profiles-daemon and tuned

By admin May 21, 2026

A practical guide to configuring power-profiles-daemon and tuned on Fedora Workstation to balance performance and battery life. Covers custom tuned profiles, automatic udev switching rules, and how to monitor real-time power consumption.

Database

Atlas (Ariga): Database Schema Management as Code and Migration Automation

By admin May 21, 2026

Atlas (Ariga) enables IaC-style database schema management: describe your desired state, auto-generate migrations, lint destructive changes, and detect drift between code and your live database. This article compares Atlas with Flyway/Liquibase and walks through a real-world PostgreSQL setup.

Database

Using Debezium for Change Data Capture (CDC) from MySQL and PostgreSQL: Real-Time Sync to Kafka Without Touching Your Application

By admin May 21, 2026

A practical guide to setting up Debezium for real-time Change Data Capture (CDC) from MySQL and PostgreSQL, streaming events to Kafka — no application changes required, just reading the transaction log. Covers Docker Compose setup, connector registration, and common troubleshooting.

Security

Using Metasploit Framework for Internal Security Testing: Responsible Ethical Hacking

By admin May 21, 2026

Test your internal system vulnerabilities using Metasploit Framework — a hands-on guide to responsible ethical hacking on Linux, covering service scanning, CVE detection, and report generation. Ideal for sysadmins who want to proactively secure their systems before a real attack occurs.

Development

tRPC + Next.js: The Ultimate Solution for Type Mismatch Between Client and Server

By admin May 21, 2026

Stop worrying about data mismatches between Client and Server. This guide helps you master tRPC with Next.js to build 100% type-safe APIs.

Git

Mastering Git LFS: Handling Huge Files in Professional Repositories

By admin May 21, 2026

Don't let your repository slow down due to heavy files. Here is a detailed guide on installing Git LFS, migrating old repos, and File Locking tips for graphics and game dev teams.

Python

Python Performance: When to Use Multiprocessing vs. Threading?

By admin May 21, 2026

Struggling to choose between Multiprocessing and Threading? This article explains how to optimize Python performance for CPU-bound and I/O-bound tasks with real-world examples.

Git

Lazygit Guide: A Powerful Terminal UI for Faster, More Visual Git Management

By admin May 20, 2026

Lazygit is a Terminal UI tool that lets you work with Git visually right in your terminal, from staging individual lines of code to interactive rebase — all with keyboard shortcuts. This post covers installation, the most useful features, and the tips I use daily when working with Git.

Git

Git Merge Strategies: Octopus, Ours, Theirs — Using the Right Strategy to Escape Merge Hell

By admin May 20, 2026

A practical guide to Git merge strategies: Octopus for merging multiple branches at once, Ours for closing a branch without taking its code, and Theirs for auto-resolving conflicts. When to use each one and how to avoid the most common mistakes.

Netdisco: Effortless Network Topology Automation and Switch Port Management

Snapshot Testing with Pytest-snapshot: Stop Struggling with Manual Assertions

Say Goodbye to Passwords: Implementing Magic Links with Node.js and Nodemailer

Securing Python Source Code with PyArmor: Effectively Preventing Reverse Engineering and Protecting Intellectual Property

Feature-Sliced Design (FSD): A ‘Divide and Conquer’ Solution for Large-Scale React Projects

Building Professional CLIs with Node.js and Oclif: From Fragmented Scripts to Standardized Tools

Implementing Circuit Breaker in Python: Don’t Let a Faulty API Crash Your Entire System

Deploying FastNetMon: A Lightweight DDoS Detection Solution via NetFlow/sFlow

3 Pro GraphQL Security Tips: Don’t Hand Hackers the Keys to Your Kingdom

Securing Sudo with 2FA: The Final Defense Against Root Hijacking

MySQL Query Rewrite Plugin: Optimize and Fix SQL Queries Without Touching Your Application Code

Optimizing Power Management on Fedora Workstation with power-profiles-daemon and tuned

Atlas (Ariga): Database Schema Management as Code and Migration Automation

Using Debezium for Change Data Capture (CDC) from MySQL and PostgreSQL: Real-Time Sync to Kafka Without Touching Your Application

Using Metasploit Framework for Internal Security Testing: Responsible Ethical Hacking

tRPC + Next.js: The Ultimate Solution for Type Mismatch Between Client and Server

Mastering Git LFS: Handling Huge Files in Professional Repositories

Python Performance: When to Use Multiprocessing vs. Threading?

Lazygit Guide: A Powerful Terminal UI for Faster, More Visual Git Management

Git Merge Strategies: Octopus, Ours, Theirs — Using the Right Strategy to Escape Merge Hell