What are the best Python web frameworks for creating a CRUD application?

Question

8

Options
Considered

105

User
Recs.

May 23, 2023

Last
Updated

Here’s the Deal

8 Options Considered

Best Python web frameworks for creating a CRUD application	Price	Written in	Default ORM
-- Django	-	Python	Django ORM
-- FastAPI	0	Python	SqlAlchemy
-- Flask	-	Python	-
-- jam.py	-	-	-
-- web2py	-	-	-

See Full List

I Recommend...

Built By the Slant team

Find the best product instantly.

4.7 star rating

Try it now - it's free

score 30 · Answer 1

Django

Top Pro

Django can feel bloated for small projects

Django's sheer scale and functionality can feel clunky and bloated for small applications. It has too many bells and whistles which can get in the way when developing a small scale application. See More

PrincipledMagec's Experience

Slow, not async See More

Specs

Written in:Python

Default ORM:Django ORM

Multi Language Support:Excellent

Default Template Engine:Django

See All Specs

Top Pro

Simple database management

Just a few lines of code can instruct Django to create all the tables and fields required in your database automatically. Schemas are managed with "migrations", that are also created automatically, and can be rolled out from your development box and implemented on production systems with just a single command. This performs any database changes required, from table creation, indexes, renaming fields, and pre-populating initial data. Each migration builds on the previous migrations, so you can trace the evolution of your data and even recreate the layout of your database at any point in the lifecycle of your application. See More

Top Con

Django teaches only Django

For beginners Django is a bad idea, following books and tutorials newbies will learn only Django and its specific APis instead of learn how the things really works in a web environment. Example: You can follow a tutorial about Django Forms and you learn how Django Forms API works, but you don't learn how web forms works and you will get lost when need to work in another environment or solve difficult problems. See More

Top Pro

Admin area out of the box

Django comes with a highly customizable admin panel and authentication out of the box. This makes the development and production of a simple CMS extremely easy. See More

Top Con

Routing requires some knowledge of regular expressions

Given a GET request for /topics/426/viewpoints/1/sections/create, how does Django decide which bit of Python code is invoked to handle it? It compares the request path to your giant pile of regular expressions. And then if there's some other regular expression starts matching /top and all your requests for /topics/ start going there, good luck figuring out why. You won't be informed of any conflict until you notice you seem to be getting the wrong pages back. The structure of URL paths is almost universally hierarchal. There is no call to have anything as ridiculously flexible (and notoriously hard-to-read) as regular expressions to organize request routing. See More

Top Pro

Clear and defined MVC organization

Django follows some pretty well established MVC patterns. With everything in place and where requests follow a clear path through urlresolvers, middleware, view and context processors. See More

Top Con

Can feel bloated for small projects

Django's sheer scale and functionality can feel clunky and bloated for small applications. It has too many bells and whistles which can get in the way when developing a small scale application. See More

Top Pro

Developing a simple prototype can be very fast

Django's philosophy of batteries included means that experienced developers won't have to plan too much ahead on what kind of application infrastructure they need and instead just start developing web applications quickly. See More

Top Con

A process only handles a single request at a time

A Django process is set up so it's handed a single request, generates a response in its entirety, and returns it before taking on the next request. While this is fine for many document-based sites, it does limit the scope of what you might want to do with a more ambitious web application. It doesn't take too long to run in to the limitations. Want to return a response to the browser and then send off a batch of e-mail notifications? Nope, you can't do things after the response, the user's going to have to wait for that email traffic to complete before they get their HTTP response. Want to hold open a connection to the browser to send an event stream, like chat messages or world updates from a multiplayer game? Considering our Django processes take ~80 MB RAM, you can't really afford to dedicate an entire process to every user. No websockets for you. Your process is waiting on something else, like a complicated database query or a third-party API? Okay, that's fine, but it's just going to idle there, those resources (i.e. all the program code and state that's already been loaded into memory) can't be used to serve other requests in the meantime. This means for even very modest levels of traffic you need multiple django processes running and a layer in front directing requests between them. The common answer to "how do I do things outside the request cycle" is "use Celery", but that introduces a whole mess of infrastructure (you need an external message queue server) and interprocess communication complexity. There are some benefits to distributing load that way, but it makes things that might otherwise have been handled in-process much more complicated. (This argument is common to all synchronous (blocking) frameworks. WSGI is a blocking interface.) See More

Top Pro

ORM support

Django supports Object-Relational Mapping. With models defined as Python classes which are actually subclasses of Django's django.db.models.Model. Each attribute of the model is then represented as a database field. Queries are lazily executed and Django gives developers an automatically-generated database-access API. See More

Top Con

Request routing uses regular expressions

