First of all, SQLite is not an SQL database. It is an embedded SQL database engine. SQLite does not have any separate server process like the other SQL databases have. SQL database which includes tables, views and other things are contained in a single disk file whereas SQLite operates by directly reading and writing to ordinary files on the disk.<\/p>\n
SQLite implements serverless, self-contained, transactional, zero-configuration SQL database engine which is an in-process library. SQLite is free and is in public domain also, so it can be used for any private and commercial purpose.<\/p>\n
Ionic Local Storage uses the local storage system of browser for key\/value pairs storing. The limit of Local Storage is only 5MB. It is heard that an issue with local storage is that if iOS is out of memory, it can delete local storage data to gain memory space. Local Storage should be used only for temporary data storing where data loss can be affordable. Local Storage must be cleaned up by the operating system(iOS) to manage the storing of data under 5MB. If more space is needed for storing data, then SQLite is more preferable which uses SqlStorage engine.<\/p>\n
SQLite is a widely used file-based database and one of the most stable storage system for Ionic App.<\/p>\n
<\/p>\n
For using the SOLite, first we need to install the cordova-sqlite-storage plugin:<\/p>\n
ionic cordova plugin add cordova-sqlite-storage<\/strong><\/p>\n \u00a0<\/strong><\/p>\n After that, we need to install the package<\/p>\n npm install –save @ionic\/storage<\/strong><\/p>\n \u00a0<\/strong><\/p>\n Then, import it in the app.module.ts<\/strong> and add it to the imports<\/strong><\/p>\n import { IonicStorageModule } from ‘@ionic\/storage’;<\/strong><\/p>\n @NgModule({<\/strong><\/p>\n \u00a0 declarations: [<\/strong><\/p>\n \u00a0\u00a0\u00a0 \/\/ …<\/strong><\/p>\n \u00a0 ],<\/strong><\/p>\n \u00a0 imports: [<\/strong><\/p>\n \u00a0\u00a0\u00a0 BrowserModule,<\/strong><\/p>\n \u00a0\u00a0\u00a0 IonicModule.forRoot(MyApp),<\/strong><\/p>\n \u00a0\u00a0\u00a0 IonicStorageModule.forRoot()<\/strong><\/p>\n \u00a0 ],<\/strong><\/p>\n \u00a0 bootstrap: [IonicApp],<\/strong><\/p>\n \u00a0 entryComponents: [<\/strong><\/p>\n \u00a0\u00a0\u00a0 \/\/ …<\/strong><\/p>\n \u00a0 ],<\/strong><\/p>\n \u00a0 providers: [<\/strong><\/p>\n \u00a0\u00a0\u00a0 \/\/ …<\/strong><\/p>\n \u00a0 ]<\/strong><\/p>\n })<\/strong><\/p>\n export class AppModule {}<\/strong><\/p>\n \u00a0<\/strong><\/p>\n Finally, use it inside any component or page<\/p>\n import { Storage } from ‘@ionic\/storage’;<\/strong><\/p>\n export class MyApp {<\/strong><\/p>\n \u00a0 constructor(private storage: Storage) { }<\/strong><\/p>\n \u00a0 …<\/strong><\/p>\n \u00a0 \/\/ set a key\/value<\/strong><\/p>\n \u00a0 storage.set(‘name’, ‘Max’);<\/strong><\/p>\n \u00a0 \/\/ Or to get a key\/value pair<\/strong><\/p>\n \u00a0 storage.get(‘age’).then((val) => {<\/strong><\/p>\n \u00a0\u00a0\u00a0 console.log(‘Your age is’, val);<\/strong><\/p>\n \u00a0 });<\/strong><\/p>\n }<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":" First of all, SQLite is not an SQL database. It is an embedded SQL database engine. SQLite does not have any separate server process like the other SQL databases have. SQL database which includes tables, views and other things are contained in a single disk file whereas SQLite operates by directly reading and writing to […]<\/p>\n","protected":false},"author":32,"featured_media":1688,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[92,102],"tags":[74,104],"yoast_head":"\n