SQLiteOpenHelper(context, DB_NAME, null, DB_VERSIOM) Step 3. Import Ĭlass DatabaseHandler(context: Context) : You may also want to implement the onDowngrade() or onOpen() methods, but they are not required in this example. Must override the onCreate() and onUpgrade() callback methods. } Step 2. Create DatabaseHandler kotlin class and extend SQLiteOpenHelper Google highly recommend using Room instead of SQLite.Step 1. Create an android project in the android studio (Follow this tutorial: Android First Program in Android Studio kotlin) Step 2. Create a model class (POJO): UsersĬreate a package directory in the root package its good practice to maintain your code. In addition, we needed to remember the queries (like insert, update, delete), and we also needed to write quite a bit of code to make database connections and versions and table column names.īut now we have the Room database, which was launched at Google IO in 2017. First, the database size was restricted to 2GB in most cases. SQLite was mostly easy to use and had some distinct advantages-it allowed data storage in a structured manner, performed better than other databases, and was a lightweight option compared to other 3rd party databases.īut there were also some limitations. Before Room:īefore Room, and for a long time, Android developers have relied on SQLite as a primary database. But before jumping in, let’s first take a look at what we’ve previously been using for data storage in Android.

In this article, we’ll learn about how Android developers can effectively use the Room database to improve data storage processes-and specifically, inserting and fetching records.

Sqlite kotlin