DBFlow vs Dapper

Overview

Dapper

Stacks574

Followers85

Votes6

DBFlow

Stacks16

Followers14

Votes3

GitHub Stars4.9K

Forks597

Dapper vs DBFlow: What are the differences?

Dapper: A simple object mapper for .Net. It is an object-relational mapping product for the Microsoft.NET platform: it provides a framework for mapping an object-oriented domain model to a traditional relational database; DBFlow: *Simple ORM android database library *. 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.

Dapper and DBFlow can be categorized as "Object Relational Mapper (ORM)" tools.

Some of the features offered by Dapper are:

Parameterized queries
List Support
Literal replacements

On the other hand, DBFlow provides the following key features:

Feature-rich
Kotlin database library
Built on SQLite

DBFlow is an open source tool with 4.78K GitHub stars and 609 GitHub forks. Here's a link to DBFlow's open source repository on GitHub.

Share your Stack

Help developers discover the tools you use. Get visibility for your team's tech choices and contribute to the community's knowledge.

View Docs

CLI (Node.js)

Manual

Detailed Comparison

Dapper	DBFlow
It is an object-relational mapping product for the Microsoft.NET platform: it provides a framework for mapping an object-oriented domain model to a traditional relational database.	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.
Parameterized queries; List Support; Literal replacements; Multi Mapping	Feature-rich; Kotlin database library; Built on SQLite
Statistics
GitHub Stars -	GitHub Stars 4.9K
GitHub Forks -	GitHub Forks 597
Stacks 574	Stacks 16
Followers 85	Followers 14
Votes 6	Votes 3
Pros & Cons
Pros 6 Fastest ORM	Pros 1 Open Source 1 Easy to use 1 SQLite Cons 1 Doesn't support anything other than SQLite
Integrations
MySQL SQLite Microsoft SQL Server .NET Oracle PostgreSQL Firebird	Kotlin Android OS SQLite RxJava

What are some alternatives to Dapper, DBFlow?

Sequelize

Sequelize is a promise-based ORM for Node.js and io.js. It supports the dialects PostgreSQL, MySQL, MariaDB, SQLite and MSSQL and features solid transaction support, relations, read replication and more.

Prisma

Prisma is an open-source database toolkit. It replaces traditional ORMs and makes database access easy with an auto-generated query builder for TypeScript & Node.js.

Hibernate

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

Doctrine 2

Doctrine 2 sits on top of a powerful database abstraction layer (DBAL). One of its key features is the option to write database queries in a proprietary object oriented SQL dialect called Doctrine Query Language (DQL), inspired by Hibernates HQL.

MikroORM

TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases.

Entity Framework

It is an object-relational mapper that enables .NET developers to work with relational data using domain-specific objects. It eliminates the need for most of the data-access code that developers usually need to write.

peewee

A small, expressive orm, written in python (2.6+, 3.2+), with built-in support for sqlite, mysql and postgresql and special extensions like hstore.

MyBatis

It is a first class persistence framework with support for custom SQL, stored procedures and advanced mappings. It eliminates almost all of the JDBC code and manual setting of parameters and retrieval of results. It can use simple XML or Annotations for configuration and map primitives, Map interfaces and Java POJOs (Plain Old Java Objects) to database records.

Entity Framework Core

It is a lightweight, extensible, open source and cross-platform version of the popular Entity Framework data access technology. It can serve as an object-relational mapper (O/RM), enabling .NET developers to work with a database using .NET objects, and eliminating the need for most of the data-access code they usually need to write.