Skip to content

Instantly share code, notes, and snippets.

View julian-a-avar-c's full-sized avatar

Julian A Avar C julian-a-avar-c

View GitHub Profile
@julian-a-avar-c
julian-a-avar-c / package.json
Last active October 26, 2021 23:06
typescript+babel+teser gulpfile. It grabs every `.ts` file in `src` and throws them in `dist`, and transpiles to every module format.
{
"name": "typescript+babel+teser gulpfile",
"license": "MIT",
"author": {
"email": "[email protected]",
"name": "jaacko-torus",
"url": "https://github.com/jaacko-torus"
},
"type": "module",
"engines": {
@julian-a-avar-c
julian-a-avar-c / stitch.rb
Last active January 4, 2022 04:22
stitches a collection of images vertically, and upscales/downscales to a specific width
#!/usr/bin/env ruby
# Licensed under MIT. (c) 2022 Julian A Avar Campopiano
# Requires ruby3.0.0 and imagemagick
# Usage:
# stitch.rb [options] -i=[glob] -o=[glob]
# Example:
# stitch.rb -w=min -i=*.jpg
# stitch.rb -w=259.3 -i=photo_{a,b}.png -o=out_file.png
# Pre Setup
sudo apt update
sudo apt upgrade
# Setup
## Nala
sudo apt install nala
## Utils
@julian-a-avar-c
julian-a-avar-c / many_to_many.sql
Last active February 22, 2023 00:23
simpler table joining for many to many
with a_b_name_in(table_a_name, table_b_name)
as (
values
('table a 1', 'table b 1'),
('table a 2', 'table b 1'),
)
insert into a_b (a_id, b_name)
select a.id, b.id
from a_b_name_in
inner join table_a