Skip to content

Instantly share code, notes, and snippets.

@Blazing-Mike

Blazing-Mike/database-backed__web-app.md

Created May 19, 2022 19:41
Show Gist options
  • Save Blazing-Mike/175a7070fe788bdb6350366e3df97353 to your computer and use it in GitHub Desktop.
Save Blazing-Mike/175a7070fe788bdb6350366e3df97353 to your computer and use it in GitHub Desktop.
Download ZIP
Steps for getting a database-backed web application up and running
Raw
database-backed__web-app.md

  1. Create a database Using createdb in Postgres.

  2. Establish a connection to the database We can connect to a Postgres server from a Python web server using pyscopg2 with psycopg2.connect().

  3. 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.

  4. Seed the database with initial data (Optional) Give the database some initial data, e.g. test data for doing local development.

  5. Create routes and views Create routes in our server that will serve pages (views) to the client. Write up our HTML, CSS, and Javascript in our views.

Then finally, to get our web app running,

  1. Run the server Get the web server running.

  2. Deploy the server to the web. ... and that is, generally, how we would build a web application backed by a database.

notes from fullstack nanodegree

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment