Has anyone seen this tutorial on how use SQLLite database with Google's Android?

(Last Updated On: October 21, 2010)

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:

1. 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).
2. Referential integrity is not maintained in SQLite, there is no FOREIGN KEY constraints or JOIN statements.
3. 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:

1. Employees
2. Dept.

Views:

1. ViewEmps: to display employees and their relative departments.

http://www.codeproject.com/KB/android/AndroidSQLite.aspx

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!