Discover gists

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?

Turn off your virtual machine
Go to Settings > SCSI Controller > Hard Drive. In the Media section, edit the Virtual Hard Disk and expand to desired space
Start the virtual machine and connect to it
Install the GParted by running the command sudo apt install gparted

People

See also:

Service	Type	Storage	Limitations
Amazon DynamoDB	⚠️ Proprietary NoSQL	25 GB	⚠️ Payment method required
Amazon RDS	⚠️ Proprietary RDBMS		⚠️ Only free for 1 year
Azure SQL Database	MS SQL Server		⚠️ Only free for 1 year
👉 Clever Cloud	PostgreSQL, MySQL, MongoDB, Redis	256 MB (PostgreSQL)	Max 5 connections (PostgreSQL)

	# Make sure to stop Appwrite before this backup,
	# and make sure you have enough space on the machine.

	# After backing up, make sure there is a file in 'backups/backup-___.tar.gz'.
	# Also please check size of this file, it should be at least 5kb, even for small instances.

	docker run --rm \
	-v appwrite_appwrite-mariadb:/backup/appwrite-mariadb \
	-v appwrite_appwrite-redis:/backup/appwrite-redis \
	-v appwrite_appwrite-cache:/backup/appwrite-cache \

	# !/bin/bash
	# Reference: https://copr.fedorainfracloud.org/coprs/principis/howdy/

	# sudo required
	if ! [ $(id -u) = 0 ]; then
	echo "Root privilege is needed. Please rerun the script as root." >&2
	exit 1
	fi

	SUDO_CFG="/etc/pam.d/sudo"

	import java.io.FileDescriptor;
	import java.io.FileOutputStream;
	import java.io.IOException;
	import java.io.OutputStream;
	import java.io.PrintStream;

	public class HelloWorld{
	private static HelloWorld instance;
	public static void main(String[] args){
	instantiateHelloWorldMainClassAndRun();

	<?php
	class Database{
	public $isConn;
	protected $data;

	public function __construct($username = "root", $password = "", $host = "127.0.0.1", $dbname = "test", $options = []){
	$this->isConn = TRUE;
	$this->data = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $username, $password, $options);
	$this->data->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	$this->data->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);

	filename='yourfilename'
	filetype='text/csv'
	token='my oauth token'
	url='http://localhost/upload'

	curl "$url" \
	--form "data=@$filename;type=$filetype" \
	--form "name=somename" \
	-H "Authorization: Bearer $token"