Android SQLite

| Page Views: 361

Android SQLite Database Tutorial and Examples.

What is SQLite and How to use it to store data within android devices.

SQLite is a tiny in process SQL database engine commonly embedded in devices and applications. This is because of it's serverless, zero-configuration and self-containment nature. Not only that but also the fact that it's free and available under public domain. Read more about SQLite here.

Why This Tutorial?

Well we want to see dozens of real world SQLite examples in android. As I said, SQLite is the defacto database engine for android. Most of alternatives to SQLite are not mature enough or run as servers thus requiring alot of configurations and resources. Not only is SQlite the standard db engine for android but also the iOS, the next most popular mobile operating system after android.

So we will write several examples to see how to work with SQLite in different contexts and with several widgets.

SQLite Examples with Different Widgets

1. SQLite CRUD with Spinner.

Spinner is an android widget allowing us display items in a dropdown fashion. It is similar to combobox in other languages. It can be a popular component for rendering data. For instance you can imagine if you a list of category of products that you want users to select. You can fetch them from database and render them in Spinner.

Top Android SQLite Examples

Let's look at some examples.

Android SQLite RushORM Tutorials and Examples.

In this piece we want to discuss RushORM, an Object-relational mapper for Android and then see several practiacl examples of how to use it with adapterviews like recyclerview.

Android SQLite SQLiteOpenHelper Tutorials and Examples.

Best Regards, Oclemy.

How do You Feel after reading this?

According to scientists, we humans have 8 primary innate emotions: joy, acceptance, fear, surprise, sadness, disgust, anger, and anticipation. Feel free to tell us how you feel about this article using these emotes or via the comment section.

About Me.

After completing his Software Engineering bachelors program, Oclemy(Clement Ochieng) these days is a man of two lives. At day he works for a startup in Nairobi, Kenya. At night he works tirelessly on building ProgrammingWizards TV, a tv channel for student coders and this website to help share the source code. In between he practices Meditation and Self actualization to help him keep balance. He also likes going for long solo walks to connect more with nature.


What do You Think

Previous Post Next Post