NewCode with Beto MCP

Building a Budget Buddy App with React Native Expo SQLite

Beto, February 18, 2024 · 43,288 views

Your budget app does not need a server. SQLite runs on every phone (over 1 trillion active databases worldwide), and Expo SQLite gives you real SQL right on the device. So I built a budget tracker with Expo SDK 50 that works offline and keeps your financial data private.

I build it step by step in the video.

What's inside

  • Design a relational schema with categories and transactions tables
  • Create and seed the database with the sqlite3 CLI
  • Insert, query, and delete expenses from React Native
  • Recalculate totals live as the data changes
  • Keep huge numbers readable with auto-sizing text
  • Where to go next: pagination, exports, and cloud sync

Resources

CourseReact Native course

Let's connect!

Had a win? Get featured on Code with Beto.Share your story