| #!/usr/bin/env python | |
| # | |
| # Convert .itermcolors files to hex colors for html | |
| import sys | |
| import xml.etree.ElementTree as ET | |
| def rgb_to_hex(rgb): | |
| return '#%02x%02x%02x' % rgb |
| Afghanistan | |
| Albania | |
| Algeria | |
| Andorra | |
| Angola | |
| Antigua & Deps | |
| Argentina | |
| Armenia | |
| Australia | |
| Austria |
SchemaSpy is a neat tool to produce visual diagrams for most relational databases.
Here's how to use it to generate schema relationship diagrams for PostgreSQL databases:
Download the jar file from here (the current version is v6.1.0)
Get the PostgreSQL JDBC driver (unless your installed version of java is really old, use the latest JDBC4 jar file)
Run the command against an existing database. For most databases, the schema (-s option) we are interested in is the public one:
| // Usage: | |
| // Copy and paste all of this into a debug console window of the "Who is Hiring?" comment thread | |
| // then use as follows: | |
| // | |
| // query(term | [term, term, ...], term | [term, term, ...], ...) | |
| // | |
| // When arguments are in an array then that means an "or" and when they are seperate that means "and" | |
| // | |
| // Term is of the format: | |
| // ((-)text/RegExp) ( '-' means negation ) |
| <?xml version="1.0" encoding="UTF-8"?> | |
| <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> | |
| <plist version="1.0"> | |
| <dict> | |
| <!-- ... --> | |
| <!-- Add this section: --> | |
| <key>CFBundleURLTypes</key> | |
| <array> | |
| <dict> |
| /** | |
| * Using Operator Mono in Atom | |
| * | |
| * 1. Open up Atom Preferences. | |
| * 2. Click the โOpen Config Folderโ button. | |
| * 3. In the new windowโs tree view on the left you should see a file called โstyles.lessโ. Open that up. | |
| * 4. Copy and paste the CSS below into that file. As long as you have Operator Mono SSm installed you should be golden! | |
| * 5. Tweak away. | |
| * | |
| * Theme from the screenshot (http://cdn.typography.com/assets/images/blog/operator_ide2.png): |
| # TODO: variants of non-alphanumerics, greek letters, and others | |
| !"#$%&'()*+,-./โฟโถโทโธโนโบโปโผโฝโพ:;<=>?@๐ ๐ ๐ ๐ ๐ ๐ ๐ ๐ ๐ ๐ ๐ ๐ ๐ ๐ ๐ ๐ ๐ ๐ ก๐ ข๐ ฃ๐ ค๐ ฅ๐ ฆ๐ ง๐ จ๐ ฉ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ # BlackCircle | |
| !"#$%&'()*+,-./0123456789:;<=>?@๐ ฐ๐ ฑ๐ ฒ๐ ณ๐ ด๐ ต๐ ถ๐ ท๐ ธ๐ น๐ บ๐ ป๐ ผ๐ ฝ๐ พ๐ ฟ๐๐๐๐๐๐ ๐๐๐๐[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ # BlackSquare | |
| !"#$%&'()*+,-./๐๐๐๐๐๐๐๐๐๐:;<=>?@๐๐๐๐๐๐ ๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐[\]^_`๐๐๐๐๐๐๐ ๐ก๐ข๐ฃ๐ค๐ฅ๐ฆ๐ง๐จ๐ฉ๐ช๐ซ๐ฌ๐ญ๐ฎ๐ฏ๐ฐ๐ฑ๐ฒ๐ณ{|}~ # Bold | |
| !"#$%&'()*+,-./0123456789:;<=>?@๐ฌ๐ญ๐ฎ๐ฏ๐ฐ๐ฑ๐ฒ๐ณ๐ด๐ต๐ถ๐ท๐ธ๐น๐บ๐ป๐ผ๐ฝ๐พ๐ฟ๐๐๐๐๐๐ [\]^_`๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐๐{|}~ # BoldFraktur |
| '''This script can be used to export data from Pocket (getpocket.com) | |
| Uses include migrating to a different "read it later" service, saving | |
| specific articles to another service, backing up your reading history, | |
| and more. | |
| Currently it can be used to export links and metadata for archived | |
| articles with a given tag, which are more recent than a given timestamp. | |
| An example use case is to export all articles you have tagged as | |
| "to-export", which are newer than 10 days old. The timestamp functionality |
| #!/usr/bin/env python | |
| """ | |
| Twitter's API doesn't allow you to get replies to a particular tweet. Strange | |
| but true. But you can use Twitter's Search API to search for tweets that are | |
| directed at a particular user, and then search through the results to see if | |
| any are replies to a given tweet. You probably are also interested in the | |
| replies to any replies as well, so the process is recursive. The big caveat | |
| here is that the search API only returns results for the last 7 days. So |