Best database to use for my ionic project?

ionic-v1
1

I’m looking for the best database to use for my ionic project. I want the user to store the database locally with the option of synchronizing that information a remote database. I want the user to be able to access their data from any device by login. Pouchdb or cordova SQLite look like a good option. I plan to use nodejs or PHP on the server. Are these the best options? I need the user to be able to access their data on older devices and browser.

1 Like
2

I would look into Parse (my choice) or Firebase. They are free and entire backend solutions. I’ve also seen a plugin on Github for local datastore with parse and it may come with Firebase.

3

I will take a look at Parse and Firebase. Thanks

4

Hey,

What Did you choose ?

PouchDB and CouchDB seems to have a great sync module for a Off mode.
NodeJS is kind of great

Do you know if the current mobile backend as a service provide easily a off mode for ionic app ?
Cheers

5

Hey there. I am currently using Parse, as it is kinda cheaper than Firebase when going on production, plus, i can connect to Parse via .NET api’s and i can handle Push Notifications from there. It is a good DataBase, but if you want to build your own server, and handle local data, i don’t know if it is the best. Maybe using PouchDB and CouchDB to both offline and online use is best for your case. But do look into Parse, it is really neat and easy to set up, and Facebook now owns it if i’m not mistaken… But keep in mind, it is a NoSQL database, so the logic for it changes a bit. Altough it is not even close to hard to understand.
Cheers :wink:

1 Like
6

I need a local database that can send json to an arduino build I am making and a server out on the internet. From my research right now I am thinking of using PouchDB and CouchDB.

7

For what you need then, Pouch/CouchDB would be interesting. If you haven’t seen it already, try this post here, altough you might have already seen it. Hope you can manage, good luck :slight_smile:

8

LocalStorage is a great option if there is not much data to store locally. Or if you need a more flexible and larger database you might want to try IndexedDB or SQLite Plugin for Cordova(Ionic is built on top of Cordova), all of these options are for the client end.
But for the server end, I have used FireBase for one of my projects and I know it works like charm, if you are familiar with Polymer/Web Components all you have to do to have FireBase, add just one line of html and everything else is set up for you. For completing your future writing work you can use this custom essay writing service for best support.

9

Hi All,

I’m a little late to the discussion, but I thought I would share my findings.

The information I can share is as follows:

  1. I have used a local sql database. Easy to setup and easy to use if you are used to writing sql statements. The drawback is that you will have to write your own sync methods / api calls, and it’s a pain the backend to update if you need to.
  2. Couchbase (not to be confused with couchdb) -> pouchdb (local on the phone) with integrated facebook authentication via a couchbase sync gateway. This is great, it deals with all of my requirements being that I have a local database (noSQL) so my app is off line, I have a cloud store which each app can sync with (mobile, web, etc). The draw back is that it’s not a cheap option. The downside is that it took a fair amount of time to setup and there are quite a few gotchas along the route.
  3. Parse.io - This looks great - I have only had a dabble with it but the docs look good and the implementation looks straight forward (and the pricing is great for initial development). I haven’t yet found parses’ pouchdb counterpart, if I can then I would probably take this route for future development.