Code Snippet Library

bash 0

#!/bin/bash
# MongoDB Backup Script with rotation and S3 upload
set -euo pipefail

mongodb backup database automation

sql 0

-- User Analytics: Cohort retention, activity metrics, and growth
-- Works with PostgreSQL 12+

analytics sql reporting window-functions

sql 0

-- Efficient Pagination Patterns for PostgreSQL
-- Avoid OFFSET for large tables; use keyset pagination instead

pagination performance sql optimization

sql 0

-- PostgreSQL Full-Text Search with ranking and highlights

-- Enable required extensions

full-text-search postgresql search indexing

sql 0

-- PostgreSQL Index Optimization Toolkit

-- 1. Find missing indexes (tables with sequential scans)

indexing optimization performance dba

javascript 0

const mongoose = require('mongoose');

const MAX_RETRIES = 5;

mongodb mongoose database connection