leonardorifeli

Deep Dive: PostgreSQL on AWS

When loading data

• disable backups (backup_retention=0)
• disable multi-AZ and autovacuum
• pg_dump -Fc (compressed) and pg_restore -j (parallel)
• Increase maintenance_work_mem

leonardorifeli

Deep Dive: PostgreSQL on AWS

When loading data

• disable backups (backup_retention=0)
• disable multi-AZ and autovacuum
• pg_dump -Fc (compressed) and pg_restore -j (parallel)
• Increase maintenance_work_mem

leonardorifeli

const puppeteer = require('puppeteer');

class Jokes {

    static async getBestData() {
        const browser = await this.getBrowser();

        const page = (await browser.pages())[0];
        await this._definePageConfig(page);

leonardorifeli

const CSV_URL = "https://gist.githubusercontent.com/leonardorifeli/9051a515e14c061247d483906383152e/raw/78f3b0702ade0348aa776d2727eddbe815df8348/spotify-music-classification";

const request = require('request-promise-native').defaults({
    resolveWithFullResponse: true
});
const csv = require('csvtojson');

class CSVParser {

    static async parseCSV(url) {

leonardorifeli

class DateParser {

    date: Date;
  
    constructor(date: string) {
        try {
            this.date = new Date(this.format(date));
        } catch (e) {
            throw e;
        }

leonardorifeli

package main

import (
	"log"

	"encoding/json"
	"fmt"
	"os"

	"math/rand"

leonardorifeli

// the wizare functions
var sendString = (function(rfb, force, sendDelay) { 
sendDelay = sendDelay || 25;
var _q = [];
var _qStart = function() {
var chr = _q.shift();
if (chr) {
  rfb.sendKey(chr);
  setTimeout(_qStart, sendDelay);
}

leonardorifeli

var AWS = require('aws-sdk'),
    fs = require('fs');

// For dev purposes only
AWS.config.update({ accessKeyId: '...', secretAccessKey: '...' });

// Read in the file, convert it to base64, store to S3
fs.readFile('del.txt', function (err, data) {
  if (err) { throw err; }

leonardorifeli

#!/bin/bash

sudo kextunload -b com.apple.iokit.BroadcomBluetoothHostControllerUSBTransport
sudo kextload -b com.apple.iokit.BroadcomBluetoothHostControllerUSBTransport

leonardorifeli

async function sendAsync(userId) {
  let user = await getUser(userId);
  let profile = await getProfile(user);
  let account = await getAccount(profile);
  let report = await getReport(account);
  
  let send = sendStatistic(report);
  
  console.log(send);
}