Skip to content

Instantly share code, notes, and snippets.

@dadhi
dadhi / GetMaterializedViewSize.sql
Last active December 18, 2025 14:56
Find disk size of Postgres materialized view
/*
https://dba.stackexchange.com/questions/96534/postgres-check-disk-space-taken-by-materialized-view?newreg=6b1d58604fce4a1fbe3033ddbb52d7ca
relkind:
r = ordinary table,
i = index,
S = sequence,
v = view,
m = materialized view,
c = composite type,
@kushan1999-g
kushan1999-g / Index.html
Created December 18, 2025 14:44
Kavee Closthing
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Kavee Clothing App</title>
<style>
body { font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; background-color: #f4f4f9; margin: 0; padding: 20px; }
.header { text-align: center; background: #333; color: white; padding: 20px; border-radius: 10px; margin-bottom: 20px; }
.header h1 { margin: 0; }
@trevc
trevc / Fix Davinci Resolve on Arch Linux - Oct 25th 2025 _ZNSt3__14cerrE.md
Last active December 18, 2025 14:55
Fix Davinci Resolve on Arch Linux - Oct 25th 2025 _ZNSt3__14cerrE

This fixes the following Davinci Resolve error if you ran a system update (pacman -Syu) after Oct 25th:

/opt/resolve/bin/resolve: Symbol `_ZNSt3__14cerrE' has different size in shared object, consider re-linking
/opt/resolve/bin/resolve: Symbol `_ZNSt3__14coutE' has different size in shared object, consider re-linking
fish: Job 1, '/opt/resolve/bin/resolve' terminated by signal SIGSEGV (Address boundary error)

If you're on Bash, it'll show: Segmentation fault (core dumped)

 Arch’s October update to libc++ and libc++abi broke compatibility with some Resolve 20.x releases. Add the old libc++ libraries to Resolve's /opt/resolve/libs/ dir:

@nntrn
nntrn / espn-api-list.md
Last active December 18, 2025 14:50
List of nfl api endpoints from espn

List of NFL API Endpoints

This page has been updated a lot in the past 3 years. Older revisions you might like more than this one:

@jcubic
jcubic / cdn.md
Last active December 18, 2025 14:48
How to setup a literally free CDN
@aamiaa
aamiaa / CompleteDiscordQuest.md
Last active December 18, 2025 14:46
Complete Recent Discord Quest

Complete Recent Discord Quest

Note

This does not works in browser for quests which require you to play a game! Use the desktop app to complete those.

How to use this script:

  1. Accept a quest under Discover -> Quests
  2. Press Ctrl+Shift+I to open DevTools
  3. Go to the Console tab
  4. Paste the following code and hit enter:

Oh my zsh.

Install with curl

sh -c "$(curl -fsSL https://raw.githubusercontent.com/robbyrussell/oh-my-zsh/master/tools/install.sh)"

Enabling Plugins (zsh-autosuggestions & zsh-syntax-highlighting)

  • Download zsh-autosuggestions by
@usagimaru
usagimaru / sealadobe.sh
Last active December 18, 2025 14:43
Disable to launch all strange Adobe agents & daemons when your Mac startups.
#!/bin/sh
# Usage
# % sudo /path/to/sealadobe.sh
DisableDirName="Disabled"
User_Agents="$HOME/Library/LaunchAgents/"
Lib_Agents="/Library/LaunchAgents/"
Lib_Daemons="/Library/LaunchDaemons/"
@NeoTheFox
NeoTheFox / compatdata.sh
Last active December 18, 2025 14:40
Link Steam's Proton prefixes by name for ease of use
#!/usr/bin/env bash
help() {
echo NAME
echo " compatdata.sh - create \"by-game\" symlink folder for every compatdata folder on this machine"
echo
echo SYNOPSIS
echo " compatdata.sh [-h] [-p]"
echo
echo OPTIONS
@TheVeryStarlk
TheVeryStarlk / chunk-format.en.md
Last active December 18, 2025 14:39
Minecraft's 1.8 Chunk Format

This article explains how chunk packets work in Minecraft 1.8 (PVN 47). I was motivated to write this due to the lack of easily understandable documentation for this version of Minecraft. I drew inspiration from the Wiki's article. This article wouldn't have been possible without the awesome folks from the Minecraft Protocol Discord server.

Terminology

  • Section: A 16x16x16 collection of blocks, including block light and skylight.
  • Chunk: A vertical stack of 16 sections.

Packets

  • 0x21: Used to send a single chunk column.