An opinionated list of Python frameworks, libraries, tools, and resources
When you use window functions in SQL, you can't filter their results directly in a WHERE or HAVING clause — that's a well‑known limitation across many databases. GBase 8a, the China‑domestically developed MPP database from GBASE, solves this elegantly with the QUALIFY clause. Let's break down how it works, what it can do, and where you need to be careful. DROP TABLE IF EXISTS emp; CREATE TABLE emp
As data grows, you'll likely need to add nodes to your existing GBase 8a MPP cluster without downtime. This hands‑on guide walks through the full process of adding a composite GNode to a running GBASE cluster. Existing cluster: A healthy GBase 8a cluster New node: A server with a static IP address configured Network: All nodes must be able to communicate with each other Stop services on all existi
By default, identifiers in GBase 8s are case‑insensitive: uppercase letters are silently treated as lowercase. Setting the environment variable DELIMIDENT=Y changes how double‑quoted identifiers behave, enabling case‑sensitive table and column names. Here's a demonstration and a deep dive into the option, as used in a gbase database. With DELIMIDENT=y exported, execute the following statements: ex
We’ve been running a series of experiments using ChatGPT 5.4 integrated into a website chatbot across different environments: 🌐 a main website 🎯 Goal: simulate realistic user behavior and observe how the model responds over time. ⚙️ Test setup The chatbot is designed to (no self promo here, just context): 📌 answer strictly based on website content (RAG-like approach) Over time, we intentionally
Introduction Backup plugins are useful — but they are not a real disaster‑recovery strategy. In this article, I break down the real reasons why backup plugins fail, what actually happens during a server‑level crash, and how to build a recovery plan that works in the real world. Backup Plugins Only Work When WordPress Works A backup plugin depends on: WordPress running PHP running MySQL running the
Riad Hasan has optimized dozens of WordPress sites for clients worldwide. In this guide, he shares the exact techniques he uses to achieve sub-2-second load times and perfect Core Web Vitals scores. Performance isn't just about speed — it impacts SEO, user experience, and conversions. Riad Hasan explains his systematic approach to WordPress optimization. Google's Core Web Vitals are now ranking fa
Stop clicking through wp-admin for every small task. WP-CLI is a command-line tool that lets you manage WordPress sites faster — all from your terminal. Why WP-CLI? Problems It Solves Is It Good or Bad? Setup & Installation Must-Know Commands A Quick Real-World Use Case Your First Custom Script What's Next Every WordPress developer knows the pain — update 12 plugins, flush cache, reset a password,