Topic 4
Building a database application
Starting points:
For python's pymysql:
https://pypi.org/project/PyMySQL/ https://www.tutorialspoint.com/python3/python_database_access.htm https://pymysql.readthedocs.io/en/latest/modules/index.html
For Java:
https://dev.mysql.com/doc/connector-j/8.0/en/connector-jexamples.html
For R:
https://cran.rproject.org/web/packages/RMariaDB/RMariaDB.pdf
https://programminghistorian.org/en/lessons/getting-started-with-mysql-using-r#selecting-data-from-a-table-with-sql-using-r
Novice Programmers
If you are new to programming, we recommend that you adopt Python as your host language. Follow along with the following tutorial. It provides the basics of Python as well as a steps for setting up s Python development environment.
Here is a another resource, to help you get started with Python. It is a collection of presentations introducing the basic python programming constructs.