Kenneth Reitz made a presentation about this: https://speakerdeck.com/kennethreitz/flasky-goodness
I can see using Django to rapidly prototype some kind of CRUD app, but on the other hand, you could just use Wordpress for that. Flask seems like it would be a superior platform for engineering anything non-trivial, especially if you care about how it works.
I feel like I'm replying a lot in this thread!
I think it's the other way around. If you want to QUICKLY prototype something, use Flask: it's light weight, and your app will _literally_ be one hundred-line file + some templates.
If you know you're going to use much of the common Django tools, use Django. Django projects are usually harder to spin up in my experience.
I wouldn't relate Django to Wordpress at all. It'd be tough to get a Wordpress type platform from scratch in Django OR Flask.
- If you want to do simple apps that do not touch the DB, or any kind of persistence, you can start with Flask. Much simpler to start.
- For a more integrated experience on web development, including DBs, use Django. Their tutorial is very very good: https://docs.djangoproject.com/en/1.10/intro/tutorial01/
I teach these subjects in a local university to BSc and MSc students, and since I want them to learn fast and lots of functionalities regarding web dev, I go directly to Django (after teaching them basic http with python and sockets - like this: http://joaoventura.net/blog/2017/python-webserver/).
But you can't use pure SQLAlchemy models (easily), since this otherwise great extension for flask doesn't support it (https://github.com/mitsuhiko/flask-sqlalchemy/pull/250, yes I'm in the thread).
You'll fork it or brew your own code to get declarative models working right. Kinda time consuming, but at least your models can be pulled in by any python code, and aren't tied down to a framework (That's what you were avoiding from the first place, wasn't it?)
Then you'll pick up WTForms (https://wtforms.readthedocs.io/en/latest/), another excellent library. And you'll miss having Django ORM's rich form and model-backed validation. So you'll try wtforms-alchemy, https://github.com/kvesteri/wtforms-alchemy.
Then you'll begin to see why Django makes sense after using Flask for a while. Django pulls in all the essential stuff and supports it well.
And top of that, django's addons like django-extensions (https://django-extensions.readthedocs.io), which gives you Werkzeug's debugger if you use ./manage.py runserver_plus. And ./manage.py shell_plus, which integrates with ptpython/ipython/bpython (https://django-extensions.readthedocs.io/en/latest/shell_plu...).
Django rest framework, DRF for short (http://www.django-rest-framework.org/), which is very mature at this stage, runs circles around Flask API. Flask API is inspired by DRF. You could also try https://flask-restful.readthedocs.io, but after all that, you'll be missing that tight model support.
You'll love flask. The code is top tier and exemplary. The testsuites are a dream and are very clear. Documentation is awesome. It feels good to code in it. But django feels good to code in as well.
Django's ORM is very mature. It's easier than SQLAlchemy, and despite SQLAlchemy's purity, and documentation - even better than flask's - Django's ORM does the trick for pretty much anything, even foreign databases I've interacted with. Another thing, QuerySet's are a charm, a lot of django's addons like django-filters, django-rest-framework and django-tables2 are built on top of its versatility.
Another thing Flask community ends up having to clone from Django is django-debug-toolbar https://github.com/django-debug-toolbar/django-debug-toolbar. See https://flask-debugtoolbar.readthedocs.io.
Again, I love flask, but when I realized that I'm just going to end up reinventing django with my flask app anyway, I started going with django on new projects. I haven't turned back, but still check out flask and sqlalchemy to see what's happening now and then.
Use an ORM because tools like this: https://marshmallow.readthedocs.io/en/latest/ work really well with it.
And tools for migrations: https://sqlalchemy-migrate.readthedocs.io/en/latest/ start to make sense in your code.
You don't need an ORM to do either of those things, but it makes things a hell of a lot more organized. Makes the database easy to understand from your code. Makes things like "testing from a blank database" really nice.
You don't ever _need_ an ORM, but for 90% of projects you'll use Flask and a Database for, it makes your life a lot nicer.
No, it's a matter of philosophy. The newbie who has learned to code without ever being taught SQL, and the employee of an "agile" app sweatshop who doesn't care about the quality of his code or data, may prefer ORM for its' quick-and-dirtiness, or may use it by default because he knows no better way. I'm not saying that's wrong, but, there are other philosophies. There is the whole "craftsmanship" idea out there, that we should actually care about making things well. Jobs and Wozniak for example supposedly were adamant that the insides of Apple computers were designed well. If you care about your database and want to use special features like triggers, procedures, recursive queries in Postgres, etc., then ORM is about as helpful as clamshell packaging.
> And what happens when those tools fail?
I haven't used any of these tools that don't let me fall back on raw SQL or writing my own migration in SQL and including it in my code (outside of the DB). So, I haven't had this problem, honestly! Most DB problems I've had are related to _design_. There is an argument there to be had: "Do ORMs encourage bad database design?" but it's a different topic, in my opinion.
> There is the whole "craftsmanship" idea out there, that we should actually care about making things well.
Making a website is a completely different process than making a chair, or remodeling a kitchen, or designing hardware for a computer.
I absolutely make technology that is great, and I do take pride in my work, but if I didn't use an ORM it'd take me much longer to make: and the application would be much less maintainable.
> If you care about your database and want to use special features like triggers, procedures, recursive queries in Postgres, etc., then ORM is about as helpful as clamshell packaging.
I use all these things all the time. I've created migrations in Django to create my Postgres FTS trigger function. Now all these raw-SQL migrations are stored very nicely in their own space, and in version control. And it's just like I typed them into the SQL prompt: but I can just look in my codebase and see what I did :)
You can'd even do sub-selects nicely in Django ORM, forget recursive queries. But you can use raw SQL when you need it!
In fact I'm coming short on a value equation where it'd be more secure / efficient / readable without at least a query builder.
> but ORM means giving up a lot of control
What control is being lost, specifically?
> (and transparency, and understanding)
Highly recommend Django in Depth by James Bennett at PyCon 2015. https://www.youtube.com/watch?v=tkwZ1jG3XgA
Also, try out printing the .query of the QuerySet:
print(MyUser.objects.all().query)
SELECT "core_myuser"."id", "core_myuser"."password", "core_myuser"."last_login", "core_myuser"."is_superuser", "core_myuser"."username", "core_myuser"."email", "core_myuser"."is_active", "core_myuser"."is_admin" FROM "core_myuser"
And Q(), https://docs.djangoproject.com/en/1.11/topics/db/queries/#co..., .extra(), https://docs.djangoproject.com/en/1.11/ref/models/querysets/..., and finally raw SQL queries https://docs.djangoproject.com/en/1.11/topics/db/sql/.
> of your database in exchange for a few shortcuts regarding things like M:M links.
Maybe a few other benefits: helps with readability, consistent with OOP in python. Works across SQL dialects. Prevents mistakes, since those relationships are common. Getting clear and consistent access to common data retrieval and updating.
> Django rest framework, DRF for short (http://www.django-rest-framework.org/), which is very mature at this stage, runs circles around Flask API. Flask API is inspired by DRF.
I use both and enjoy both, but Flask API is _much_ better designed than DRF. Go look over the source for both.
So yeah, Flask is much smaller than Django: but that's a good thing _for some projects_ like you've said. If you want Django manage.py, Django's ORM, DRF, and debug toolbar, then use Django!
My last project I did in Go and felt like too much "stupid" typing, even though I understand the reasons things are that way, and I love the tooling around it, it feels kinda verbose for websites..
-- edit --
One of my doubts with Django is that I'm not sure my SQL will translate well into a "model".
Suggestions?
Start with a basic todo list. Then add support for permissions. Then add support for versioned entries. Then add a REST layer on top.
I'm now looking at SQL alchemy and thinking I might try to taking another look at Django...
If you are in need of a beginner-friendly tutorial, I would recommend the Djangogirls tutorial.