Skip to content

Instantly share code, notes, and snippets.

-- SQL INNER JOIN Lecture
-- An INNER JOIN returns only the rows where there is a match in both tables based on the specified join condition.
-- If there's no match, the rows from both tables are excluded from the result set.
-- Create database
CREATE DATABASE db_inner_join;
USE db_inner_join;
-- Create authors table
CREATE TABLE authors (
@q9h
q9h / Building a Full-Featured Browser in Rust from Scratch.md
Created August 26, 2025 14:14
Building a Full-Featured Browser in Rust from Scratch
@aamiaa
aamiaa / CompleteDiscordQuest.md
Last active December 23, 2025 13:04
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:
@toxicdeep
toxicdeep / polars.md
Created December 22, 2024 09:36 — forked from bitsnaps/polars.md
A cheat sheet for polars python package

Polars Cheat Sheet

Here's a cheat sheet for the Polars Python package, covering many of its key functions and features:

Installation

pip install polars 

# Install Polars with all optional dependencies:
pip install 'polars[all]'
import argparse
import copy
import csv
import logging
import re
import shutil
import zipfile
from datetime import datetime
from pathlib import Path
import xml.etree.ElementTree as ET
@ciiqr
ciiqr / zod-optional-null.ts
Last active December 23, 2025 12:59
zod optional/nullable/nullish differences
// zod schema
z.object({
// valid if string or:
optional: z.string().optional(), // field not provided, or explicitly `undefined`
nullable: z.string().nullable(), // field explicitly `null`
nullish: z.string().nullish(), // field not provided, explicitly `null`, or explicitly `undefined`
});
// type
{
@dhondta
dhondta / README.md
Last active December 23, 2025 12:59
Tinyscript steganography tool based on base32/64 padding

Paddinganograph

This Tinyscript-based tool allows to unhide data hidden in base32/base64 strings. It can take a PNG or JPG in input to retrieve an EXIF value as the input data.

This can be installed using:

$ pip install tinyscript
$ tsm install paddinganograph
@tranquan
tranquan / xcode-keybindings-as-vscode.md
Last active December 23, 2025 12:55
Xcode KeyBindings as VSCode
@edxeth
edxeth / claude-frontend-design-skill
Created December 21, 2025 15:45
Claude's frontend design skill
---
name: frontend-design
description: Create distinctive, production-grade frontend interfaces with high design quality. Use this skill when the user asks to build web components, pages, or applications. Generates creative, polished code that avoids generic AI aesthetics.
license: Complete terms in LICENSE.txt
---
This skill guides creation of distinctive, production-grade frontend interfaces that avoid generic "AI slop" aesthetics. Implement real working code with exceptional attention to aesthetic details and creative choices.
The user provides frontend requirements: a component, page, application, or interface to build. They may include context about the purpose, audience, or technical constraints.
@ankarhem
ankarhem / hon-reborn-macos-kegworks.md
Last active December 23, 2025 12:54
HoN: Reborn on MacOS (kegworks wine)