π A collection of work related to Database Optimization.
-
Updated
Feb 8, 2022
#
database-optimization
Here are 24 public repositories matching this topic...
Language: All
Filter by language
Sort: Most stars
Sort options
This repository focuses on developing and optimizing an e-commerce database. It includes comprehensive database design, advanced query techniques, and performance optimization strategies.
ecommerce query sql database view dbms indexing plsql trigger subquery database-design denormalization stored-procedure clustring databasemanagementsystem database-management-system database-optimization subqueries-and-joins
-
Updated
Oct 30, 2024 - PLpgSQL
SQLite Enhancer is a Magisk module designed to optimize the performance of SQLite databases on your Android device.
-
Updated
Aug 12, 2025
ποΈ Enterprise-scale e-commerce platform with microservices architecture. Handles 2K+ TPS with sub-100ms latency using Redis caching, optimized databases, and Elasticsearch search.
react redis elasticsearch mongodb postgresql e-commerce microservices-architecture enterprise-grade performance-optimization nestjs database-optimization
-
Updated
Jul 25, 2025 - TypeScript
π 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.
postgresql database-management query-optimizer database-monitoring database-security database-optimization devops-automation python-postgresql chatgpt-tools database-admin ai-integration database-performance mcp-server claude-integration ai-database-tools sql-automation database-diagnostics postgres-tools database-health-check postgres-monitoring
-
Updated
Jul 25, 2025 - Python
A comprehensive Model Context Protocol (MCP) server for MySQL databases with 200+ tools for advanced database management, diagnostics, performance analysis, security auditing, and AI-powered database interactions.
mysql python open-source ai mcp database-management diagnostics performance-analysis sql-queries claude database-security database-optimization ai-tools claude-desktop model-context-protocol mcp-server claude-mcp mysql-diagnostics
-
Updated
Aug 18, 2025 - Python
Performance optimization and scaling strategies for modern software systems. Auto-scaling, caching, database optimization.
caching enterprise documentation performance framework cdn optimization best-practices scalability performance-tuning software-development high-availability auto-scaling scaling performance-monitoring production-ready guides load-balancing database-optimization infrastructure-scaling
-
Updated
Jul 7, 2025
-
Updated
Jun 28, 2025
A Developerβs Journey to Choosing the Right ID Solution
-
Updated
Nov 10, 2024 - Java
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
sql nosql data-generation nosql-database mssqlserver database-optimization navica microsoft-sql-server-studio
-
Updated
Jan 27, 2020
ΠΡΡΡΠΎΠ²Π°Ρ ΡΠ°Π±ΠΎΡΠ° ΠΏΠΎ ΠΏΡΠΎΠ΅ΠΊΡΠΈΡΠΎΠ²Π°Π½ΠΈΡ ΠΠ Ρ GUI Π½Π° PyQt6. ΠΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ½Π°Ρ ΠΈΠ½ΡΠΎΡΠΌΠ°ΡΠΈΠΎΠ½Π½Π°Ρ ΡΠΈΡΡΠ΅ΠΌΠ° Π΄Π»Ρ ΡΠΏΡΠ°Π²Π»Π΅Π½ΠΈΡ ΠΊΠ°ΡΠ°Π»ΠΎΠ³ΠΎΠΌ ΠΌΠΎΠ±ΠΈΠ»ΡΠ½ΡΡ ΡΡΡΡΠΎΠΉΡΡΠ². Π Π΅Π°Π»ΠΈΠ·ΠΎΠ²Π°Π½Π° Π½ΠΎΡΠΌΠ°Π»ΠΈΠ·ΠΎΠ²Π°Π½Π½Π°Ρ PostgreSQL Π±Π°Π·Π° Π΄Π°Π½Π½ΡΡ (3ΠΠ€), Python/PyQt6 ΠΈΠ½ΡΠ΅ΡΡΠ΅ΠΉΡ Ρ ΠΏΠΎΠ»Π½ΡΠΌ CRUD-ΡΡΠ½ΠΊΡΠΈΠΎΠ½Π°Π»ΠΎΠΌ ΠΈ ΡΠΈΡΡΠ΅ΠΌΠ° Π°Π½Π°Π»ΠΈΠ·Π° ΠΏΡΠΎΠΈΠ·Π²ΠΎΠ΄ΠΈΡΠ΅Π»ΡΠ½ΠΎΡΡΠΈ Ρ 95% ΠΎΠΏΡΠΈΠΌΠΈΠ·Π°ΡΠΈΠ΅ΠΉ Π·Π°ΠΏΡΠΎΡΠΎΠ².
python sql postgresql data-visualization gui-application desktop-application data-analysis coursework crud-application relational-database mobile-devices database-design database-optimization moscow-polytech pyqt6
-
Updated
Jun 30, 2025 - Python
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Γ‘
-
Updated
Aug 5, 2022
CityCacheTutorialπβ ΡΡΠ΅Π±Π½ΡΠΉ ΠΏΡΠΎΠ΅ΠΊΡ Π΄Π»Ρ ΠΎΠΏΡΠΈΠΌΠΈΠ·Π°ΡΠΈΠΈ SQL-Π·Π°ΠΏΡΠΎΡΠΎΠ² Ρ ΠΈΡΠΏΠΎΠ»ΡΠ·ΠΎΠ²Π°Π½ΠΈΠ΅ΠΌ MySQL ΠΈ Redis. Π€ΠΎΠΊΡΡ Π½Π° ΡΡΠΊΠΎΡΠ΅Π½ΠΈΠΈ Π΄ΠΎΡΡΡΠΏΠ° ΠΊ Π³Π΅ΠΎΠ΄Π°Π½Π½ΡΠΌ.
-
Updated
Aug 31, 2023 - Java
Clean up your WordPress database by managing tables left behind by inactive plugins.
mysql plugin php wordpress wordpress-plugin performance database maintenance database-management admin-tool site-optimization database-optimization table-management database-cleanup inactive-tables safety-features-backup
-
Updated
Mar 25, 2025 - PHP
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.
energy sql database transportation hackerrank healthcare banking data-analysis manufacturing data-management query-optimization inventory-management sql-queries advanced-sql database-optimization operational-analytics industry-specific-sql
-
Updated
Jan 2, 2025
π― 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)
-
Updated
Nov 3, 2023 - Jupyter Notebook
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.
scalability postgresql indexing asp-net-core connection-pooling ef-core large-dataset cursor-pagination database-optimization
-
Updated
Jul 8, 2025 - C#
Interactive tool for optimizing PostgreSQL tables. Analyze fragmentation statistics and run VACUUM or VACUUM FULL safely via terminal.
nodejs fragments cli tuples postgresql database-management database-optimization vaccum fragmentation-analysis vaccum-cleaner dead-tuples interactive-terminal-app
-
Updated
May 5, 2025 - JavaScript
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.
-
Updated
Nov 15, 2024 - PLpgSQL
Improve this page
Add a description, image, and links to the database-optimization topic page so that developers can more easily learn about it.
Add this topic to your repo
To associate your repository with the database-optimization topic, visit your repo's landing page and select "manage topics."