Android Development

542 readers

1 users here now

Welcome to the programming.dev Android development community!

The Android robot is reproduced or modified from work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License

founded 1 year ago

MODERATORS

erlingur

will

Ategon

Are there ORMs for android that support many-to-many relationships? (self.android_dev)

submitted 2 months ago* (last edited 2 months ago) by tinkralge to c/android_dev

2 comments fedilink hide all child comments

I have no experience with android apps and just started working on one that needs to work with relational data. The relational data has multiple many-to-many relationships and the inbuilt ORM (Room) is leads to class explosion.

While looking at ORM libraries for android, there seem to be many that are out of date:

From 5 of the Best Android ORMs (2014) and AlexeyZatsepin/Android-ORM-benchmark (2017)

ORMLite: 3 years old and the M2M example makes me feel quite queasy
SugarORM: description explicitly only mentions 1:1, 1:n
GreenDAO is unmaintained but replaced by ObjectBox which I haven't yet looked at
Active Android: abandoned
Realm redirects to MongoDB 💀
Freezer: abandoned
DBFlow: no documentation and 3 seemingly abandoned
Requery: 4 years old (abandoned?). Actually my favorite in terms of API
Sprinkles: 10 years old, dead

I'm leaning towards Requery because I like its API the most (hides SQL the most), but haven't looked at ObjectBox yet.

top 2 comments

sorted by: hot top controversial new old

[–] [email protected] 2 points 2 months ago (1 children)

I have used ObjectBox in dart and it does support mtm relationships (you may need to define an intermediate model for the relationship. I can't remember off the top of my head). It worked great for me with only 1 or 2 gotchas that weren't well documented.

[–] tinkralge 1 points 2 months ago

Thanks. It does look like the right library to use. A little surprising that it seems to be the only one that's up to date, but at least it exists!