Skip to content

Instantly share code, notes, and snippets.

View hadrienblanc's full-sized avatar

Hadrien Blanc hadrienblanc

29 followers · 48 following
  • Paris, France
View GitHub Profile
@hadrienblanc
hadrienblanc / background.html
Created March 17, 2025 16:30
<div style="background-color: #e5e5f7;
opacity: 1;
background-image: linear-gradient(#fff 4px, transparent 4px), linear-gradient(to right, #fff 4px, #f1f1f1 4px);
background-size: 25px 25px;
">
@hadrienblanc
hadrienblanc / foreign_check_key.sql
Created April 30, 2024 20:09
if ok :
do $$
declare r record;
BEGIN
FOR r IN (
SELECT FORMAT(
'UPDATE pg_constraint SET convalidated=false WHERE conname = ''%I'' AND connamespace::regnamespace = ''%I''::regnamespace; ALTER TABLE %I.%I VALIDATE CONSTRAINT %I;',
constraint_name,
table_schema,
table_schema,
table_name,
@hadrienblanc
hadrienblanc / Loop through each file in the directory.sh
Created April 30, 2024 19:44
Loop through each file in the directory
# Loop through each file in the directory
for file in *; do
if [ -f "$file" ]; then # Check if it's a file (and not a directory)
echo "Filename: $file" # Print the name of the file
cat "$file" # Print the contents of the file
echo # Print a newline for better readability between files
fi
done
@hadrienblanc
hadrienblanc / watch_every_1_second.sh
Created April 15, 2024 12:35
watch -n 1 ls -lh backup.sql
@hadrienblanc
hadrienblanc / get_all_the_repository.sh
Created April 5, 2024 10:17
#!/bin/bash
brew install jq
ORG="xxxx"
TOKEN="xxxx" # 30 days valid
# Ensure jq and curl are installed
REPOS=$(curl -H "Authorization: token $TOKEN" "https://api.github.com/orgs/${ORG}/repos?per_page=100&type=all" | jq -r '.[].clone_url')
@hadrienblanc
hadrienblanc / tesseract_ocr_example.sh
Created August 22, 2021 14:47
curl -s 'https://pbs.twimg.com/media/E9T96Q9XIAcs8xJ?format=jpg&name=large' -o - | tesseract stdin stdout | grep --color 609
@hadrienblanc
hadrienblanc / database.yml
Last active January 26, 2021 19:44
---
development:
url: <%= ENV['DATABASE_URL'].gsub('?', '_development?') %>
test:
url: <%= ENV['DATABASE_URL'].gsub('?', '_test?') %>
staging:
url: <%= ENV['DATABASE_URL'].gsub('?', '_staging?') %>
production:
url: <%= ENV['DATABASE_URL'].gsub('?', '_production?') %>
@hadrienblanc
hadrienblanc / chineses_stuff.md
Created January 15, 2021 15:57
@hadrienblanc
hadrienblanc / file.sh
Created November 4, 2020 10:09
file "example.flac"
example.flac: FLAC audio bitstream data, 16 bit, stereo, 44.1 kHz, 2474304 samples
@hadrienblanc
hadrienblanc / ffmpeg_slideshow_creator.sh
Created November 1, 2020 18:26
# Here is how to create a slideshow from images (1.jpg,2.jpg..,8.jpg) with FFmpeg on your Linux or Unix box:
ffmpeg -y -r 1/3 -framerate 1 -i %1d.jpg -c:v libx264 -vf fps=5 -pix_fmt yuv420p out.mp4