Install FFmpeg with homebrew. You'll need to install it with a couple flags for webm and the AAC audio codec.
brew install ffmpeg --with-libvpx --with-libvorbis --with-fdk-aac --with-opus
LeeMartin77
/ N64ArduinoUSB.ino
Created
June 5, 2020 20:42
N64 to USB GamepadConverter with a ATmega32U4 board
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // using the fantastic https://github.com/MHeironimus/ArduinoJoystickLibrary | |
| // Based on the soulders of giants: | |
| // Gamecube controller to Nintendo 64 adapter by Andrew Brown | |
| // http://www.cs.duke.edu/~brownan/n642gc.html | |
| // N64 to HID by Peter Den Hartog: | |
| // https://www.instructables.com/id/Use-an-Arduino-with-an-N64-controller/ | |
| // N64 Controller Tester by sanni | |
| // https://github.com/sanni/controllertest | |
| #include <pins_arduino.h> |
singledigit
/ cognito.yaml
Last active
September 20, 2025 17:27
Create a Cognito Authentication Backend via CloudFormation
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| AWSTemplateFormatVersion: '2010-09-09' | |
| Description: Cognito Stack | |
| Parameters: | |
| AuthName: | |
| Type: String | |
| Description: Unique Auth Name for Cognito Resources | |
| Resources: | |
| # Creates a role that allows Cognito to send SNS messages | |
| SNSRole: |
rgreenjr
/ postgres_queries_and_commands.sql
Last active
December 5, 2025 09:56
Useful PostgreSQL Queries and Commands
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |