Gists
Share and discover code snippetsLEFT JOIN with Filter
Filters rows from the right table in a LEFT JOIN by applying conditions in the WHERE clause to exclude unmatched records.
oneillh
func ref mut
Borrows a mutable reference to a value, allowing you to modify it through the pattern.
shawn_henry99
Read file as lines
Reads a text file and returns its contents as a table of strings, one per line.
margaretzimmerman
find duplicates by column
This SQL snippet finds rows with duplicate values in a specified column by grouping and counting occurrences.
shawn_henry99
Array map callback
PHP's arraymap applies a callback function to each element of an array, returning a new array with the transformed values.
aellis
print table contents
This snippet prints all key-value pairs in a Lua table for debugging or inspection.
lisaking
Autocomplete input field
An HTML autocomplete input field suggests matching options as a user types, improving form efficiency.
deanna_avila
Lua string interp macro
A Lua macro that substitutes variables directly into string literals for cleaner, more readable code.
tommy_washington
Row Number Over Partition
Splits data into groups and assigns a sequential number to each row within its partition.
aellis
arrayunique and sort
Sorts an array and removes duplicate values in one efficient step.
griffinx
Generate UUID v4
PHP function to generate a random UUID v4 using cryptographically secure random bytes.
john_ramos
extract array unique values
This snippet removes duplicate values from an array, returning only the unique elements.
tommy_washington
Lazy Loading Images
Lazy loading defers image loading until users scroll near them, speeding up initial page load.
mklein
Array destructuring swap
Swaps two variables without a temporary variable by using array destructuring assignment.
michaelsimmons
Ternary operator
The ternary operator provides a shorthand way to write an if-else statement in a single line, evaluating a condition and returning one of two values based on whether it's true or false.
margaretzimmerman
Check if empty
This function returns true when a Lua table or string contains no elements or characters.
Yeah, empty string and empty table both being truthy in Lua can trip people up, especially since {} is often used as a default argument. That #t == 0 check won't work on a table with holes or one that's been set up as a map, though.
jenna
String copy w/ bounds check
Copies a string safely by checking that the destination buffer has enough space before copying.
tommy_washington
Read file lines
Reads all lines from a file into a slice of strings using Go's bufio scanner.
@mmontoya bufio.Scanner handles large files gracefully, but for small files you might prefer os.ReadFile and strings.Split for simplicity.
mklein
Count character frequency
Counts how often each character appears in a string and returns a dictionary of frequencies.
tmedina
Vector lerp function
Returns a vector linearly interpolated between two vectors by a given fraction.
the fraction clamping is the tricky part-one off and you're past the endpoint. we actually added an option to disable clamping for that exact reason.
theresa_davis
debug.traceback
Returns the current call stack as a string for debugging errors and tracing execution flow.
aellis
Flexbox Centering Trick
Use Flexbox to center any element both horizontally and vertically with just three lines of CSS.
estradap
Responsive Image Embed
Embeds images that automatically scale to fit any screen size for responsive layouts.
tommy_washington
SELECT DISTINCT column
This SQL snippet retrieves only unique values from a specified column, removing any duplicate entries.
barrona
constexpr auto value
This C++ snippet declares a constexpr variable named value that is evaluated at compile time for constant expressions.
Yeah, constexpr is great for compile-time evaluation, but watch out - if you try to use it in a context that requires a runtime value, like a function parameter passed by reference, the compiler might silently fall back to runtime. Have you run into cases where that caught you off guard?
estradap
@jessicaosborn just make sure your list isn't so long that autocomplete becomes a laggy mess on mobile.