| version: "3.9" | |
| volumes: | |
| postgres: | |
| services: | |
| postgres: | |
| image: postgres | |
| restart: unless-stopped | |
| healthcheck: |
| import os | |
| def split(filehandler, delimiter=',', row_limit=10000, | |
| output_name_template='output_%s.csv', output_path='.', keep_headers=True): | |
| """ | |
| Splits a CSV file into multiple pieces. | |
| A quick bastardization of the Python CSV library. | |
| Arguments: |
This is a simple way to backup your MySQL tables to Amazon S3 for a nightly backup - this is all to be done on your server :-)
Sister Document - Restore MySQL from Amazon S3 - read that next
this is for Centos 5.6, see http://s3tools.org/repositories for other systems like ubuntu etc
| # Some good references are: | |
| # http://russbrooks.com/2010/11/25/install-postgresql-9-on-os-x | |
| # http://www.paolocorti.net/2008/01/30/installing-postgis-on-ubuntu/ | |
| # http://postgis.refractions.net/documentation/manual-1.5/ch02.html#id2630392 | |
| #1. Install PostgreSQL postgis and postgres | |
| brew install postgis | |
| initdb /usr/local/var/postgres | |
| pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start |
NOTE: 534 stars, 106 forks. I love you all. Please contribute tips and edits back to this cheat sheet -- email's will.sargent@gmail.com and you can treat gists like git repositories and send git diffs.
| # A simple python script to extract names, and emails from | |
| # a certain online directory | |
| import os, json | |
| from bs4 import BeautifulSoup | |
| #get a list of the files in the current directory | |
| inputfiles = os.listdir(os.getcwd()) | |
| def postproc(inputfiles): |
#Mac OS X
| /* --------------------------------------------------------------------------- | |
| Boilerplate CSS Media Queries | |
| Encoding: UTF-8 | |
| Author: PaulUnd (http://www.paulund.co.uk/boilerplate-css-media-queries) | |
| --------------------------------------------------------------------------- */ | |
| /* =Smartphones (portrait and landscape) | |
| --------------------------------------------------------------------------- */ | |
| @media only screen |
| sudo apt-get update | |
| # General development essentials | |
| sudo apt-get install -y build-essential ssh git gitk | |
| # Databases: You may not need all of these; | |
| # none are explicit dependencies of other items in this script. | |
| # SQLite and MySQL are pretty generally used for web development, | |
| # and ODBC is just something we use at work. | |
| sudo apt-get install -y sqlite |
| # A guide to prevent pain and suffering while upgrading to OS X Mavericks | |
| # This will vary greatly depending on system set up, so read the instructions carefully | |
| # Back up Virtulenvs | |
| #################### | |
| # Very important! | |
| # For each virtualenv you have, run "pip freeze > requirements.txt" while in the activated virtualenv | |
| # in order to prevent loss of dependencies during the upgrade. |