Is it a good idea to use an ORM for Android apps?

Question

Is it a good idea to use an ORM (Object Relational Mapper) like:

• ORMLite
• ActiveAndroid

for Android apps.

The abstraction layer this technique adds has itself calculation and memory overhead. Since, those resources and the battery lifetime are mostly very limited I would think 'no', but on the other hand it makes the code much cleaner, because one almost never has to write raw queries.

• What are the pros and cons?
• What is recommended?
• If it is recommended, which one should I use?

Answer 1

As of May 18, 2017, Google introduced Room at I/O '17 as replacement for raw SQLite queries. So, at least this ORM is now officially recommended.