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

submitted 10 months ago* (last edited 10 months 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.

top 2 comments

sorted by: hot top new old

[-] [email protected] 2 points 10 months ago

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 10 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!

this post was submitted on 08 Sep 2024

3 points (100.0% liked)

Android Development

641 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 2 years ago

MODERATORS

[email protected]