Skip to content

Instantly share code, notes, and snippets.

@sjparsons
sjparsons / baseline.html
Last active November 6, 2015 13:43
Don't lose your vertical rhythm.
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>title</title>
<link rel="stylesheet" href="http://basehold.it/36">
<style>
@sjparsons
sjparsons / dump-all-databases.sh
Created July 2, 2012 19:29
Backup each MySQL database on a MySQL server into a separate file.
#!/bin/bash
# dump-all-databases.sh
#
#
# Backup each MySQL database on a MySQL server into a separate file.
# Optionally files can be gzipped (dbname.sql.gz)
#
# Usage: dump_all_databases [ -u username -o output_dir -h hostname -x exclude -z ]
#
# -u username to connect MySQL server
@sjparsons
sjparsons / structure_algorithms.txt
Created June 7, 2012 13:54
Crawler: Structure and Algorithms
== Database Structure
Table: crawler_<site>_urls
url (str) primary
accessed (date)
content-type (str)
content-length (int)
status (str)
etag (if set, the crawler can use the etag in it's requests
to reduce unnecessary checks)