How to set up SQLite for Android app development

So looking to add a backend service?

Well to do that you need backend server which can host such database. Ideally you can use webserver framework such as ruby on rails and then you can create a RESTful api to communicate from android app to the server.

Check this out... http://stackoverflow.com/questions/10116843/backend-server-provider-for-mobile-apps

The nice thing about SQLite is that it is intended to be designed for on-device functionality. Typically, when people use SQLite they are using it without calls to a "backend" server. So you can just use it locally on device without server calls. So if you want to consider using SQLite on device here is a good place to start -> http://developer.android.com/guide/topics/data/data-storage.html#db

Now if you want to have this SQLite database setup on a backend server its worth noting that most server side solutions will use a heavier database stack like MS SQL Server, Mongo, MySQL, etc because they can afford a larger installation on the server as well as capacity to run it. Thats not to say SQLite isnt impossible as there are sqlite libraries and extensions in most languages. For instance here is one for ruby https://github.com/sparklemotion/sqlite3-ruby