This repository presents research on SQL query optimization, exploring how different indexing strategies and PostgreSQL configurations impact query performance. The project, which earned second place at TCCD Research Day, provides insights into improving database efficiency.
Scalable URL shortening service built with Python, Redis & PostgreSQL. Handles 10K+ req/sec using consistent hashing, LRU caching (80% query reduction), and optimized indexing (sub-10ms latency). Deployed on AWS with auto-scaling and load balancing for 99.9% uptime.
Add a description, image, and links to the database-indexing topic page so that developers can more easily learn about it.
To associate your repository with the database-indexing topic, visit your repo's landing page and select "manage topics."