Our experience with Room in Android after a few months of use

, Software Pundits
This post was originally published on this site

Apium Hub

After a few months working with Room in Android we have encountered some problems that have really hindered our development compared to other ORM in the market (such as Hibernate). Some of the problems found are the following: 

Room in android issues Do not allow manual insertion queries, you can only annotate methods with @Insert and define the replacement strategy in case there are conflicts. It does not allow to define Foreign Keys as collections within an entity. For example, if we have a Album entity, we can not define a List <Track> as a Foreign Key within it, but force us to put an albumId field annotated as Foreign Key in the track Track entity. This makes the insertions in the Album table not atomic since you have to insert them in two tables separately (nor does it allow custom insertion queries as seen in the first point). It

To read the full article click on the 'post' link at the top.