ORM on Android SQLite and database scheme

android sqlite orm many-to-many crud
BlackLabrador picture BlackLabrador · Jun 4, 2010 · Viewed 26.3k times · Source

I'm looking for a very simple ORM framework working on Android for SQLite. I've been testing ActiveAndroid but none of the example could ever build on Eclipse.
By the way, how do guys implement a "many to many" relationship in SQLite for Android? How do you reflect the cascade regarding deletion of rows and guarantee the database integrity?

Answer

Gray picture Gray · Sep 15, 2010

I am the main author of ORMLite which has a Android backend which makes calls to the native Android OS database APIs to support its ORM functionality. We have a large number of Android developers that are using the framework successfully. See here for more information:

http://ormlite.com/sqlite_java_android_orm.shtml

In terms of many-to-many relationships, ORMLite does not support cascading or any of the more advanced ORM features but there are examples of easy many-to-many implementations:

http://ormlite.com/docs/examples

Related questions

Any good ORM tools for Android development?

Anyone working on the Android ('gPhone') have or know of a place where I can find a good ORM tool for it? The code is written in Java, and the database is SQLite. What I would like to find is …

Read More
Android Room: How to model relationships?

I have just started working with Room and although everything seems to be pretty intuitive I currently don't really understand how exactly I could handle relationships. Because SQLite is a relational database, you can specify relationships between objects. Even though …

Read More
Room Persistence Library run time exception when calling Rooms inMemoryBuilder method

When following the tutorial for setting up the Room persistence library I run in to this error when testing on an Android device. java.lang.RuntimeException: cannot find implementation for PackageName.AppDatabase. AppDatabase_Impl does not exist I know a …

Read More