Android Development

477 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

[email protected]

Are there ORMs for android that support many-to-many relationships? (programming.dev)

submitted 1 week ago* (last edited 1 week ago) by [email protected] to c/[email protected]

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.

you are viewing a single comment's thread
view the rest of the comments

[–] chickenf622 2 points 1 week 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.

[–] [email protected] 1 points 6 days 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!