Ryan Tuck ryantuck

superintelligence

"an intellect that is much smarter than the best human brains in practically every field, including scientific creativity, general wisdom and social skills."

artificial general intelligence, as opposed to specialized AI
either computer intelligence or human-augmented intelligence
kurzweil - not pessimistic, multiple AIs, cloud-augmented minds
silicon operates orders of magnitude faster (1M x) than neurons, parallelization
humans outperform animals in long-term planning and language use rather than biology - AI would probably do the same
AIs could edit and improve themselves so rapidly that we must expect a fast take-off once machines hit human-level intelligence

find any rows where multiple ids exist:

select
  *
from
  my_table
where
  id in (
 select

set up lambda (basic execution role)
just api call and return
incorporate boto3 writing to dynamodb
change input to handle date range or payload etc
change success message

testing in browser - woo fun, but let's make an api endpoint

make api endpoint with POST
test in browser

fermi paradox

universe is huge

100b stars in milky way
100b galaxies in observable universe
10^22 stars available
sun-like stars 5-20% (est 1%)
possible earth-like planets 22-50% (est 10%)
estimate 1% of earth-like planets develop life

	aws cloudwatch get-metric-statistics \
	--metric-name DatabaseConnections \
	--start-time 2016-09-01T00:00:00 \
	--end-time 2016-09-06T00:00:00 \
	--period 3600 \
	--namespace AWS/RDS \
	--statistics Average \
	--dimensions Name=DBInstanceIdentifier,Value=my-db-instance-identifier-name

	import arrow
	import sympy


	def get_timestamps(event, context):

	# get current birthday!

	birth_str = event.get('birthdate', None)

	#!/bin/bash

	# executes a .sql file and outputs results to a .csv
	# ./sql_to_csv.sh my_query.sql output.csv

	CONN="psql -U my_user -d my_db"

	# remove all semicolons and comments
	# replace newlines with spaces
	QUERY="$(sed 's/;//g;/^--/ d;s/--.*//g;' $1 \| tr '\n' ' ')"

	-- view interesting information for all queries for a user
	select
	pid,
	client_addr,
	application_name,
	(current_timestamp - query_start) as duration,
	state,
	query
	from
	pg_stat_activity

	-- show all schema information
	select * from information_schema.schemata;


	-- find which schema a table is in
	select
	table_schema
	from
	information_schema.tables
	where

	-- find rows where a certain key exists
	select
	*
	from
	my_table
	where
	json_field::jsonb ? 'key_i_want'
	;

	-- get certain key from json field