I'm working on a project to store large JSON files (~1 MB each) in a database, with 10 of these files linked to one user profile.
Normally I would use MySQL, and have two tables, one with the meta user information, and another storing the large JSON files for each user.
However, MySQL has a max cell size of 66KB, so for that reason alone I can't store my files in the MySQL cells. Also, even if my files were small enough, it would seem that my files wouldn't be appropriate for the typical tabular format anyways.
Since MySQL is out of the question, it seems like it makes the most sense to go to a non-sql database like MongoDB.
Is storing large files (JSON or txt) the typical use case for MongoDB (or any other no-sql database)? Is my thought process correct here?