mavvverick

System Design Cheatsheet

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

Basic Steps

1. 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?

mavvverick

-- Create a group
CREATE ROLE readaccess;

-- Grant access to existing tables
GRANT USAGE ON SCHEMA public TO readaccess;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;

-- Grant access to future tables
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;

mavvverick

/*
        Original idea from
        http://www.acloudtree.com/how-to-shove-data-into-postgres-using-goroutinesgophers-and-golang/
*/
package main

import (
        "log"
        "time"
        "os"

mavvverick

[
    {
        "name": "Status: Abandoned",
        "color": "000000"
    },
    {
        "name": "Status: Accepted",
        "color": "009800"
    },
    {

mavvverick

# -*-coding:utf-8-*-
import numpy as np
from PIL import Image
import sys
import json
import requests
import glob

_IMAGE_SIZE = 299
SERVER_URL = 'http://localhost:8501/v1/models/nsfw:predict'

mavvverick

USER={{user}} or {{organisation}}
TOKEN={{token}}
REPO={{repo}}

#Delete default labels
curl --user "$USER:$TOKEN" --include --request DELETE "https://api.github.com/repos/$USER/$REPO/labels/bug"
curl --user "$USER:$TOKEN" --include --request DELETE "https://api.github.com/repos/$USER/$REPO/labels/duplicate"
curl --user "$USER:$TOKEN" --include --request DELETE "https://api.github.com/repos/$USER/$REPO/labels/enhancement"
curl --user "$USER:$TOKEN" --include --request DELETE "https://api.github.com/repos/$USER/$REPO/labels/invalid"
curl --user "$USER:$TOKEN" --include --request DELETE "https://api.github.com/repos/$USER/$REPO/labels/question"

mavvverick

Story Phases

Design 
      ====> Mobile ====> Review (stake holder (Backend / Design)) =====> User
Backend


1. Phase must be decided based on delivery output
2. if UI/UX is the output
      As a mobile engineeer I want profile deisgn so that I can integrate in app 

mavvverick

## Create temproray table by picking min duplicate id and delete
delete table from table inner join 
    (select  min(id) minid, sample_data, sample_data1, sample_data2
     from table 
     group by ssample_data, sample_data1
     having count(1) > 1) as duplicates
   on (duplicates.minid = search_search.id)
   

## Keep only duplicate entry and delete rest