ciatph ciatph

System Design Cheatsheet

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

Basic Steps

Clarify and agree on the scope of the system

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?

Standard Git Commit Message Reference

Below is a list of industry-standard Git commit messages featured by Tuasegun on his [blog post] for reference.

Your commit message should be:

Understandable

Enough

Unambiguous

Before coming up with a commit message you should consider:

Branch Naming Conventions

(from @Phil Nord

Some Useful Guidelines

Use grouping tokens (words) at the beginning of your branch names.
Define and use short lead tokens to differentiate branches in a way that is meaningful to your workflow.
Use slashes to separate parts of your branch names. 4.5Do not use bare numbers as leading parts.
Avoid long descriptive names for long-lived branches.

Import a CSV File to Database

# Create a database
sqlite3 mydb.db

# Specify the CSV mode and define a table
.mode csv mytable

# Import a CSV file to mytable
.import somedata.csv mytable

	::---------------------------------------------------------------------
	:: A windows executable batch file that exports (checkout-index) the
	:: current HEAD of a git repository to a specified directory.
	:: - Uses relative directory access in case full path is not supplied.
	:: - Exports contents to an "/export" directory inside the repository if no
	:: argument is supplied
	:: - Creates the entered directory if it does not yet exist
	:: Dependencies: GitBash
	:: madbarua;20180920
	::---------------------------------------------------------------------

	# extracted from http//www.naturalearthdata.com/download/110m/cultural/ne_110m_admin_0_countries.zip
	# under public domain terms

	country_bounding_boxes = {
	'AF': ('Afghanistan', (60.5284298033, 29.318572496, 75.1580277851, 38.4862816432)),
	'AO': ('Angola', (11.6400960629, -17.9306364885, 24.0799052263, -4.43802336998)),
	'AL': ('Albania', (19.3044861183, 39.624997667, 21.0200403175, 42.6882473822)),
	'AE': ('United Arab Emirates', (51.5795186705, 22.4969475367, 56.3968473651, 26.055464179)),
	'AR': ('Argentina', (-73.4154357571, -55.25, -53.628348965, -21.8323104794)),
	'AM': ('Armenia', (43.5827458026, 38.7412014837, 46.5057198423, 41.2481285671)),

	# auto detects a good number of processes to run
	worker_processes auto;

	#Provides the configuration file context in which the directives that affect connection processing are specified.
	events {
	# Sets the maximum number of simultaneous connections that can be opened by a worker process.
	worker_connections 8000;
	# Tells the worker to accept multiple connections at a time
	multi_accept on;
	}

	// Create ssl certificates for localhost use only using openssl
	openssl req -node -new -x509 -keyout server.key -out server.cert

	const response = await axios.get(url, { responseType: 'arraybuffer' })
	const buffer = Buffer.from(response.data, 'utf-8')