Consider MongoDB variant

[mikeckennedy]

Swap out SQLAlchemy for MongoDB (in a separate branch or separate repo altogether).

Who's interested in this?

[datatalking]

What advantages would MongoDB offer in this situation, from what I understand, I think Mongo decreases the cache or loading times by moving the needed files out of SQL and into a cache?

Am I close?

[mikeckennedy]

Hi,

There are lots of trade offs and considerations when thinking MongoDB (document db in general) vs. relational. But to me it comes down to two things.

1. The MongoDB versions tend to be way faster. For example, https://training.talkpython.fm/ gets 10's of millisecond response times with zero caching and what would require lots of joins in RDBMS.
2. Simplicity. I almost NEVER need to do a migration to keep my db up-to-date with my models. MongoDB just adjusts. If I used SQLAlchemy, I would be constantly juggling DB schemas as I release new versions with a tiny bit of "planned down time".

But my goal with this issue here is to simply make the template have an option (want MongoDB or SQLAlchemy?) so people can pick easily. :)