The Ultimate
Snippet Library.

SQL Query: Perform UPSERT Operations with INSERT ON CONFLICT

Efficiently insert new records or update existing ones in a single SQL statement using the `INSERT ... ON CONFLICT DO UPDATE` (UPSERT) clause for data synchronization.

SQL Query: Implement Data Pagination with OFFSET and LIMIT

Fetch specific pages of data efficiently from large datasets using SQL's `OFFSET` and `LIMIT` (or `FETCH NEXT`) clauses, essential for web applications.

SQL Query: Aggregate and Filter Data with GROUP BY and HAVING

Summarize data using aggregate functions and `GROUP BY`, then filter these aggregated results with `HAVING` for powerful reporting and analytics.

Securely Processing Webhook Payloads in Node.js

Learn how to set up an Express.js endpoint to receive and securely verify webhook payloads from third-party services using HMAC signatures for integrity.

Fetching Data from GraphQL API using Apollo Client in React

Integrate a GraphQL API into a React application using Apollo Client, demonstrating how to set up the client, define queries, and display data.

Pre-rendering Data from an API with Next.js getStaticProps

Implement server-side pre-rendering with Next.js `getStaticProps` to fetch external API data at build time, improving page performance and SEO.

Securely Uploading Files to AWS S3 from a Node.js Backend

Learn to implement server-side file uploads directly to AWS S3 from a Node.js application, handling security, unique naming, and temporary access URLs.

Converting Addresses to Coordinates with a Third-Party Geocoding API in Python

A Python snippet demonstrating how to use the `requests` library to integrate with a geocoding API, converting street addresses into latitude and longitude coordinates.

Find and Delete Files Older Than N Days

Automate cleanup of old log files or temporary data. This bash script efficiently finds and removes files modified before a specified number of days, freeing up disk space.

Batch Rename Files with a Prefix/Suffix

Easily rename multiple files in a directory by adding a common prefix or suffix. This bash snippet uses a loop and `mv` to apply a consistent naming convention across many files.

Parse CSV File Line by Line

Process CSV data efficiently in bash. This script reads a CSV file line by line, splitting each record by a delimiter, and allows for custom processing of individual fields.

Monitor and Restart a Linux Service

Keep your services running reliably. This bash script checks the status of a specified systemd service and restarts it if it's found to be inactive or failed, ensuring uptime and stability.