Steps for getting a database-backed web application up and running
This is an overview of the list of tasks we’ll need to do for a given web app to run with a database.
Create a database
Using createdb in Postgres
Establish a connection to the database
We can connect to a Postgres server from a Python web server using pyscopg2 with psycopg2.connect()
Define and create your data schema
Execute CREATE TABLE commands to create the tables and define the schema (attributes, data types, etc) that will define what data gets housed for our web app.
Seed the database with initial data
(Optional) Give the database some initial data, e.g. test data for doing local development.
Create routes and views
Then finally, to get our web app running
Run the server
Get the web server running.
Deploy the server to the web
… and that is, generally, how we would build a web application backed by a database.