SQLITE

TwitterFacebook
Get flash to fully experience Pearltrees
Most of the Android database examples you will find on the web will usually contain only one table to demonstrate the basic database concepts. That's great, the only problem with this is that most non-trivial database implementations will contain more than one table. The standard database creation string for a single table will probably look a lot like the below: private static final String CREATE_TABLE_1 = " create table " + table1 + " (_id integer primary key autoincrement," + " title text not null, body text not null);"; http://androidforbeginners.blogspot.com/2010/01/creating-multiple-sqlite-database.html

Creating multiple sqlite database tables in Android

Ver blog tiene cosas muy interesantes by diegounanue Feb 21

Bases de Datos en Android (III): Consultar/Recuperar registros | sgoliver.net blog

En el anterior artículo del curso vimos todas las opciones disponibles a la hora de insertar, actualizar y eliminar datos de una base de datos SQLite en Android. http://www.sgoliver.net/blog/?p=1646

SQLite foreign key examples | How to create SQLite foreign keys

http://alvinalexander.com/android/sqlite-foreign-keys-example SQLite foreign keys FAQ: Can you show me how to define in a SQLite database table design? The SQLite database does support , and its foreign key syntax is similar to other databases.

Foreign Key Support

http://www.sqlite.org/foreignkeys.html Small. Fast. Reliable.