ionic-angular-sqlite-starter
Ionic/Angular application demonstrating the use of the
@capacitor-community/sqlite
this app uses Capacitor 4
Maintainer | GitHub | Social |
---|---|---|
Quéau Jean Pierre | jepiqueau |
This application is a complete starter solution for Ionic 6 Angular SQLite CRUD operations using @capacitor-community/sqlite plugin with Capacitor 4.
This application will implement the well known Authors-Posts-Categories
SQLite database.
PostData {
id!: number;
title!: string;
text!: string;
author!: Author;
categories!: Category[];
}
Author {
id!: number;
name!: string;
email!: string;
birthday?: string;
}
Category {
id!: number;
name!: string;
}
Database schemas are defined using the Incremental Upgrade Database Version
workflow in the folder src/app/upgrades/author-posts/upgrade-statements
following the guidelines (https://github.com/capacitor-community/sqlite/blob/master/docs/IncrementalUpgradeDatabaseVersion.md).
Access to the @capacitor-community/sqlite plugin is made through the use of an angular service (src/app/services/sqlite.service.ts
).
Initialization of the application is made in the angular service (src/app/services/initialize.app.service.ts
) which instantiate the sqlite service, create database schemas and upload the mock data.
In database version 2, company
column was added to the author
table.
To start building your App using this App, clone this repo to a new directory:
git clone https://github.com/jepiqueau/ionic-angular-sqlite-starter.git
cd ionic-angular-sqlite-starter
git remote rm origin
- then install it
npm install
- if you use the Electron platform
npm run electron:install
- the capacitor config parameters are:
"appId": "com.jeep.app.ionic.angular.sqlite",
"appName": "ionic-angular-sqlite-starter",
-
development
- angular cli
npm run start
- ionic cli
ionic serve
-
production
npm run build:web
npm run build:native
npx cap sync
npx cap copy
npx cap open android
Once Android Studio launches, make sure that you are using
- Gradle JDK version 11
- Android Gradle Plugin Version 7.2.2
and build your app through the standard Android Studio workflow.
npx cap open ios
Once Xcode launches, you can build your app through the standard Xcode workflow.
npm run ionic:android
Once Android Studio launches, make sure that you are using
- Gradle JDK version 11
- Android Gradle Plugin Version 7.2.2
and build your app through the standard Android Studio workflow.
npm run ionic:ios
Once Xcode launches, you can build your app through the standard Xcode workflow.
npm run electron:start
Thanks goes to these wonderful people (emoji key):
This project follows the all-contributors specification. Contributions of any kind welcome!