amcclosky

Supabase Database Architecture

Security & Compliance Requirements

SOC II Compliance

• All sensitive data must be encrypted at rest
• Audit logging for all data access and modifications
• Role-based access control (RBAC) with principle of least privilege
• Data backup and recovery procedures
• Regular security assessments and monitoring

amcclosky

UILD for PL/pgSQL

ULID is a format for k-ordered distributed id generation. i.e. you can generate a random unique id with no central coordination and later be able to mostly sort the ids by the time they were generated.

When won't ids be sorted?

If ids are generated within the same second on different instances they could be out of order within that second.

Source of this code:

amcclosky

// vim: ft=javascript:
/*jslint sloppy: true, vars: true, white: true, nomen: true, browser: true  */
/*global SpreadsheetApp, UiApp, UrlFetchApp, Utilities */
/*
 * A script to automate requesting data from an external url that outputs CSV data.
 *
 * Adapted from the Google Analytics Report Automation (magic) script.
 * @author [email protected] (Nick Mihailovski)
 * @author [email protected] (Ian Lewis)
*/

amcclosky

function sign_s3(access_key, private_key, bucket, object_name, validity, base_url) {
  if(!base_url) {
    base_url = "http://s3.amazonaws.com";
  }
  if(!validity) {
    validity = 60;
  }
  expires = Math.floor((new Date()).getTime() / 1000) + validity;
  object_name = encodeURIComponent(object_name);
  stringToSign = "GET\n\n\n"+expires+"\n/"+bucket+"/"+object_name;

amcclosky

# The following script scrapes ESPN's MLB Standings Grid and writes the
# standings for each American League (AL) team to a CSV file, which has the following
# format:
# Team, Opponent, Wins, Losses

from bs4 import BeautifulSoup
import urllib2
import re
import csv

amcclosky

0 - Read http://blog.databigbang.com/running-your-own-anonymous-rotating-proxies/
1 - Install monit, haproxy, tor and delegated. 
2 - Setup your environment in the setup.rb file
3 - Just run > ruby setup.rb
4 - ...........
5 - PROFIT! > http://www.southparkstudios.com/clips/151040/the-underpants-business