Bootcamp
Search…
Bootcamp
Welcome to Bootcamp!
🛠
Logistics
📚
General Reference
🏞
Projects
0: Language and Tooling
1: Frontend Basics
🌈
CSS
2: Backend Basics
3: Backend Applications
3.0: Module 3 Overview
3.1: Express.js
3.2: EJS
3.3: SQL Language
3.4: SQL Applications
3.4.1: PostgreSQL, psql
3.4.2: PostgreSQL Node App
3.4.3: Nested SQL Queries
3.4.4: PostgreSQL Express App
3.4.5: Forms for One-to-Many Relationships
3.4.6: Forms for Many-to-Many Relationships
3.4.7: pg Promises
3.4.8: SQL Clients
3.4.9: Database Setup Files
3.4.10: Dates in SQL and JS
3.4.11: File Uploads
3.4.12: SQL Indexes
3.5: Authentication
3.6: Heroku
3.ICE: In-Class Exercises
3.POCE: Post-Class Exercises
4: Backend Structure
5: Full-Stack Applications
6: Frontend Infrastructure
7: React
8: Advanced React
9: Advanced Topics
🧮
Algorithms
💼
Interview Prep
☺
User Experience
Powered By GitBook
3.4: SQL Applications
The final form of the high-level architecture of our web application is a PostgreSQL database server that stores data, an Express.js web server, and user facing functionality in the browser.
When we deploy this application in its final form (on the service Heroku) the database will be accessed on a different computer. This is for modularity (multiple apps or servers may want to access this DB) and security (we can define different security rules on the DB server than our app server) reasons.
Previous
3.3.7: Self-Referencing Foreign Keys
Next
3.4.1: PostgreSQL, psql
Last modified 2mo ago
Copy link