The Ultimate
Snippet Library.

Implement Basic Full-Text Search with LIKE

Perform simple keyword-based searches across text fields in your database using the SQL LIKE operator and wildcards for flexible matching.

Organize Complex Queries with Common Table Expressions (CTEs)

Improve SQL query readability and structure complex logic by breaking down queries into logical, named temporary result sets using CTEs (WITH clause).

Implement a Robust Content Security Policy in Express

Strengthen web app security against XSS by implementing a Content Security Policy (CSP) using `helmet` middleware in Express.js, controlling allowed content sources.

Configure Secure CORS in an Express.js API

Secure your API by configuring Cross-Origin Resource Sharing (CORS) in an Express.js application, controlling which origins can access your resources to prevent unauthorized requests.

Implement Secure HTTP-Only and SameSite Cookies in Express

Protect user sessions and prevent XSS/CSRF attacks by implementing HTTP-only, secure, and SameSite cookies in your Express.js application for enhanced security.

Automate Secure Website File Synchronization with rsync

Efficiently synchronize local website files to a remote server over SSH using rsync, ensuring data integrity and minimizing transfer time for web deployments.

Monitor Server Disk Usage and Trigger Alerts

Proactively monitor disk space on your web server and send an email alert if usage exceeds a defined threshold, preventing critical storage issues.

Simple Web Server Log File Archiving

Automate the archiving and compression of old web server access logs to save disk space and keep your log directories organized for easier analysis.

Control Web Server Service (Nginx/Apache)

Easily start, stop, restart, or check the status of your Nginx or Apache web server using a simple bash script for streamlined server management.

Manage Recent Items with collections.deque

Utilize Python's collections.deque (double-ended queue) for efficiently adding and removing items from both ends, perfect for managing history, logs, or limited-size caches.

Create Immutable Structured Data with collections.namedtuple

Enhance code readability and maintainability by using collections.namedtuple to define lightweight, immutable object-like structures for database records, API responses, or configuration.

Leverage Sets for Unique Items and Fast Lookups

Master Python sets for managing unique collections, performing fast membership checks, and efficiently removing duplicate elements, crucial for data processing and validation.