Skip to content

Instantly share code, notes, and snippets.

@andrew-1234
andrew-1234 / universe.sql
Created June 30, 2024 15:45
Build a Celestial Bodies Database freeCodeCamp project
--
-- PostgreSQL database dump
--
-- Dumped from database version 12.17 (Ubuntu 12.17-1.pgdg22.04+1)
-- Dumped by pg_dump version 12.17 (Ubuntu 12.17-1.pgdg22.04+1)
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
@andrew-1234
andrew-1234 / sidebar.py
Created December 11, 2023 01:14
Markdown sidebar creator for GitLab Wikis
# %%
import os
def generate_sidebar(path, base_path="", indent=0, order=[]):
sidebar = ""
files = os.listdir(path)
# Sort files and directories based on the specified order, if available
if order:
files.sort(key=lambda x: order.index(
library(tuneR)
library(dynaSpec)
cc02_5 <- readWave(filename = "cut/call-5-CC02.wav")
cc02_5 <- normalize(cc02_5, unit = c("16"))
scrolling_spectro(wave = cc02_5,
wl = 512,
ovlp = 90,
t.display = 3,
@andrew-1234
andrew-1234 / raven_shortcuts.ahk
Last active October 31, 2022 23:45
AHK script for adding various keyboard shortcuts to Raven Pro
;; Raven Shortcuts
;; https://github.com/andrew-1234
;; Intro:
;; install AHK if you haven't already
;; save this script, make sure it has extension .ahk
;; double click to run the script. you should see it running in your task bar
;; icons
;; Usage note: this script works by moving your mouse to predefined positions,