docker template for: running prototype database via Docker (MySQL/Postgresql)

[hannesdatta]

Background:

• More and more researchers require databases for their research (e.g., when web scraping)
• Sometimes, they wish to test whether their code works with a database without actually deploying/running a real database
• For this, we can use docker.
• This is a follow up on csv vs database first draft #1126, read up on the content developed there.

Deliverables:

• Post, explain databases typically run on servers.
• But, prototyping is important
• Offer as a solution a docker template that (a) runs a MySQL database AND -- importantly -- STORES the data locally (not just in the image but actually in real files somewhere on the disk so that data in the prototyping stage isn't lost, plus (b) runs a PostGreSQL database (plus storing data permanently).
• Walk through setting this up and show how to use these database to store information with R code and Python code that connects to these local databases
• Explain in a warning that

In addition we should tell them that they should use this for prototyping only and if things become more serious or require more resources they should look into a solution like the ones discussed below.

Thanks!