📚 A collection of work related to Database Optimization.

This repository focuses on developing and optimizing an e-commerce database. It includes comprehensive database design, advanced query techniques, and performance optimization strategies.

SQLite Enhancer is a Magisk module designed to optimize the performance of SQLite databases on your Android device.

🛍️ Enterprise-scale e-commerce platform with microservices architecture. Handles 2K+ TPS with sub-100ms latency using Redis caching, optimized databases, and Elasticsearch search.

Performance optimization and scaling strategies for modern software systems. Auto-scaling, caching, database optimization.

A Developer’s Journey to Choosing the Right ID Solution

By using different tuning techniques I have been able to increase the query performance of retrieving and searching in millions of records on average 58% faster than before

A comprehensive SQL repository with queries organized by industry sectors, including banking, healthcare, energy, manufacturing, and transportation. Designed to solve real-world problems with optimized and scalable solutions, this repository is ideal for learning and tackling industry-specific challenges.

CityCacheTutorial🔄— учебный проект для оптимизации SQL-запросов с использованием MySQL и Redis. Фокус на ускорении доступа к геоданным.

Un proyecto de diseño, modelado y optimización de una base de datos Oracle SQL para servir una Historia de Condiciones Climatológicas y Ambientales en el Valle de Aburrá

Clean up your WordPress database by managing tables left behind by inactive plugins.

Курсовая работа по проектированию БД с GUI на PyQt6. Комплексная информационная система для управления каталогом мобильных устройств. Реализована нормализованная PostgreSQL база данных (3НФ), Python/PyQt6 интерфейс с полным CRUD-функционалом и система анализа производительности с 95% оптимизацией запросов.

🔄 PostgreSQL MCP Server – AI-Powered PostgreSQL Management & Monitoring. A powerful, AI-integrated PostgreSQL Model Context Protocol (MCP) server for automated database operations, monitoring, security, diagnostics, and optimization. Seamlessly manage PostgreSQL with 237+ tools designed for AI assistants like Claude and ChatGPT.

🎯 Database optimization and sales performance analysis for a fine wine company seeking to improve their data management practices and data maturity level - use of Python and JupyterLab (Business insights, Data collection, Cleaning, EDA, and Data Visualization)

Cursor Pagination for ASP.NET Core is a high-performance, production-ready pagination system for .NET 9 and PostgreSQL, designed for efficient data retrieval in large datasets. It features cursor-based pagination, optimized queries, bulk data operations, and a million-record test set, ensuring fast and scalable API responses.

Executed complex SQL queries to assess patient health metrics, focusing on BMI and glucose levels. Improved data integrity and query performance through schema enhancements and indexing. Created patient views and ranked data by glucose levels for insightful analysis.

Interactive tool for optimizing PostgreSQL tables. Analyze fragmentation statistics and run VACUUM or VACUUM FULL safely via terminal.

In this repository, you will find a collection of basic to advanced T-SQL queries for Microsoft SQL Server, curated for practice and learning purposes