The Ultimate
Snippet Library.

Implement a Fixed-Size Queue with Deque

Utilize Python's `collections.deque` to create an efficient, fixed-size queue, ideal for maintaining a history of the last N items or implementing a sliding window for data analysis.

Invert Dictionary Keys and Values

Discover how to invert a Python dictionary, swapping its keys and values to create a reverse lookup map, useful for transforming data mappings or creating reverse indices.

Create Immutable Data Records with Namedtuple

Use `collections.namedtuple` in Python to define lightweight, immutable record types, enhancing code readability and data access without the boilerplate of full class definitions.

Manage Node.js Versions with NVM

Learn how to efficiently switch between different Node.js versions using nvm (Node Version Manager) in your development environment for various project requirements.

Run Multiple Dev Servers Concurrently

Discover a simple bash script to simultaneously start multiple web development servers (e.g., frontend, backend, mock API) in the background, streamlining your local development workflow.

Check for Open Ports and Kill Processes

Learn how to use a bash script to check if a specific port is in use and, if desired, automatically identify and terminate the process occupying that port.

Automate Git Branch Cleanup

Streamline your Git workflow with a bash script that automatically deletes merged local branches that are no longer needed, helping to keep your repository tidy.

Dynamic API Endpoint Switching

Configure dynamic API endpoints for development, staging, or production environments using a simple bash script that exports environment variables.

Rank Records within Groups using Window Functions

Learn to use SQL window functions like ROW_NUMBER() and RANK() to assign ranks to records within specific groups, perfect for leaderboards or top-N queries.

Perform an UPSERT Operation with ON DUPLICATE KEY UPDATE (MySQL)

Master the MySQL UPSERT pattern to either insert new rows or update existing ones if a unique key conflict occurs, ensuring data integrity efficiently.

Query Hierarchical Data with Recursive Common Table Expressions

Discover how to traverse and query tree-like or hierarchical data structures (e.g., organizational charts, categories) using powerful SQL Recursive CTEs.

Aggregate Rows into JSON Arrays and Objects (PostgreSQL)

Learn to transform relational data into structured JSON format directly within PostgreSQL using `json_build_object`, `json_agg`, and `json_object_agg`.