Skip to main content
Image

r/ionic

Feed About
Best
Open sort options
Change post view
Capacitor SQLite Tutorial — CRUD, Transactions & Starter Apps
u/DayanaJabif avatar u/DayanaJabif
Capacitor SQLite Tutorial — CRUD, Transactions & Starter Apps

If you're building a Capacitor app and need a solid way to handle local data, I put together a practical SQLite tutorial.

SQLite gives you a much more robust alternative to things like localStorage or IndexedDB:

  • Structured queries, filtering, and relationships

  • Fast and predictable performance

  • Transactions for data consistency

  • Same API across iOS, Android, and Web

In the video I focus on the fundamentals with a simple demo:

  • CRUD operations

  • Transactions (how to use them properly)

  • Structuring your data layer in a Capacitor app

I also included free starter apps so you don’t have to start from scratch:

🎥 Full tutorial:
https://www.youtube.com/watch?v=JJg2r1UIxlk

⚡ Demo app screencast:
https://www.youtube.com/shorts/fL4NMJTvMlw

Would love feedback or to hear how you’re handling local data in your apps 🙌

The project uses capacitor-sqlite plugin which is only available to Capawesome Insiders.

Norman is back to being part of the action—and back to his old self. With once-monthly Librela (bedinvetmab injection), Norman’s osteoarthritis (OA) pain is under control. See more of Norman’s real results with Librela at Librela.com.

Please see Prescribing Information for Librela.

media poster
zoetispetcare.com
Learn More
What’s your experience using Firebase in Ionic/Capacitor mobile apps? (Web SDK vs native plugins)
u/DayanaJabif avatar u/DayanaJabif
What’s your experience using Firebase in Ionic/Capacitor mobile apps? (Web SDK vs native plugins)
What’s your experience using Firebase in mobile apps? (Web SDK vs native plugins)
r/capacitor •
What’s your experience using Firebase in mobile apps? (Web SDK vs native plugins)

Do you mostly use the Firebase Web SDK, or do you rely on native plugins for things like auth, push notifications, file uploads, etc?

From my experience building mobile apps with Capacitor/Ionic, starting with the Web SDK is super fast. But once you get into more “real” mobile features, things can get tricky, especially if you want proper native experiences like Google/Apple sign-in or reliable push notifications.

I still see a lot of apps using the Web SDK even for those cases, which usually leads to edge cases and platform-specific issues sooner or later, and of course a poor UX.

Personally, I’ve had much better results moving those parts to native plugins.

One set I’ve been using/recommending lately is Capacitor Firebase plugins. They basically bridge your web code with the native Firebase SDKs (iOS & Android).

Curious what others are doing in practice:

  • Are you using web, native, or a mix?

  • At what point did you switch (if you did)?

  • Any plugins you’d recommend?

Would love to hear real experiences 🙌

upvotes comments