Wolfgang Werner wwerner

Embed gist in iframe

it is used to embed gist to an asynchronously-loaded web pages.

<iframe 
    width="100%"
    height="350"    
    src="data:text/html;charset=utf-8,

GraphQL introspection query via curl

cat introspection_query.json

{ 
  "query": "query IntrospectionQuery {
      __schema {
        queryType { name }
        mutationType { name }

What / Why

Deploy key is a SSH key set in your repo to grant client read-only (as well as r/w, if you want) access to your repo.

As the name says, its primary function is to be used in the deploy process in replace of username/password, where only read access is needed. Therefore keep the repo safe from the attack, in case the server side is fallen.

How to

Generate a ssh key

	Get the Heroku db as detailed here:
	http://devcenter.heroku.com/articles/pgbackups#exporting_via_a_backup

	$ heroku pg:backups:capture # outputs backup_num in the last line
	$ heroku pg:backups:url <backup_num> #=> backup_url
	$ curl -o /tmp/latest.dump <backup_url>

	Then locally do:
	$ pg_restore --verbose --clean --no-acl --no-owner -h localhost -U myuser -d mydb /tmp/latest.dump