Storing JSON in Database

Hello,

We are doing a lot of API calls, API scrapes, etc, and get massive JSON files back in different complex formats. Parsing them is a lot of manual work. Today we:

1. Collect them

2. Store them on HD

3. Extract what we need and save into MYSQL

4. Later go back to JSON if we need more

Some of them are super complex and we don’t need it all (now). We debating now to just store them into a DB cause the file operations are slow.

What is the best way to do this?

Thank you