Alternatives to Android Room logo

Alternatives to Android Room

SQLite, GreenDAO, Realm, Firebase, and DBFlow are the most popular alternatives and competitors to Android Room.
154
187
+ 1
2

What is Android Room and what are its top alternatives?

It provides an abstraction layer over SQLite to allow fluent database access while harnessing the full power of SQLite. Apps that handle non-trivial amounts of structured data can benefit greatly from persisting that data locally. The most common use case is to cache relevant pieces of data.
Android Room is a tool in the Database Tools category of a tech stack.

Top Alternatives to Android Room

  • SQLite

    SQLite

    SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. ...

  • GreenDAO

    GreenDAO

    It is an open source Android ORM making development for SQLite databases fun again. It relieves developers from dealing with low-level database requirements while saving development time. ...

  • Realm

    Realm

    The Realm Mobile Platform is a next-generation data layer for applications. Realm is reactive, concurrent, and lightweight, allowing you to work with live, native objects. ...

  • Firebase

    Firebase

    Firebase is a cloud service designed to power real-time, collaborative applications. Simply add the Firebase library to your application to gain access to a shared data structure; any changes you make to that data are automatically synchronized with the Firebase cloud and with other clients within milliseconds. ...

  • DBFlow

    DBFlow

    It is fast, efficient, and feature-rich Kotlin database library built on SQLite for Android. It utilizes annotation processing to generate SQLite boilerplate for you and provides a powerful SQLite query language that makes using SQLite a joy. ...

  • Hibernate

    Hibernate

    Hibernate is a suite of open source projects around domain models. The flagship project is Hibernate ORM, the Object Relational Mapper. ...

  • Slick

    Slick

    It is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred. ...

  • Spring Data

    Spring Data

    It makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. This is an umbrella project which contains many subprojects that are specific to a given database. ...

Android Room alternatives & related posts

SQLite logo

SQLite

10.6K
8.4K
528
A software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine
10.6K
8.4K
+ 1
528
PROS OF SQLITE
  • 160
    Lightweight
  • 134
    Portable
  • 121
    Simple
  • 80
    Sql
  • 28
    Preinstalled on iOS and Android
  • 2
    Tcl integration
  • 1
    Free
  • 1
    Telefon
  • 1
    Portable A database on my USB 'love it'
CONS OF SQLITE
  • 2
    Not for multi-process of multithreaded apps
  • 1
    Needs different binaries for each platform

related SQLite posts

Dimelo Waterson
Shared insights
on
PostgreSQL
MySQL
SQLite

I need to add a DBMS to my stack, but I don't know which. I'm tempted to learn SQLite since it would be useful to me with its focus on local access without concurrency. However, doing so feels like I would be defeating the purpose of trying to expand my skill set since it seems like most enterprise applications have the opposite requirements.

To be able to apply what I learn to more projects, what should I try to learn? MySQL? PostgreSQL? Something else? Is there a comfortable middle ground between high applicability and ease of use?

See more
Daniel Quinn
Senior Developer at Workfinder · | 2 upvotes · 370.5K views

