lizTheDeveloper

## This is a windows powershell script! It needs to be run as admin.


# Install Script for PostgreSQL 16 and pgAdmin4 on Windows

Write-Host "Downloading PostgreSQL 16..."

# Download and install PostgreSQL
Invoke-WebRequest -Uri https://get.enterprisedb.com/postgresql/postgresql-16.0-1-windows-x64.exe -OutFile postgresql-16.0-1-windows-x64.exe
Write-Host "Finished Downloading."

lizTheDeveloper

#!/bin/bash
# Install Script for PostgreSQL 16 and pgAdmin4 on Mac

# Install PostgreSQL
echo "Installing PostgreSQL 16 and pgAdmin4..."
echo "Downloading PostgreSQL 16..."
curl -O https://get.enterprisedb.com/postgresql/postgresql-16.0-1-osx.dmg
echo "Installing PostgreSQL 16..."
hdiutil attach postgresql-16.0-1-osx.dmg
sudo installer -pkg /Volumes/PostgreSQL\ 16.0-1/PostgreSQL\ 16.0-1.pkg -target /

lizTheDeveloper

How to Think About Data Model and Schema in Postgres

Introduction

When working with databases like Postgres, understanding how to design your data model and schema is crucial. This lesson will guide you through the key considerations and questions to ask yourself.

Key Concepts

Tables

• What is it?: A table is a collection of related data held in a structured format.

lizTheDeveloper

What is a Kanban Board?

A Kanban board is a visual tool that helps you manage tasks, projects, and workflows. It consists of columns that represent different stages of a process and cards that represent tasks.

Why Use a Kanban Board?

• Visibility: See the status of all tasks at a glance.
• Efficiency: Move tasks through stages to focus on what's important.
• Collaboration: Team members can easily pick up tasks and know their responsibilities.

How to Create a Kanban Board

1. Identify Columns: Common columns are 'To Do', 'In Progress', and 'Done'.

lizTheDeveloper

title

cool body paragraph

• lists
• are
• cool
• too

lizTheDeveloper

adsfwdfadsfsdf

lizTheDeveloper

1. why does the sun shine
you answer here
3. why is the sky blue
youre answer ehre

lizTheDeveloper

Leverage agile frameworks to provide a robust synopsis for high level overviews 🎉. Iterative approaches to corporate strategy foster collaborative thinking to further the overall value proposition. Organically grow the holistic world view of disruptive innovation via workplace diversity and empowerment.

This Sprint:

• Header alignment 🦋
• New account signup broken? 🚨
• Verify emails bouncing 🚨
• Chatbot won't respond 🐛
• Links don't always display hover text 🐞
• Some links are missing in some user contexts 🐛

lizTheDeveloper

Deploying Files

Today's exercise will teach you how to actually deploy your work to a hosting provider, so that you can show it to the world!

There are two providers we'll use, you can pick.

• Surge
• Paperplane

If you're comfortable with the command line, pick Surge. Otherwise, you can host files with Dropbox and Paperplane.

lizTheDeveloper

Timers and Events

This set of exercises has you create programs that are actually interactive! You'll take in user input in the form of button clicks and mouse clicks, and you'll use forms and timers.

In jQuery, you can add a click event handler like so:

$("something").click(function(event) {})

In "vanilla" JavaScript, you can do it like this: