SQLite

Menu

A year ago I wrote a tutorial on how to use PouchDB + SQLite for an Ionic 1 app. Now that Ionic 2 is in beta, I've updated the tutorial for Ionic 2 and the recently released Cordova SQLite Plugin 2. Read More

A few months ago I wrote a tutorial on how to use PouchDB for local storage in Ionic apps. I've recently come across another library called LokiJS that promises fast performance because it uses an in-memory database. In this tutorial we'll take the same app I used in the PouchDB tutorial and build it with LokiJS instead. Read More

I was recently looking into local storage options for an Ionic app. From what I could find, the most popular choice is to use a SQLite database. However, I kept running into people mentioning PouchDB to store data locally and sync it with a server, but I didn't need a server for this particular app. PouchDB also uses a NoSQL approach to database storage, and I come from a SQL background, so I figured I should just go with SQLite. After reading a bit more, I realized that development would be a lot faster and easier with PouchDB, even if you only use it for local storage. Read More