Has anyone seen this tutorial on how use SQLLite database with Google’s Android?
It starts out like:
Android default Database engine is Lite. SQLite is a lightweight transactional database engine that occupies small amout of disk storage and memory, so its a perfect choice for creating databases on many mobile operating systems such as Android, iOS.
Things to consider when dealing with SQLite:
- Data type integrity is not maintained in SQLite, you can put a value of a certain data type in a column of another dataype (put string in an integer and vice versa).
- Referential integrity is not maintained in SQLite, there is no FOREIGN KEY constraints or JOIN statements.
- SQLite Full Unicode support is optional and not installed by default.
In this tutorial we will create a simple database application to store employees data. the DB has: Tables:
- ViewEmps: to display employees and their relative departments.