Given a GET request for /topics/426/viewpoints/1/sections/create, how does Django decide which bit of Python code is invoked to handle it? It compares the request path to your giant pile of regular expressions. And then if there's some other regular expression starts matching /top and all your requests for /topics/ start going there, good luck figuring out why. You won't be informed of any conflict until you notice you seem to be getting the wrong pages back. The structure of URL paths is almost universally hierarchal. There is no call to have anything as ridiculously flexible (and notoriously hard-to-read) as regular expressions to organize request routing. See More

Top Pro

Mature software with many plugins developed over the years

Django was first released in 2005, it has had a lot of time to mature and become better with each release. It also has by far the largest community out of all python frameworks who have continuously over the years built and maintained many powerful plugins. See More

Top Con

Template errors fail silently by default

If you make a typo in a template variable, or change a view so that variable is no longer passed to the template, you won't get an error message pointing out that something has gone wrong. That reference will just be treated as if it is an empty string instead. There is a way to configure this, but since so many templates have been written assuming this behavior, nobody ever enables template errors because it would break so much of the existing support tools (e.g. the built-in admin interface). See More

Top Pro

Highly customizable

Django is in itself a highly customizable web framework. The database, template framework and ORM can all be swapped out. See More

See All

score 20 · Answer 2

FastAPI

Top Pro

Data validation

It validates the data using the types you declared. Even in deeply nested JSON requests. See More

Specs

Written in:Python

Platforms:Cross-platform

License:MIT

Default ORM:SqlAlchemy

See All Specs

Top Pro

High-performance

It's based on Starlette and Pydantic, so, it's one of the fastest Python frameworks. See More

Top Pro

World class documentation

It has some of the best documentation of any framework. See More

Top Pro

Async IO / optional

It's based on Async IO, which gives it high concurrency. But you can use non-async libraries and it runs them appropriately. See More

Top Pro

Editor completion

It is based on Python type declarations, so, editors and tools can give great support. Including type checks and autocompletion everywhere. See More

Top Pro

Background tasks

Included support for background tasks, thanks to being based on Starlette. See More

Top Pro

Dependency Injection

It has a simple but powerful dependency injection system, it can be used to handle authentication, per-user rate limiting, authorization controls (e.g. with roles), etc. See More

Top Pro

WebSockets

Because it's an async framework, it can handle async-native protocols like WebSockets. See More

Top Pro

Automatic docs

It generates interactive API documentation automatically from your code. See More

Top Pro

graphql out of the box

Top Pro

Database independent

It's independent of database or ORM, but compatible with all of them. Including relational databases and NoSQL. See More

Top Pro

OAuth 2.0

It has integrated support for OAuth 2.0. Including declaring required scopes per endpoint. So, you can easily integrate it with external OAuth 2.0 providers or build your own with it. See More

Top Pro

Standards

It is based on standards: OpenAPI, JSON Schema and OAuth 2.0. See More

Top Pro

Dependency injection

It has a simple but powerful dependency injection system, it can be used to handle authentication, per-user rate limiting, authorization controls (e.g. with roles), etc. See More

Top Pro

One of the fastest growing communities

See All

score 8 · Answer 3

Flask

Top Pro

Minimalist without losing power

Flask is very easy to get up and going, with vanilla HTML or with bootstrap pieces. It doesn't take much lines of python to load Flask to get headers working, etc, and since it's all modular you don't have to have something you don't want in your application. Each module within Flask works very well, and is extremely good on bandwidth and CPU usage. See More

Top Con

Not async-friendly

Flask is explicitly not designed to handle async programming. See More

Specs

Written in:Python

License:BSD License

Top Pro

Very flexible

The choice of not having an ORM, but instead choosing one suited to the task, gives developers who use Flask a great deal of flexibility. Another area where Flask gives a lot of options to developers is the templating. They can use Jinja2, Flask's default templating language or choose from a number of different templating languages they desire. See More

Top Pro

Lots of resources available online

Flask is one of the most popular Python web frameworks, if not the most popular one. As such, there's plenty of guides, tutorials, and libraries available for it. A large number of important Python libraries, such as SQLAlchemy have libraries for Flask, which add valuable bindings to make the development process and the integration between these libraries and Flask as easy as possible. See More

Top Pro

Extremely easy to build a quick prototype

Even though it's pretty minimalistic out of the box, Flask still provides the necessary tools to build a quick prototype for a web app right after a fresh install. With all the main components pretty much packed in the flask package, building a simple web app in a single Python file is as easy as it gets. See More

Top Pro

Simple to use

With only a few lines of code, you can have a very simple site up and running. See More

Top Pro

Great documentation

The official documentation is very thorough and complete. Everything is explained in-depth and followed by extremely well-explained tutorials that tackle real-world problems. See More

See All

score 18 · Answer 4

jam.py

Top Pro

Clean and simple Application Builder, easy to learn and get results fast

No need to learn huge 'Djangoish' frameworks. Easy to deploy with Apache, small deployment footprint. Security built in the App. See More

