Samuel Nzayisenga samnzay

System Design Cheatsheet

Picking the right architecture = Picking the right battles + Managing trade-offs

User cases (description of sequences of events that, taken together, lead to a system doing something useful)
- Who is going to use it?
- How are they going to use it?

Help with SQL commands to interact with a MySQL database

This will get you setup with Laravel & Valet on your Mac. Quentin Watt has a good video tutorial on getting setup here as well

Go to https://brew.sh/ and copy the command and run in your terminal

It will be something like this...

/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"

	$ modprobe bridge
	$ echo "net.bridge.bridge-nf-call-iptables = 1" >> /etc/sysctl.conf
	$ sysctl -p /etc/sysctl.conf

	sysctl: cannot stat /proc/sys/net/bridge/bridge-nf-call-iptables: No such file or directory sysctl: cannot stat /proc/sys/net/bridge/bridge-nf-call-ip6tables: No such file or directory

	# SOLUTION
	$ modprobe br_netfilter
	$ sysctl -p /etc/sysctl.conf

	<?php
	$host = 'localhost';
	$user = 'root';
	$password = '123456';
	$dbname = 'pdoposts';

	// Set DSN
	$dsn = 'mysql:host='. $host .';dbname='. $dbname;

	// Create a PDO instance