Unique WordPress Database & Code Performance Tweaks 2025

Development / Build-Tools / Content Managment / Database / Debugging / Deployment / Hosting / WordPress

Database Optimization Techniques 1. Custom Database Indexing Postmeta Table Indexing The wp_postmeta table is often the performance bottleneck for sites with custom fields or WooCommerce. Custom Index for Meta Key Searches: Composite Index for ACF Queries: Source: Advanced Custom Fields Blog | SpinupWP Database Optimization wp_options Table Optimization Plugin Solution: Index WP MySQL For Speed […]

Website Migration Guide: rsync + MySQL dump + imapsync

Development / Deployment / Enviroment / Hosting

Overview This comprehensive guide covers migrating a complete website using three essential tools: Essential Documentation Links Pre-Migration Planning 1. Infrastructure Assessment 2. Downtime Planning 3. Security Setup Reference Links: File Migration with rsync Basic rsync Configuration Standard Website Files Transfer Advanced rsync Options Key rsync Flags Explained Flag Purpose -a Archive mode (preserves permissions, timestamps, […]

MariaDB/MySQL Performance Optimization Guide

Development / Database / Deployment / Enviroment

Quick Wins (Immediate Impact) 1. The 30x Performance Trick Run this on all your tables – can improve query performance by 30x: This generates and stores histograms for data distribution, allowing the optimizer to make much better decisions about join order and filtering. 2. Enable Engine-Independent Statistics 3. Update Table Statistics Regularly Advanced Configuration File […]

WordPress HyperDB Alternatives for Database Replication in 2025

Development / Apache / Database / Deployment / Docker / Enviroment / Hosting

Remember HyperDB? That WordPress plugin that promised to solve all your database scaling problems back in the day? Well, it’s been dead and buried for years now, but the need for database replication and scaling certainly hasn’t gone anywhere. If anything, with WordPress powering over 40% of the web these days, the demand for robust […]

Day 35: FlowiseAI – Low-code developer tool for building LLM Applications – 7 Days of Docker

Development / Agents / AI / Automation / Deployment / Docker

What is FlowiseAI? FlowiseAI is an open-source generative AI development platform for building AI agents and LLM workflows. Here are its key features: Core Capabilities: Key Features: FlowiseAI Docker Compose Installation Guide Prerequisites Before starting the installation, ensure you have: Step 1: Create Docker Compose File Create a new directory for your FlowiseAI installation and […]

Day 34: Spacedeck Open – Open-Source Collaborative Whiteboard – 7 Days of Docker

Docker / Deployment / Design / Development

What is Spacedeck Open? Spacedeck Open is a web-based, real-time collaborative whiteboard application with rich media support. It’s an open-source platform that allows multiple users to work together on digital whiteboards, making it ideal for: Key Features: Project Background: Originally developed between 2011-2016, Spacedeck was later open-sourced and is now maintained by the community. The […]

Web Scraping & Testing After PhantomJS: Modern Tools and Examples

Development / Automation / Build-Tools / Debugging / Deployment / Javascript

Hey there, fellow developer! Remember PhantomJS? That trusty headless browser that helped us scrape websites, run automated tests, and generate screenshots back in the day? Well, if you’re still using it or just discovered some legacy code that relies on it, I’ve got some news for you. PhantomJS officially threw in the towel back in […]

Day 33: Matomo – Leading Open-Source Web Analytics Platform – 7 Days of Docker

Development / Deployment / Docker / OffPage / OnPage / Search Engines / SEO

What is Matomo? Matomo (formerly known as Piwik) is a leading open-source web analytics platform that provides a privacy-focused alternative to Google Analytics. It gives you complete control over your data while offering comprehensive website analytics capabilities. Key Features: Docker Installation Options There are two main Docker approaches for installing Matomo: Prerequisites Before starting, ensure […]

Your Ultimate Guide to Mini PCs for Kiosk Solutions – 2025 Edition

Development / Deployment / Digital Kiosk / Digital Signage / Enviroment / Hardware / Mini PC

So you’re hunting for the perfect mini PC for your kiosk setup? You’ve come to the right place. After diving deep into the European market and checking real pricing, here’s everything you need to know about the best x86-compatible mini PCs that won’t break your budget. The Sweet Spot Winners (Under 300 EUR) Budget Champion: […]

cubicFUSION

PROJECT

Frappe Gantt: The Open-Source Gantt Chart Library You Actually Want to Use

Communication / Deployment / Design / Development / Javascript / Project Management

Ever tried to find a decent-looking Gantt chart library that doesn’t cost an arm and a leg? Yeah, the struggle is real. Enter Frappe Gantt – the open-source JavaScript library that might just be the solution you’ve been looking for. Just used it internally for a project and build a quick editor around it. Really […]

ARCHIVE.