Reading the documentation it is not clear to me which data bases DataSHIELD requires: Is a SQL and a document database (MongoDB) necessary? Or is a SQL database sufficient?
Regards
Felix
1 Like
Hi,
Regarding Opal, it is up to you to decide which database to use. Opal supports MongoDB, PostgreSQL, MariaDB/MySQL. You can even register several databases of different types and then decide which one to use per project.
MongoDB is the one to use when some tables have a lot of variables (~1000 columns is a common SQL database limit).
Note also that if you work with “resources”, you do not need a database at all,
Regards
Yannick
2 Likes