Hugh Dunne hughdunne

## postgres-cheatsheet.md

      
              1 file
            
          
              1132 forks
            
          
              66 comments
            
          
              3509 stars
            
          
                Kartones
                / postgres-cheatsheet.md
            
            
              Last active
              June 24, 2024 13:42
            
              
                PostgreSQL command line cheatsheet
              
          
    PSQL

Magic words:
psql -U postgres
Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)


## reload.html
<script>document.write('<script src="http://' + (location.host || 'localhost').split(':')[0] + ':35729/livereload.js?snipver=1"></' + 'script>')</script>

## SpecRunner.html
<!DOCTYPE HTML>
<html lang="en-US">
<head>
	<meta charset="UTF-8">
	<title>Jasmine Spec Runner</title>
	<link rel="stylesheet" type="text/css" href="spec/jasmine/jasmine.css">
	<script src="spec/jasmine/jasmine.js"></script>
	<script src="spec/jasmine/jasmine-html.js"></script>

	<!-- include source files here... -->

## gist:952344

      
              1 file
            
          
              215 forks
            
          
              30 comments
            
          
              743 stars
            
          
                mtigas
                / gist:952344
            
            
              Last active
              June 20, 2024 11:22
            
              
                Mini tutorial for configuring client-side SSL certificates.
              
          
    Client-side SSL

For excessively paranoid client authentication.

Updated Apr 5 2019:
because this is a gist from 2011 that people stumble into and maybe you should AES instead of 3DES in the year of our lord 2019.
some other notes:

  
## gist:810399
#!/usr/bin/env python
from __future__ import with_statement
import os
import re
import shutil
import subprocess
import sys
import tempfile
	<!DOCTYPE HTML>
	<html lang="en-US">
	<head>
	<meta charset="UTF-8">
	<title>Jasmine Spec Runner</title>
	<link rel="stylesheet" type="text/css" href="spec/jasmine/jasmine.css">
	<script src="spec/jasmine/jasmine.js"></script>
	<script src="spec/jasmine/jasmine-html.js"></script>

	<!-- include source files here... -->
	#!/usr/bin/env python
	from __future__ import with_statement
	import os
	import re
	import shutil
	import subprocess
	import sys
	import tempfile