Leo Builds

A Blog post on choosing the right method of Social Sign-in

Staging Tables vs Unified DB schema

A look at the architectural trade-offs between ETL and ELT-style data integration when building a real-time Gig tracking app. The Challenge: Many Sources, One Truth In order to make Stubbit as comprehensive as possible I tried to get as many external data…

Been using Google's AntiGravity for a bit but I'm finding I'm losing oversight and control of my codebase with full on Agentic vibe coding. Switching back to using Gemini is the right balance for me at the moment.

Why I Chose Supabase (SQL) over Firebase (NoSQL)

When it came to choosing the backend for Stubbit I knew i wanted to use a Backend-as-a-Service (BaaS) rather than building everything from scratch myself as it would be far easier and quicker and would come with all of the additional features such…

Had some spare time this morning and took @expo.dev SDK54's new native tabs in expo-router for a spin.

The API feels great. Native tabs are a big piece of the puzzle- and now with native, JS, and custom tabs, it’s easier than ever to match any app’s design language 🚀

ugh, major setback/pain in the arse. Somehow realise i didn't include genres for my artists (only events) and now i have to backfill them but with an api call limit of 1000 a day and 100k+ artists 😫

Getting round to the front end whilst data cleansing finishes up.
Got the home screen flatlists with Tanstack infinite scroll going, the My Events screen, basic search functionality and now working on the Add Event modal.

Bare bones are coming together 🚀

I found getting to grips with Tamagui too much of a faff and a bunch of issues getting set up with Expo SDK 53 so switched over to Gluestack-ui.

I just want some snazzy pre-made components damn it

Turns out having a newborn can slow down side projects 😅

Uugh, hit the DB size limit on #supabase

May have to upgrade if I want a truly comprehensive dataset for MVP but hoping some data cleansing will get the size down for now 🤞

Did not disappoint! ☺️

Musicbrainz for artist and venue data integrity 👌

COYS COYS COYS!!

Yes yes yes! Can't wait for this 🎉

Oh I've had to completely write off gardening this year! Which is a shame as I got some really good fruit and veg last year.

But it's just about prioritisation, making a bit of progress everyday and not beating yourself up too much for not being able to do everything.

Tbh, building this app is the easy part, especially with the ai tools available now.

The hard part is going to be launching and marketing, which I know won't be a strength of mine.

But the only way to improve is to do.

House renovations and a full time job as well as other incoming responsibilities mean progress isn't as fast as I'd like.

But we push on! Backend completion is in sight 🔦

Another data source set up for daily ingestion 👌

Backend is coming on.

Now to figure out historical data as best I can (ideal source would be user submitted) and tidy things up before moving on to front end properly 📱

#buildinpublic #reactnative #supabase #gigs #stubbit

I've got TicketMaster for future gigs but historical data is proving more tricky

The Skiddle api doesn't link events and artists easily,
Songkick is too expensive for me right now and the Dice api is for partners only

Any ideas out there, conventional or otherwise, for getting this kind of data?

Finally finished my edge functions so we're pulling new events and artists from TicketMaster into the new unified schema DB on a daily basis now 🙌

Expo SDK 53 - Expo Changelog Learn about the changes and how to upgrade

🙌 SDK 53 is out now!

It's a chunky release so take your time combing through the post below. Couple highlights:

◆ The New Arch is now default everywhere
◆ Edge-to-edge is default for all android projects
◆ expo-background-task (no more background-fetch)
◆ expo-maps alpha!

expo.dev/changelog/sd...

What are people's experiences using Supabase for production React Native projects?

Recommended?

Things to look out for?

#buildinpublic #reactnative #supabase

It's crazy how good Gemini is!
Not just with your direct question but with unprompted broader thinking and suggestions.
I've had super long conversations with it but still no sign of hallucinations too!

Been using Gemini 2.5 to revamp my DB. Gone from staging tables for each data source and ETL into master data tables to a unified schema and junction tables.

Gym x Nu Metal

Undefeated Millennial partnership

a group of cartoon characters are standing next to each other and one of them is asking " can you " ALT: a group of cartoon characters are standing next to each other and one of them is asking " can you "

It's sad that you could never have a cultural phenomenon like 'Who shot Mr Burns' these days

YouTube video by Leo Builds An App Getting data for your App using API's (badly)

Another masterclass in how not to do things!

youtu.be/lPxO2VyGrKM?...

Great to have you back 😊

No worries man, I wish I could create something that looks so cool!