This was a short introduction on using python with databases that I
delivered to a group of visiting researchers.
Slides: python-databases.pdf
Code: github.com
Outline
- Python modules for working with databases
- SQLite
- pyodbc
- Client software
- Create and connect to a database
- Create a table
- Inserting a row
- Inserting multiple rows
- Retrieving data
- Updating data
- Example using pyodbc
Advertisement
