Diego Cornejo diegofcornejo

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?

Find the Discord channel in which you would like to send commits and other updates
In the settings for that channel, find the Webhooks option and create a new webhook. Note: Do NOT give this URL out to the public. Anyone or service can post messages to this channel, without even needing to be in the server. Keep it safe!

	https://dba010.com/2019/09/30/simpe-java-code-to-test-connection-to-oracle-database/

	Assuming that client computer does not have Oracle client installed.

	1. Download necessary version of ojdbc jar file from Oracle. The latest version for now is ojdbc8.jar

	2. Install java development tools:

	# yum install java-devel * -y
	3. Create a sample java code, which:

	const AWS = require('aws-sdk');
	const REGION = 'us-east-1';
	const DYNAMODB = new AWS.DynamoDB.DocumentClient();
	const TABLE = "ttn-events";

	exports.handler = async(event) => {
	var date = new Date();
	//dates should be obtained from request
	var end = date.toISOString();
	var start = new Date(date.setDate(date.getDate()-7)).toISOString();

	#!/bin/bash
	REPO="your-repo"
	OWNER="diegofcornejo"
	TOKEN="github_developer_token"
	APPDIR="/home/ec2-user"
	NODE_VERSION="12.16.3"
	cd $APPDIR
	touch init.log
	echo 'Updating OS' >> init.log
	yum update -y

	const { Client, Intents } = require('discord.js');
	// const client = new Client({ intents: [Intents.FLAGS.GUILDS, Intents.FLAGS.GUILD_MEMBERS] });
	const client = new Client({ intents: [Intents.FLAGS.GUILD_MEMBERS] });

	client.on('ready', () => {
	console.log(`Logged in as ${client.user.tag}!`);
	const guild = client.guilds.cache.get('GUILD_ID');

	// Fetch and get the list named 'members'
	guild.members.fetch().then(members => {

	import smtplib
	from email.mime.multipart import MIMEMultipart
	from email.mime.text import MIMEText
	mail_content = '''Hello,
	This is a simple mail.
	There is only text, no attachments are there The mail is sent using Python SMTP library.
	Thank You
	'''

	#The mail addresses and password

	/* jshint esversion:6, bitwise:false, node:true, strict:true */
	/* globals msg */
	"use strict";
	/**
	* Node-RED function to decode Axioma water meter payloads.
	* Example assuming that msg.req.body contains an HTTP POST callback from The Things Networks.
	*/

	function statusAxiomaShort(s) {
	const messages = [];

	var express = require('express');
	var bodyParser = require('body-parser');
	var app = express();
	var fs = require("fs");


	//===================================
	var XLSXChart = require("xlsx-chart");
	var xlsxChart = new XLSXChart();
	var opts = {

	import logging
	import sys

	import smpplib.gsm
	import smpplib.client
	import smpplib.consts

	from flask import Flask, request, jsonify
	# from flask_mysqldb import MySQL
	app = Flask(__name__)