Antony Leons AntonyLeons

## schema.py
# Use Pandas & SQLAlchemy.
# https://stackoverflow.com/questions/23103962/how-to-write-dataframe-to-postgres-table

# Note this will create a new table; see the 'faster option' at the above link for a method using 'copy' to an existing table.
# However, 'copy' cannot do an upsert; that requires inserting to a temp table, then upserting form temp table to destination table.

# This will lack PKs and FKs and indexes, of course, so if used naively you may see data duplication.

# Also the df.to_sql command can do an append (but not upsert), using the if_exists param:
# https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_sql.html

## scar_tissue.md

      
              1 file
            
          
              25 forks
            
          
              15 comments
            
          
              356 stars
            
          
                gtallen1187
                / scar_tissue.md
            
            
              Created
              November 1, 2015 23:53
            
              
                talk given by John Ousterhout about sustaining relationships
              
          
    "Scar Tissues Make Relationships Wear Out"

04/26/2103.  From a lecture by Professor John Ousterhout at Stanford, class CS142.

This is my most touchy-feely thought for the weekend. Here’s the basic idea: It’s really hard to build relationships that last for a long time. If you haven’t discovered this, you will discover this sooner or later. And it's hard both for personal relationships and for business relationships. And to me, it's pretty amazing that two people can stay married for 25 years without killing each other.


[Laughter]

> But honestly, most professional relationships don't last anywhere near that long. The best bands always seem to break up after 2 or 3 years. And business partnerships fall apart, and there's all these problems in these relationships that just don't last. So, why is that? Well, in my view, it’s relationships don't fail because there some single catastrophic event to destroy them, although often there is a single catastrophic event around the the end of the relation
	# Use Pandas & SQLAlchemy.
	# https://stackoverflow.com/questions/23103962/how-to-write-dataframe-to-postgres-table

	# Note this will create a new table; see the 'faster option' at the above link for a method using 'copy' to an existing table.
	# However, 'copy' cannot do an upsert; that requires inserting to a temp table, then upserting form temp table to destination table.

	# This will lack PKs and FKs and indexes, of course, so if used naively you may see data duplication.

	# Also the df.to_sql command can do an append (but not upsert), using the if_exists param:
	# https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_sql.html