Top Con

Still need to learn Python etc to get the full potential of Jam.py

General Python, JS, etc. knowledge is still needed to fully take advantage of Jam.py. See More

Ljudevit Perčić's Experience

I am not a developer, hence no JS, bootstrap, jquery at.al experience. But my productivity skyrocketed with Jam.py. It is the framework to get the job done. See More

Top Pro

Great for non-developers looking to visualize data

You can get productive with jam.py really quick even if you have little to no development experience. A dashboard can be built pretty quickly with minimal effort. See More

EagerSengann's Experience

Very good for crud production See More

B Real's Experience

Incredibly quick to set up a fully functional yet customisable CRUD web app. Great for prototyping. I'm a non developer learning python-no real JS, HTML or CSS knowledge-and managed to figure out what I needed to get jam.py working. I hope this continues to get supported in the future! See More

See All

score 3 · Answer 5

web2py

Top Pro

User support

The web2py community is open and friendly and it gives concrete support to newbies and old timers. It's not difficult to get answers from the BDFL Massimo Di Pierro himself. See More

StrongLouhi's Experience

Runs right out of the box, even from a thumb drive. Easy to program and has built in fast server. See More

Top Pro

Web2py apps run on GAE, AWS, VPNs, PythonAnywhere, etc

Web2py apps are designed to be portable. With some minor restrictions web2py apps can run on any VPS on SQL databases and/or Mongo, as well as on Google App Engine with the Google Datastore. It is truly code ones and run everywhere. For example at Camio.com we use web2py internally to access a GAE datastore which contains more images than Instagram. See More

Top Pro

Easy to learn without losing any power

web2py is very easy to learn for beginners, yet it has a great deal of power and flexibility as application needs become more complex. It includes an impressively comprehensive set of features, making development very productive without the need to integrate a lot of third-party libraries. See More

Top Pro

Documentation is written in form of a book which is good for beginners

web2py documentation does not follow the common pattern of using Sphinx, MkDocs or ReadTheDocs which is goos for exeperienced developers. Although documentation in form of a book is very easy and good for beginners. Turning web2py the most easy and comprehensive framework to learn and also to teach. See More

See All

score 10 · Answer 6

Masonite

score 3 · Answer 7

Falcon

Top Pro

Built to build REST APIs

Falcon is designed entirely around building REST APIs. It achieves this helps a lot with it being lightweight and simple. It also helps developers take some design choices which would otherwise not be possible with a more general-purpose framework, See More

Specs

Platforms:Windows, Linux, Mac

Technology:Javascript

score 4 · Answer 8

Websauna

Top Pro

Just the right amount of “batteries included”

Django is too “batteries included” while Pyramid alone is fast but too bare-bones for. See More

CleverNinkilim's Experience

I have this running in production for nearly a year so far. Based on Pyramid and has integration with Celery, Redis, PostgreSQL out of the box. Project also comes with an ansible deployment script. It is rock solid. See More

Top Pro

Adding Admin forms for Model Very Simple

You just subclass the built-in AdminModel. See More

See All

8 Options Considered

My Recommendation for Django

My Recommendation for Django

Top notch documentation and help from community

Django can feel bloated for small projects

Simple database management

Django teaches only Django

Admin area out of the box

Routing requires some knowledge of regular expressions

Clear and defined MVC organization

Can feel bloated for small projects

Developing a simple prototype can be very fast

A process only handles a single request at a time

ORM support

Request routing uses regular expressions

Mature software with many plugins developed over the years

Template errors fail silently by default

Highly customizable

My Recommendation for FastAPI

My Recommendation for FastAPI

Data validation

High-performance

World class documentation

Async IO / optional

Editor completion

Background tasks

Dependency Injection

WebSockets

Automatic docs

graphql out of the box

Database independent

OAuth 2.0

Standards

Dependency injection

One of the fastest growing communities

My Recommendation for Flask

My Recommendation for Flask

Minimalist without losing power

Not async-friendly

Very flexible

Lots of resources available online

Extremely easy to build a quick prototype

Simple to use

Great documentation

My Recommendation for jam.py

My Recommendation for jam.py

Clean and simple Application Builder, easy to learn and get results fast

Still need to learn Python etc to get the full potential of Jam.py

Great for non-developers looking to visualize data

My Recommendation for web2py

My Recommendation for web2py

User support

Web2py apps run on GAE, AWS, VPNs, PythonAnywhere, etc

Easy to learn without losing any power

Documentation is written in form of a book which is good for beginners

My Recommendation for Masonite

My Recommendation for Masonite

My Recommendation for Falcon

My Recommendation for Falcon

Built to build REST APIs

My Recommendation for Websauna

My Recommendation for Websauna

Just the right amount of “batteries included”

Adding Admin forms for Model Very Simple

Don't see your favorite option? Add it.

One sec!