This document outlines some ideas for document conversion on Linux and Mac OS X platforms using command line tools. Distribute documents as plain text using UTF-8 encoding whenever possible. Everyone should embrace the mantra "plain text is beautiful".
Use file command to obtain basic metadata for most file formats. For image files make sure you have ImageMagick installed, then use identify command to extract image metadata.
| CREATE TABLE `sic_code` ( | |
| `code` varchar(32) NOT NULL DEFAULT '', | |
| `label` varchar(256) DEFAULT NULL, | |
| `parent_code` varchar(32) DEFAULT NULL, | |
| `level` int(11) DEFAULT NULL | |
| ) DEFAULT CHARSET=utf8; | |
| INSERT INTO `sic_code` (`code`,`label`,`parent_code`,`level`) | |
| VALUES | |
| ('D','MANUFACTURING',NULL,0), |
| Remove file from git repository (history) | |
| SOLUTION: This is the shortest way to get rid of the files: | |
| 1. check .git/packed-refs - my problem was that I had there a refs/remotes/origin/master line for a remote repository, delete it, otherwise git won't remove those files | |
| 2. (optional) git verify-pack -v .git/objects/pack/#{pack-name}.idx | sort -k 3 -n | tail -5 - to check for the largest files | |
| 3. (optional) git rev-list --objects --all | grep #{SHA_FROM_#_3} - to check what files those are |
| 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 |
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).
| # 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 |
| 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. |
| 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 = { |
Picking the right architecture = Picking the right battles + Managing trade-offs
| 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) |