SQLite is a tricky beast. It's great if you're working single-threaded, but a Terrible Idea if you've got more than one concurrent connection. You use it because it's easy to setup, light, and portable (it's just a file).

In Paperless, we've built a self-hosted web application, so it makes sense to standardise on something small & light, and as we don't have to worry about multiple connections (it's just you using the app), it's a perfect fit.

For users wanting to scale Paperless up to a multi-user environment though, we do provide the hooks to switch to PostgreSQL .

See more
GreenDAO logo

GreenDAO

5
22
0
An open source Android ORM making development for SQLite databases
5
22
+ 1
0
PROS OF GREENDAO
    Be the first to leave a pro
    CONS OF GREENDAO
      Be the first to leave a con

      related GreenDAO posts

      Realm logo

      Realm

      196
      292
      12
      Realm makes it easy to build reactive apps, realtime collaborative features, and offline-first experiences.
      196
      292
      + 1
      12
      PROS OF REALM
      • 6
        Good
      • 2
        Cloud Syncing
      • 2
        Elegant API
      • 1
        React Native Support
      • 1
        Strong Adoption Growth
      CONS OF REALM
        Be the first to leave a con

        related Realm posts

        Firebase logo

        Firebase

        24.5K
        20.6K
        1.9K
        The Realtime App Platform
        24.5K
        20.6K
        + 1
        1.9K
        PROS OF FIREBASE
        • 361
          Realtime backend made easy
        • 263
          Fast and responsive
        • 234
          Easy setup
        • 207
          Real-time
        • 186
          JSON
        • 127
          Free
        • 121
          Backed by google
        • 81
          Angular adaptor
        • 63
          Reliable
        • 36
          Great customer support
        • 26
          Great documentation
        • 23
          Real-time synchronization
        • 20
          Mobile friendly
        • 17
          Rapid prototyping
        • 12
          Great security
        • 11
          Automatic scaling
        • 10
          Freakingly awesome
        • 8
          Chat
        • 8
          Angularfire is an amazing addition!
        • 8
          Super fast development
        • 6
          Awesome next-gen backend
        • 6
          Ios adaptor
        • 5
          Built in user auth/oauth
        • 5
          Firebase hosting
        • 4
          Speed of light
        • 4
          Very easy to use
        • 3
          It's made development super fast
        • 3
          Great
        • 3
          Brilliant for startups
        • 2
          Great all-round functionality
        • 2
          Low battery consumption
        • 2
          I can quickly create static web apps with no backend
        • 2
          The concurrent updates create a great experience
        • 2
          JS Offline and Sync suport
        • 1
          Faster workflow
        • 1
          Large
        • 1
          Serverless
        • 1
          .net
        • 1
          Free SSL
        • 1
          Good Free Limits
        • 1
          Push notification
        • 1
          Easy to use
        • 1
          Easy Reactjs integration
        CONS OF FIREBASE
        • 28
          Can become expensive
        • 15
          Scalability is not infinite
        • 14
          No open source, you depend on external company
        • 9
          Not Flexible Enough
        • 5
          Cant filter queries
        • 3
          Very unstable server
        • 2
          Too many errors
        • 2
          No Relational Data

        related Firebase posts

        Stephen Gheysens
        Senior Solutions Engineer at Twilio · | 12 upvotes · 112.9K views

        Hi Otensia! I'd definitely recommend using the skills you've already got and building with JavaScript is a smart way to go these days. Most platform services have JavaScript/Node SDKs or NPM packages, many serverless platforms support Node in case you need to write any backend logic, and JavaScript is incredibly popular - meaning it will be easy to hire for, should you ever need to.

        My advice would be "don't reinvent the wheel". If you already have a skill set that will work well to solve the problem at hand, and you don't need it for any other projects, don't spend the time jumping into a new language. If you're looking for an excuse to learn something new, it would be better to invest that time in learning a new platform/tool that compliments your knowledge of JavaScript. For this project, I might recommend using Netlify, Vercel, or Google Firebase to quickly and easily deploy your web app. If you need to add user authentication, there are great examples out there for Firebase Authentication, Auth0, or even Magic (a newcomer on the Auth scene, but very user friendly). All of these services work very well with a JavaScript-based application.

        See more
        Tassanai Singprom

        This is my stack in Application & Data

        JavaScript PHP HTML5 jQuery Redis Amazon EC2 Ubuntu Sass Vue.js Firebase Laravel Lumen Amazon RDS GraphQL MariaDB

        My Utilities Tools

        Google Analytics Postman Elasticsearch

        My Devops Tools

        Git GitHub GitLab npm Visual Studio Code Kibana Sentry BrowserStack

        My Business Tools

        Slack

        See more
        DBFlow logo

        DBFlow

        7
        12
        0
        Simple ORM android database library
        7
        12
        + 1
        0
        PROS OF DBFLOW
          Be the first to leave a pro
          CONS OF DBFLOW
            Be the first to leave a con

            related DBFlow posts

            Hibernate logo

            Hibernate

            1K
            874
            22
            Idiomatic persistence for Java and relational databases.
            1K
            874
            + 1
            22
            PROS OF HIBERNATE
            • 14
              Easy ORM
            • 7
              Easy transaction definition
            • 1
              Is integrated with spring jpa
            CONS OF HIBERNATE
            • 3
              Can't control proxy associations when entity graph used

            related Hibernate posts

            Slick logo

            Slick

            8.5K
            555
            0
            Database query and access library for Scala
            8.5K
            555
            + 1
            0
            PROS OF SLICK
              Be the first to leave a pro
              CONS OF SLICK
                Be the first to leave a con

                related Slick posts

                Spring Data logo

                Spring Data

                348
                282
                0
                Provides a consistent approach to data access – relational, non-relational, map-reduce, and beyond
                348
                282
                + 1
                0
                PROS OF SPRING DATA
                  Be the first to leave a pro
                  CONS OF SPRING DATA
                    Be the first to leave a con

                    related Spring Data posts

                    Остап Комплікевич

                    I need some advice to choose an engine for generation web pages from the Spring Boot app. Which technology is the best solution today? 1) JSP + JSTL 2) Apache FreeMarker 3) Thymeleaf Or you can suggest even other perspective tools. I am using Spring Boot, Spring Web, Spring Data, Spring Security, PostgreSQL, Apache Tomcat in my project. I have already tried to generate pages using jsp, jstl, and it went well. However, I had huge problems via carrying already created static pages, to jsp format, because of syntax. Thanks.

                    See more