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 #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.
Background:
Deliverables:
Thanks!