Week 10 database SQL

Sqlite is a software RDBMS (Relational Database Management System) that supports natively (native) for Android devices. Sqlite is a database management system, which has ACID-compliant properties, programmed in C language, and has a relatively small size or memory size. Because Sqlite includes embedded database engine (embedded), so the Sqlite command can only be used only standard commands. And Sqlite only supports data types such as NUMERIC, DATETIME, TEXT, and others.

The instruction row (coding) in Sqlite is also a public domain developed by D. Richard Hipp. This means you can use Sqlite freely for any purpose, whether commercial or private. Sqlite supports all operating system platforms, such as: Windows, Linux, Android and iOS.

Particularly on the Android OS, the Sqlite Android App will be integrated into a system called Android Run time. SQLlite is built in available in the android library. So we can use it, directly, without the need to use software or import other libraries, when we are developing Android Applications. We can also create a Sqlite database, using the SQL user interface (interface).

SqliteOpenHelper is a subclass, which is used to determine the database name and version of the database being used. You can apply methods in this class like: OnCreate (SqliteDatabase), OnUpgrade (SqliteDatabase int int) and OnOpen (SqliteDatabase).