nyimbi

Table geoname {
    id serial [pk, note: 'Unique identifier for each geoname'] 
    name varchar(200) [note: 'Local name of the place or location']
    asciiname varchar(200) [note: 'ASCII version of the name, suitable for URL or systems that dont support unicode']
    alternatenames text [note: 'Alternative names or variations of the location name, possibly in different languages or scripts']
    latitude float [note: 'Latitude coordinate of the location']
    longitude float [note: 'Longitude coordinate of the location']
    fclass char(1) [note: 'Feature class, represents general type/category of the location e.g. P for populated place, A for administrative division']
    fcode varchar(10) [note: 'Feature code, more specific than feature class, indicating the exact type of feature']

nyimbi

Compute
    EC2                                                 Virtual Private Servers
    Lightsail                                           Amazon's hosting provider (vps, dns, storage)
    Lambda                                              Functions you can run, written in Python, NodeJS, Go etc. Can run many in parallel.
    Batch                                               Run software jobs on EC2 machines
    Elastic Beanstalk                                   Run software on managed virtual machines
    Serverless Application Repository                   Repository of serverless applications that you can deploy (on lambda)
    AWS Outposts                                        Basically run Amazon services on your own hardware (datacenter)
    EC2 Image Builder                                   Create EC2 (ami?) images automatically

nyimbi

Anti-hype LLM reading list

Goals: Add links that are reasonable and good explanations of how stuff works. No hype and no vendor content if possible. Practical first-hand accounts and experience preferred (super rare at this point).

My own notes from a few months back.

Background

• Survey of LLMS
• Self-attention and transformer networks

nyimbi

# must have conda installed
git clone https://github.com/joonspk-research/generative_agents.git
cd generative_agents
# open visual studio code, open gen agents folder
# within vscode, go to reverie/backend_server
# create new file utils.py
# copy/paste contents from github (below)

###
# Copy and paste your OpenAI API Key

nyimbi

Install s3fs on Mac OS X

1 - Install Homebrew if you haven't already - http://brew.sh/"Acce
  ruby -e "$(curl -fsSL https://raw.github.com/Homebrew/homebrew/go/install)"
  
2 - Use Homebrew to install s3fs + dependencies
  brew install --cask macfuse
  brew install gromgit/fuse/s3fs-mac
  
3. Get the access key and secret key from linode for your buckets. 

nyimbi

javascript:(function() {
  var timeout = null;
  var delay = 1000;

  var script = document.createElement('script');
  script.src = 'https://cdn.jsdelivr.net/npm/mathjax@3/es5/tex-mml-chtml.js';
  document.head.appendChild(script);

  script.addEventListener('load', function() {
    var mathJaxConfig = {

nyimbi

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?

nyimbi

CREATE EXTENSION btree_gist;

CREATE TABLE room_reservations (
    room_id integer,
    reserved_at timestamptz,
    reserved_until timestamptz,
    canceled boolean DEFAULT false,
    EXCLUDE USING gist (
        room_id WITH =, tstzrange(reserved_at, reserved_until) WITH &&
    ) WHERE (not canceled)

nyimbi

#!/usr/bin/python3

# Australian National University Quantum Random Numbers Generator API running on AWS


import json
import requests

QRN_URL = "https://api.quantumnumbers.anu.edu.au/"
QRN_KEY = "txxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx7"  # replace with your secret API-KEY

nyimbi

madlib-postgres-ubuntu

Instructions for installing MADlib and Postgres on Ubuntu 16.04

# Install Postgres 9.6, pl/r and dependencies for MADlib
sudo apt-get install -y cmake postgresql-9.6 postgresql-server-dev-9.6 postgresql-plpython-9.6 postgresql-9.6-plr libkrb5-dev postgresql-client postgresql-contrib

# grab madlib rpm
cd /home/gpadmin/tmp