Google highly recommend using Room instead of SQLite.

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. So, I happen to know about SQLite database programming and in this Android SQLite tutorial,I’ll show you exactly how to create a 1) Simple CRUD (CREATE, READ, UPDATE, DELETE)app using Android Studioand Java. 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.

Kotlin sqlite