monorkin

-- Replace with your SQL Query
SELECT
  a1.first_name || ' ' || a1.last_name AS first_actor,
  a2.first_name || ' ' || a2.last_name AS second_actor,
  film.title AS title
FROM film
  JOIN film_actor AS fa1 ON fa1.film_id = film.film_id
  JOIN film_actor AS fa2 ON fa2.film_id = film.film_id
                            AND fa1.actor_id <> fa2.actor_id
  JOIN actor AS a1 ON fa1.actor_id = a1.actor_id

monorkin

-- Replace with your SQL query
SELECT 
  to_date(a.date::text, 'YYYY-MM-DD') AS date, 
  a.count AS count,
  to_char(
    (count::float / lag(count) over (order by date) - 1) * 100, 
    'FM999999999.0%'
  ) AS percent_growth
FROM (
  SELECT 

monorkin

# return the array containing the tree levels, from root to last level.
def tree_by_levels(node)
  return [] unless node
  unpacked_tree = {}
  breadth_first_search(node, unpacked_tree)
  unpacked_tree.values.flatten
end

def breadth_first_search(node, hash = {}, depth = 0)
  return unless node

monorkin

def justify(text, width)
  return if text.nil? || width.nil? || width.negative?
    
  words = text.split(' ')
  rows = group_words_into_rows(words, width)
  rows = pad_rows(rows, width)
  rows.map(&:join).join("\n")
end

def group_words_into_rows(words, width)

monorkin

monorkin

Keybase proof

I hereby claim:

• I am monorkin on github.
• I am monorkin (https://keybase.io/monorkin) on keybase.
• I have a public key ASDDUMYqWMcsxPpKftv97h-jN911JPqFYX-8MZmToeu3dgo

To claim this, I am signing this object:

monorkin

SELECT licenses.license AS license, COUNT(licenses.repo_name) AS count
FROM [bigquery-public-data:github_repos.licenses] AS licenses
JOIN [bigquery-public-data:github_repos.languages] AS languages ON licenses.repo_name = languages.repo_name
WHERE languages.language.name = '<language name>'
GROUP BY license

monorkin

#!/usr/bin/env ruby
# frozen_string_literal: true

# USAGE:
# curl https://gist.github.com/stankec/.../iterm_theme_to_alacritty.rb > iterm_theme_to_alacritty.rb
# chmod +x iterm_theme_to_alacritty.rb
# ./iterm_theme_to_alacritty.rb path/to/your/theme.itermcolors
#
# This will output the config to the terminal
#

monorkin

Keybase proof

I hereby claim:

• I am stankec on github.
• I am monorkin (https://keybase.io/monorkin) on keybase.
• I have a public key ASDDUMYqWMcsxPpKftv97h-jN911JPqFYX-8MZmToeu3dgo

To claim this, I am signing this object:

monorkin

#!/bin/bash

# Configuration
DEVICE=/dev/ttyACM0
BAUD=9600
SEND=""
FOLLOW=0
RECEIVE=0
HELP=0