Most agency onboarding fails before the kickoff call happens. Not because the team isn't good. Not because the client is difficult. Because nobody collected the right context upfront, and the kickoff call becomes the place where everyone discovers what they don't know yet. The intake form is the fix. Not a 3-question "tell us about your project" form. A real one. Here's the framework we use — 27 q
Friday I got a new camera to replace the one that broke last year. It's a Canon Rebel with two lenses. The buttons and functions are different from the previous camera so my muscle memory is no good. I have to relearn it all. Spent the weekend at the Renaissance Festival and got some great pics. What are you building this week? What do you want to learn? What events are you attending this week?
PostgreSQL Query Rewriting Techniques The previous articles in this series covered performance problems you fix by adding indexes, restructuring joins, or tuning memory. This one is about the queries where the plan is "fine" — every node is doing something reasonable — but the query itself is asking the wrong question, producing unnecessarily large intermediate results or forcing the planner dow
Making yogurt at home isn't hard. You can control the sugar, the fat, add any flavour you want. Free from the tyranny of Big Yogurt! Yet somehow, Danone is still doing fine. Same goes for home-brewed beer, homemade bread, 3D printing. All great hobbies. All more accessible than ever. None have actually disrupted their industries. Better tools raise the floor and the ceiling. The hobbyist gets bett
Cyber attacks are becoming more frequent and more expensive because criminals are still getting paid. Despite growing awareness, the economics of ransomware still favour attackers. Only 17% of UK organisations hit by ransomware chose to pay, but even among those who do pay, outcomes remain unreliable. According to UK‑wide data, oranisations are now three times more likely to recover from backups
Meme Monday! Today's cover image comes from the last thread. DEV is an inclusive space! Humor in poor taste will be downvoted by mods.
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