I did follow up on on of the possible improvements to the BlepBot in my last post. Mastodon has some fun day-specific tags for animal pics. I decided to use #TongueOutTuesday and #FurballFriday, since almost all the bleps are furry creatures.
# if it's Tuesday, add TongueOutTuesday hashtag
I also wanted to use a couple of cat-specific ones, but only on pictures of cats! To do that, I use re.search to regex search the post text for “cat” (case-insensitively).
Of course, we need to import datetime and re to use these:
from mastodon import Mastodon
import os,random,logging,datetime, re
The blepbot code is in github as a public template: https://github.com/nroshak/blepbot. Feel free to clone it and make it your own!
Bleps always cheer me up, so I decided to create a Mastodon bot that posted one blep a day. (A blep is a picture of an animal with a tiny bit of its tongue sticking out, and Mastodon is a decentralized alternative to Twitter.)
Creating a Mastodon bot in Python was surprisingly easy, thanks to the Mastodon.py library. I’ve documented all the steps here, along with links to tutorials for each library or builtin feature that I used.
Have you created any Mastodon or Twitter bots? Let me know in the comments!
One of the amazing things about being a DBA/developer in 2016 is the sheer amount of freely available, downloadable data to play with. One fun publicly available data sets is the American Social Security Administration names data. It contains all names for which SSNs were issued for each year, with the number of occurrences (although names with <5 occurrences are not included to protect individual privacy).
if you like to scp:
# If not running interactively, don't do anything
[[ $- == *i* ]] || return
Otherwise scp will fail without error – it’s a known bug.
A RAC DBA needs to keep at least two sets of environment variables handy: one for the Grid/ASM home, and one for the database home. Here's how I set up my .bashrc to make that easy.