angerlache / EchoExplorer

Other
0 stars 0 forks source link

Use a document database for annotations #6

Open mpiraux opened 8 months ago

mpiraux commented 8 months ago

Currently, user management is done based on a relational database. However data collected through audio annotations is not part of this database and to my understanding is stored in files. This is fine as long as each file will be accessed separately, but it'll soon be challenging when operations has to be performed across these files. For instance, querying all the audio files which contains a given species annotation. For this, a document database could be used, such as MongoDB.

I'm enquiring the INGInious team for a recommendation on such a document database

mpiraux commented 8 months ago

They do recommend MongoDB https://www.mongodb.com/docs/manual/administration/install-community/#std-label-install-mdb-community-edition https://www.mongodb.com/docs/manual/tutorial/query-documents/#query-documents

mpiraux commented 8 months ago

https://www.mongodb.com/nosql-explained/nosql-vs-sql