CodeWithStu

Hey hey 👋 Lots of new people recently, so let's get to know each other I'm Stu. I'm a principal engineer who has spent years at places like Checkout and ClearBank. Whilst I'm building my future, I share interesting things and what I learn on the way What are you working on?

Postgres doesn't index your foreign keys for you. The parent side has its primary key, but the column on the child table is on you I added a test to the new project that reads the catalog and fails if any foreign key doesn't have an index starting with its columns. It found 13 :( Without them, deleting means full table scans

My latest experience is: - Wait a week after updating the app with localisation - Get rejected because I forgot to submit the localisation on subscriptions (fair) - Submit and get approved - Resubmit app and it gets rejected again for the same reason

Waltham forest average is £100/day per child for nursery xD

Programmatic SEO can bring in a surprising amount of traffic. onehaus usually sits around 100 visitors a day. Yesterday it hit 183, with 124 from Google, and most of those landed on one holiday page for Ireland because of the bank holiday. Installs didn't move though (6). So the pages work for discovery - turning that into people who actually install the app is a completely different problem

Before letting Claude write a single migration for the next project, I had it design the feature list and ICP first, then document those. Only after that did we move onto the data structure, then scheduled jobs Then I asked Fable subagents three things: is anything missing, does everything earn its keep, and have we overcomplicated anything. Same prompt also said to drive out any ambiguity Setting the right foundations for a project lets you build faster. And those foundations need to be tied to your ICP

Dr Eggbot: x.ai/bot/marketplace/bots/dr…

How I set up a small team of Grok Bots without it turning into a mess Imported dr eggbot from the Grok Bot marketplace, a bot whose only job is designing other bots. Told it what I wanted help with, it asked a few questions, then built each one What came out were really minimal bots. One job each, a clear list of things they're not allowed to do, and nothing else. Then daily checks for the routine stuff, so they come to me rather than me remembering to ask Gamechanger!

Went through my app's regional pricing recently. 175 countries, and 8 of them had a yearly saving way out of line with everywhere else Standardised them all to 15-20% off twelve months of monthly. Then learned the hard way that Apple only lets you use its own price points, so a nice number in a spreadsheet isn't always a real price. My pricing generator now checks every override against Apple's list Anyone else set prices per country, or just leave Apple's auto-equalised ones?

Ran a bug hunt across every screen of onehaus recently. Found 95 bugs, fixed 52 and left the rest as low priority I run these continuously now instead of saving it all for the end, and always do one final sweep right before a release What did you find in your last bug hunt?

Silently dropping from 20x tier to 10x tier is not great at all. It's almost getting to a point where an open harness and a fleet of open weight models because a better option...

Starting something new for mobile devs, based on my own pains Honestly tired of stitching together a load of platforms for every app I build

Small one if you're building a sign-in code screen. Use one input with autocomplete="one-time-code" and style it as six boxes, rather than six separate inputs Six inputs looks the same but paste and autofill usually end up half broken. Just did it this way on the new project's sign-in pages and it's so much nicer :)

Grok bot has been solid. no complaints so far (in uk)

TIL about Datadog's pathfinding project. It documents pretty much every known AWS IAM privilege escalation path, what permissions each one needs and how to spot it Honestly worth a look if you touch AWS at all

I have a super low end device if you need another device for testing

Nice nice!! Anything we can share a sneak peak of? i’m just cooking away, starting a new project so i can port OneHaus across to it. So just in that exciting early stage part :) will launch the homepage and start posting later this week hopefully

Nice summary of my project @MCPScores - thanks :)

The study if you're curious, 6M posts and accounts under 1k followers actually got more views on link posts playersells.com/learn/does-x…