As weeks have passed by, there is a growing problem at the lab: the CSV files are everywhere! Conflicting copies, missing files, records getting changed by non-data entry staff, and other CSV-related frustrations are plaguing the project. It's clear that individual CSV files are not working out as a way to store data for the experiments. Something better is needed.
The facility has an older Linux server with a PostgreSQL database installed. You've been asked to update your program so that it stores data in the PostgreSQL database rather than in the CSV files. This promises to be a major update to your application!
In this chapter, you'll learn the following topics:
- Installing and configuring the PostgreSQL database system
- Structuring data in a database for good performance and reliability
- The basics of SQL queries
- Using the psycopg2...
