Migrate to a NoSQL database?

[josecelano]

The torrent file is a very flexible data structure. Depending on what BEPs the torrent supports you can have only a subset of the fields.

On the other hand, we are not storing all the fields in the original torrent file in the database. See #272

I have the impression that a NoSQL database would fit better in this project. We could convert the torrent file into a JSON and store the whole json as a document. I have not used NoSQL databases and I don't know the pros and cons, but I think we should have these:

Pros

• We could store the whole original torrent file without losing data.
• We could simplify querying the database to get a single torrent data. One simple query with no inner joins.
• We would only need to convert from JSON to Rust struct and vice-versa. Relates to: Serialization from Bencode to JSON torrust-tracker#673

What do you think @torrust/torrustaceans?