Skip to content

Instantly share code, notes, and snippets.

View jmacdotorg's full-sized avatar

Jason McIntosh jmacdotorg

View GitHub Profile
@jmacdotorg
jmacdotorg / perl-gsod-2021.md
Last active May 2, 2021 20:39
Perl's submission to Google Season of Docs 2021

GSoD 2021 Proposal: Audit Perl's documentation

This document presents a project proposed by The Perl Foundation for Google's 2021 Season of Docs program.

About Perl (and its docs)

Perl is a free, open-source, general-purpose programming language originally developed by Larry Wall in the 1980s. Fast, flexible, and expressive, Perl quickly found its way onto just about every Unix-derived operating system (and then some).

During the 1990s, Perl’s ubiquity and ease of use played an integral role in the explosive growth of the infant Web. Today, Perl enjoys ongoing maintenance and development thanks to a core team of volunteers. It remains a part of countless computers' internal toolkits, and continues to power software including critical operating system features, websites of every sort, and myriad creative hobby projects.

@jmacdotorg
jmacdotorg / plerd_wms_to_whim.pl
Created July 16, 2020 20:11
Convert a Plerd webmentions database into a Whim one
# This script converts a Plerd webmentions database into a Whim database.
#
# It won't affect your Plerd database, but it will write to your Whim one,
# so back up your Whim database first if it contains anything important to you.
#
# It runs using the same config file & options as plerdall & plerdwatcher.
#
# It writes to an SQLite database in the current directory. The script will
# fail if it can't find one. So, you may want to run this while in
# ~/.whim/data/, after running Whim at least once in order to create that DB.
@jmacdotorg
jmacdotorg / dump_oracle_schema_to_csv.pl
Created December 15, 2016 17:20
A Perl script to dump an Oracle database schema into CSV files.
# This Perl script dumps a given Oracle database schema into a set of CSV
# files. The files will be named for the tables, have column headers, and
# will all appear in the current working directory.
# Original script by Jason McIntosh <jmac@jmac.org>
#
# You will need:
# * Perl 5
# * DBD::Oracle all set up, and knowledge of what your DBI DSN string is.
# * Text::CSV, available from CPAN
#
@jmacdotorg
jmacdotorg / airports_and_aeronautical_stations.json
Last active December 6, 2015 05:10
A JSON hashtable of all airports and aeronautical stations known to the US NOAA, keyed by their four-letter ICAO codes. This is just a JSONification (with some further rearrangement) of a request made to the NOAA's XML API in December 2015. All data values are exactly as presented by the NOAA.
{
"AGGH" : {
"country" : "SB",
"elevation_m" : "9.0",
"latitude" : "-9.42",
"longitude" : "160.05",
"site" : "HONIARA/HENDERSO",
"site_types" : [
"METAR",
"TAF"