Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

peewee
peewee

20
15
+ 1
8
SQLAlchemy
SQLAlchemy

193
127
+ 1
0
Add tool

peewee vs SQLAlchemy: 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; SQLAlchemy: The Python SQL Toolkit and Object Relational Mapper. SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.

peewee and SQLAlchemy can be primarily classified as "Object Relational Mapper (ORM)" tools.

peewee and SQLAlchemy are both open source tools. It seems that peewee with 6.57K GitHub stars and 1.09K forks on GitHub has more adoption than SQLAlchemy with 3.33K GitHub stars and 893 GitHub forks.

What is 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.

What is SQLAlchemy?

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

Need advice about which tool to choose?Ask the StackShare community!

Why do developers choose peewee?
Why do developers choose SQLAlchemy?
    Be the first to leave a con
      Be the first to leave a con
      What companies use peewee?
      What companies use SQLAlchemy?

      Sign up to get full access to all the companiesMake informed product decisions

      What tools integrate with peewee?
      What tools integrate with SQLAlchemy?

      Sign up to get full access to all the tool integrationsMake informed product decisions

      What are some alternatives to peewee and SQLAlchemy?
      Hibernate
      Hibernate is a suite of open source projects around domain models. The flagship project is Hibernate ORM, the Object Relational Mapper.
      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.
      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.
      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.
      See all alternatives
      Decisions about peewee and SQLAlchemy
      No stack decisions found
      Interest over time
      Reviews of peewee and SQLAlchemy
      No reviews found
      How developers use peewee and SQLAlchemy
      Avatar of Dag Sneeggen
      Dag Sneeggen uses peeweepeewee

      model_to_dict is a function in the "playhouse" extension, which automagically converts a model into a Python dictionary. In other words; you can easily convert data from complex SQL queries straight to JSON.

      Avatar of Rene Luijk
      Rene Luijk uses SQLAlchemySQLAlchemy

      SQL Alchemy to connect front-end Flask webapp to database

      Avatar of Jacobsen og Svart
      Jacobsen og Svart uses peeweepeewee

      ORM SQL<->JSON

      How much does peewee cost?
      How much does SQLAlchemy cost?
      Pricing unavailable
      Pricing unavailable
      News about peewee
      More news
      News about SQLAlchemy
      More news