Learn how to use SQLiteOpenHelper and Database Inspector when building your next Android app.
Join the DZone community and get the full member experience. SQLite is an open-source relational database, similar to MySQL. Android includes a SQLite library in its standard library that implements a serverless, zero-configuration, and transactional SQL database engine. SQLite does not run on a database server, but stores all its data in simple files. A complete SQLite database with many tables, triggers, indices, and views is contained in a single disk file. SQLite is built into all mobile phones and most computers and comes bundled inside. It carries lightweight data and does not require any administration or setup procedure of the database. The package android.database.sqlite. SQLiteDatabase consists of all the APIs to perform CRUD operations from our android application. SQLiteOpenHelper is an in-built class of android.database.sqlite. SQLiteDatabase package. It is a helper class to manage SQLite database creation and version management. The helper class manages the creation of the database, handling database manipulations, and also the version management. We need to create a subclass extending from SQLiteOpenHelper class for database manipulations.
