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.

Optimizing Proxmox: How to Create a ‘Gold Standard’ LXC Template for Mass Deployment in 30 Seconds

Optimizing PHP 8.3 on Ubuntu 24.04: Don’t Let Your Server Run Like a Snail

Mastering Python functools: Writing Better, Faster Code

Fixing SELinux Errors on Fedora for Good: Use setroubleshoot and audit2allow Instead of Disabling It

Build Your Own High-Performance, Low-Cost Git Server with Gitea on Fedora: Maximum Security with SELinux

Configuring Multi-WAN Failover on Linux: A “Never-Down” Internet Solution with Keepalived

Podman Auto-update on Fedora: Automating Containers the Native Way

Installing MinIO on CentOS Stream 9: Build Your Own S3 Storage with SELinux and Firewalld

Installing Grafana on CentOS Stream 9: Professional Server Monitoring with Prometheus

SSH Bastion Host (Jump Server) Configuration Guide: A Secure Gateway for Linux Systems

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