ANDROID DATABASES:

ANDROID DATABASES:                                      

   Android provides structured data persistence through a combination of SQLite databases and Content Providers. SQLite databases can be used to store application data using a managed, structured approach.

  Android offers a full SQLite relational database library. Every application can create its own databases over which it has complete control.

Having created your underlying data store, Content Providers offer a generic, well-defined interface for using and sharing data that provides a consistent abstraction from the underlying   data source.

·        SQLite Databases:

                               Using SQLite you can create fully encapsulated relational databases for your applications. Use them

To store and manage complex, structured application data.

Android databases are stored in the /data/data/<package name>/databases folder on your

Device (or emulator).

All databases are private, accessible only by the application that created them.

Database design is a big topic that deserves more thorough coverage than is possible within this.

It is worth highlighting that standard database best practices still apply in Android. In particular, when you’re creating databases for resource-constrained devices,

SQLite is a well-regarded relational database management system (RDBMS). It is:

             

·        Open-source

·        Standards-compliant

·        Lightweight

·        Single-tier

It has been implemented as a compact C library that’s included as part of the Android       

Software stack.

By being implemented as a library, rather than running as a separate ongoing process, each SQLite

Database is an integrated part of the application that created it. This reduces external dependencies,

Minimizes latency, and simplifies transaction locking and synchronization.

SQLite has a reputation for being extremely reliable and is the database system of choice for many

Consumer electronic devices, including many MP3 players and smart phones.

Lightweight and powerful, SQLite differs from many conventional database engines by loosely

Typing each column, meaning that column values are not required to conform to a single type;

Instead, each value is typed individually in each row. As a result, type checking isn’t necessary when

Assigning or extracting values from each column within a row