Android uses the SQLite library to provide complete relational database capabilities without imposing additional restrictions.
Using SQLite, you can create independent and associated databases for each application. They are used to store and manage complex and structured application data.
All Android databases are stored in the/data/<package name>/databases folder of the device (or simulator. By default, all databases are private and only allow access to programs created for them. Share a database between programs. You can use content provider, which will be demonstrated later in this chapter.
Database Design is a huge topic and should be explained in more space, but it is unlikely in this book. However, it is worthwhile to emphasize the best practices for standard database applications. In particular, it is important to use standardized things to reduce data redundancy when creating databases for devices with resource restrictions.
The following sections focus on the practicality of creating and managing SQLite databases in Android.