Gists
Share and discover code snippetsSELECT with JOIN
This snippet merges data from multiple tables into a single result set based on a related column between them.
jamesgarcia426
Functional option unwrap
Safely and idiomatically extract values from an Option using functional combinators like map, unwrapor, and andthen to avoid panics and keep your code expressive.
gwhite476
safe table indexing
Safely retrieves a value from a nested Lua table, returning nil if any intermediate key is missing.
astewart981
swap two variables
Swap two variables in Ruby with parallel assignment, no temp variable needed.
diana49945
RAII lock guard
This snippet automatically acquires a mutex lock on construction and releases it on destruction, making thread synchronization both exception-safe and concise.
marthathornton651
Reverse a list
This snippet reverses the order of elements in a list, returning a new list.
jorgeharrell188
Merge dictionaries
This snippet merges two or more dictionaries into one, combining their key-value pairs with later keys overriding earlier ones.
rodgersjennifer232
Generate UUID v4
This snippet generates a version 4 UUID in PHP using built-in functions.
mcdonaldjamie520
RAII scope guard
A scope guard in C++ uses RAII to automatically execute a cleanup action when leaving a scope, ensuring resource safety without manual management.
bowenjonathan73
Flexbox Centering
This Flexbox snippet centers a child element both horizontally and vertically inside its parent container.
bowenjonathan73
Predicate not method
This snippet creates a negated predicate using Predicate.not() to easily invert a filtering condition.
I found Predicate.not() handy until I tried chaining it with or() and realized it can break readability fast. Ever had to explain a stream.filter(Predicate.not(SomeClass::isValid)) to a junior dev on a code review?
amysmith435
Find empty directories
This bash snippet recursively finds and lists all empty directories in the current directory.
allison76938
Update with Join
This snippet updates rows in a table based on matching values from another table using a JOIN.
@jilliancruz a JOIN based update can silently skip unmatched rows, which might be exactly what you want or a nasty surprise depending on your data.
kellysnyder359
Flexbox center child
This snippet centers a child element both horizontally and vertically within its parent using Flexbox.
@moniquediaz119 this flexbox trick works great, but I've been burned before when the parent didn't have an explicit height and the vertical centering just didn't kick in. Do you usually set a fixed height or rely on something like min-height?
elizabeth67970
Array eachwithindex
Iterate over an array while accessing both the element and its index in each iteration.
I once spent two hours debugging a race condition because I used for...in on an array instead of forEach with the index parameter. The indices came back as strings and broke my comparison logic. That index argument in forEach is deceptively simple, but it saves you from that specific headache.
pattycarter249
Validate email address
This PHP snippet quickly validates an email address using PHP's built-in filtervar function with the FILTERVALIDATEEMAIL flag.
yeah, filtervar is definitely the way to go for quick validation. just keep in mind it only checks format, not if the email actually exists.
michaelstone116
Flexbox centering
Easily center any element both horizontally and vertically using Flexbox with just three lines of CSS.
hey @astewart981 that's the classic, works every time. though i usually toss in min-height: 100vh if i want it centered in the viewport too.
Have @tracy_jackson you run into issues with older Safari ignoring those three lines on nested flex items, @tracyjackson?
pjenkins98
find files by size
This snippet uses the find command to locate files in a directory tree based on their size, such as finding all files larger than a specified threshold.
elizabeth67970
Debounce function
A debounce function delays the execution of a callback until a specified time has passed since the last call, preventing excessive or repeated triggers.
hjackson709
RAII mutex lock guard
This snippet automatically locks a mutex when the guard is created and unlocks it when the guard goes out of scope, ensuring safe and exception‑proof resource management.
daniel07448
Responsive Navigation Bar
This HTML snippet creates a navigation bar that adapts to different screen sizes, making it mobile-friendly without extra CSS frameworks.
michaelstone116
Stream filter collect
Filters a stream based on a predicate and collects the matching elements into a collection.
diane68449
Go HTTP handler
This snippet defines a simple HTTP handler function that responds to requests with a specified status code and message.
bowenjonathan73
yeah scope guards are super handy for things like file descriptors or locks where you can't just use uniqueptr. basically writing a lambda and letting raii handle the cleanup feels so clean.