peewee vs Sugar ORM Comparison | StackShare | StackShare

Sugar ORM vs peewee

Overview

peewee

Stacks50

Followers105

Votes19

GitHub Stars11.8K

Forks1.4K

Sugar ORM

Stacks3

Followers11

Votes0

GitHub Stars2.6K

Forks577

peewee vs Sugar ORM: What are the differences?

peewee: A small, expressive ORM -- supports postgresql, mysql and sqlite. 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; Sugar ORM: A database persistence library that provides a simple and concise way to integrate your application models into SQLite. It is a database persistence library that provides a simple and concise way to integrate your application models into SQLite. It eliminates writing SQL queries to interact with SQLite db.

peewee and Sugar ORM belong to "Object Relational Mapper (ORM)" category of the tech stack.

peewee and Sugar ORM are both open source tools. peewee with 6.8K GitHub stars and 1.12K forks on GitHub appears to be more popular than Sugar ORM with 2.61K GitHub stars and 614 GitHub forks.

Detailed Comparison

peewee	Sugar ORM
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.	It is a database persistence library that provides a simple and concise way to integrate your application models into SQLite. It eliminates writing SQL queries to interact with SQLite db.
-	A simple, concise, and clean integration process with minimal configuration; Automatic table and column naming through reflection; Support for migrations between different schema versions
Statistics
GitHub Stars 11.8K	GitHub Stars 2.6K
GitHub Forks 1.4K	GitHub Forks 577
Stacks 50	Stacks 3
Followers 105	Followers 11
Votes 19	Votes 0
Pros & Cons
Pros 7 Easy to start 4 Free 4 Open Source 4 High Performance	No community feedback yet
Integrations
PostgreSQL MySQL SQLite	SQLite Android OS

What are some alternatives to peewee, Sugar ORM?

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.

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.

SQLAlchemy

SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.

Dapper

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.