timothee-alby

With Heroku's pg-extra

On Heroku, the pg-extras CLI Plugin is available.

$ heroku pg:long-running-queries

List currently running queries that have been running for longer than 5 minutes. Heroku dynos have a 30-seconds disconnect so queries still running after 5 mins are usually problematic and can slow down the entire DB.

$ heroku pg:blocking

timothee-alby

Heroku Logs Parsing with angle-grinder

• Inspired by Power tools for analyzing your Heroku logs
• Heroku logs documentation
• angle-grinder on Github

Status Aggregate by Second

Command

timothee-alby

Programming challenge

A natural language time parser

You are a developer on a task manager app. Your users can create tasks and those tasks, in particular, have a time and date.

To provide a enhanced experience to your users upon task creation, you want the task date to be a free text field. A user would input strings such as in 2 days, 3 hours ago, tomorrow, on december 5th at noon, and you would save that information as a date object in the system.

Challenge

timothee-alby

#
# AppleScript to quit the current front app after a warning. Useful to remap CMD+Q and stop quitting app by mistake
#
# 1. Open AppleScript
# 2. Past this file
# 3. Save as `~/.quit_front_app.scpt`
# 4. Run `osascript ~/.quit_front_app.scpt`
# 5. There is no 5
#
tell application "System Events"

timothee-alby

module StringToBoolean
  def to_bool
    return true if self == true || self.strip =~ (/\A(true|t|yes|y|1)\Z/i)
    false
  end
end
class String; include StringToBoolean; end

module BooleanToBoolean
  def to_bool;return self; end