Capacitor SQLite Demo (React)

A simple CRUD expenses app built with React, Ionic, Capacitor, and SQLite. Source code for the step-by-step video tutorial.

Looking for Angular? See the Angular version.

Features

• Create, edit, and delete expenses
• Local persistence with SQLite
• Schema creation via upgradeStatements
• Typed queries and parameterized statements
• Transactions with commit and rollback
• Database connection lifecycle management
• Web support via @sqlite.org/sqlite-wasm

Check the demo

Built with

• React 18
• Ionic 8
• Capacitor 8
• @capawesome-team/capacitor-sqlite

Getting started

The SQLite plugin requires a Capawesome Insiders license key:

npm config set @capawesome-team:registry https://npm.registry.capawesome.io
npm config set //npm.registry.capawesome.io/:_authToken <YOUR_LICENSE_KEY>

Install dependencies and run:

npm install
npm start

To run on native platforms:

npm run build
npx cap sync
npx cap open android # or ios