NOTE: This article demonstrates a way to set up a database for private in-app use only. If you need to provide content to the outside world, this article is not for you.

You want use a database inside your application to store static or dynamic content, right? Then perhaps you went to the Android docs on creating databases? The first thing you’ll notice is that it mentions content providers and the NotePadProvider example of this principle. Once you start digging into that, you may very well get lost at first, consider how convoluted this system works, with uri’s, matchers, paths and all. It gets messy quickly with lots of constants denoting your exposed content URI’s on top of your database properties and mapping in between.

Toss all that out please, you don’t need it.

read on

Since the Android SDK doesn’t come with the source code, you need to get it manually from the Google Git repo’s. Unfortunately, the tutorial is Linux oriented and convoluted. Fortunately, us pesky Windows users have people like Brad Chow and some helpful Asian folks that provide us with a solution out of the box.

Here’s a recap:

read on