This post will introduce the database application SQLite in relation to Python.
For large project, there are two main roles. One of those roles in the database administrator, who often consults with the developer (the other role). These are rather specialized jobs.
The administrator talks directly to the database, while the developer talks to indirectly, by way of the application. The following picture illustrates this split between roles, in large projects.
However, for smaller projects, one person can handle both roles.
By handling both these roles you will:
- Use the database application SQLite to create tables.
- Write Python programs to retrieve, clean, and put cleaned data in the tables.
- Write another program to pull the cleaned data out and output a nice file.
For now, you will focus on the first step. You will learn how to create a database model, or contract.
There are several common database systems. Oracle dominated this market, mainly because they were the first to embrace the relational model concept. However, there are good alternatives.
In the context of Python, you will use SQLite. As it turns out, SQLite is quite popular.
SQLite is fast, and is good for smaller amounts of data. Most importantly, the database application SQLite is embedded in Python.