Hamed Naeemaei naeemaei

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?

	FROM golang:1.21.0-bullseye as builder

	COPY . /workdir
	WORKDIR /workdir

	ENV CGO_CPPFLAGS="-D_FORTIFY_SOURCE=2 -fstack-protector-all"
	ENV GOFLAGS="-buildmode=pie"

	RUN go build -ldflags "-s -w" -trimpath ./cmd/app

	version: '3'

	services:
	mssql-server-linux:
	image: microsoft/mssql-server-linux:latest
	volumes:
	- mssql-server-linux-data:/var/opt/mssql/data
	environment:
	- ACCEPT_EULA=Y
	- SA_PASSWORD=${SQLSERVER_SA_PASSWORD:-yourStrong(!)Password}

	#!/bin/bash

	name=$RANDOM
	url='http://localhost:9093/api/v1/alerts'

	echo "firing up alert $name"

	# change url o
	curl -XPOST $url -d "[{
	\"status\": \"firing\",

	#!/bin/bash

	# get all running docker container names
	containers=$(sudo docker ps \| awk '{if(NR>1) print $NF}')
	host=$(hostname)

	# loop through all containers
	for container in $containers
	do
	echo "Container: $container"

	declare @tableName varchar(200)
	declare @columnName varchar(200)
	declare @nullable varchar(50)
	declare @datatype varchar(50)
	declare @maxlen int

	declare @sType varchar(50)
	declare @sProperty varchar(200)

	DECLARE table_cursor CURSOR FOR