Multi-master PostgreSQL replication from JSON. Define your nodes and schema, pgconverge generates the SQL, Docker infrastructure, and full-mesh bidirectional replication with automatic conflict resolution
Demonstrating the core skills acquired by making use of Advanced Database Modeling.
Comprehensive study of relational database systems (RDBMS). Focused on schema design, query optimization, data normalization, and integrity constraints for scalable backend architectures.
A simplified, educational multimodal data engine (Graph + Column + Vector) in pure Rust — ideal for database systems courses and self-learners.
A custom relational SQL database engine built from scratch in C++17 — TCP server, REST API, replication, full-text search, window functions, triggers
Collection of SQL patterns, query optimization techniques, and relational schema designs. A comprehensive reference library for database engineering, focus on data integrity, and performant query execution.
This repository is about designing a database model for Global Super Store. This project is the final project of the 7th course "Advanced Data Modeling" of Meta Database Engineer Professional Certificate on Coursera.
AI-Powered SQL Intelligence & Optimization Console that predicts query execution efficiency and ranks formulations using a Neural Network.
Implementation suite for Advanced Database Management Systems (ADBMS). Includes CAP theorem simulations, MongoDB replica sets, indexing profiling, SQL Server query plan optimization, Two-Phase Locking, and Star Schema data mining.
A high-performance attendance database system simulating 100,000+ records. Features a normalized schema, Python data seeding, and a showcase of Query Optimization using Composite Indexes to reduce lookup time by 99%.
Oracle database health check scripts and reports for proactive monitoring and preventive maintenance.
Enterprise-grade School Management System with layered Python/MySQL architecture, role-based access control, and automated academic/financial analytics.
My open-source learning platform, covering a wide range of aspects, from Project Management to Computer and Data Science, Cyber Security and other exciting IT-related topics
This repository contains the capstone project for the Meta Database Engineer Professional Certificate 🎓, showcasing a comprehensive database design 🗃️, SQL implementation 💻, and data analytics 📊 for the fictional restaurant "Little Lemon" 🍋.
SchemaForge Studio | Professional database engineering showcase for Khulisa Commerce. Features 3NF schema design, advanced T-SQL (Stored Procedures, Analytics Views, Window Functions), NoSQL (MongoDB), and CI/CD automation with real-time SQL integration testing.
Self-hosted market-data platform with a partitioned Postgres core, a decoupled Go pipeline (Redpanda/Kafka), an in-browser SQL Playground, HA replication, and full observability.
Towards building my very first storage engine...
System 1: Little Lemon Restaurant Database System (Python client functionalities) | System 2: Global Super Store Data System for data collection, advanced data modeling, reporting, and analytics.
Most people query databases. Very few understand them. This is my attempt to be in the second group.
Add a description, image, and links to the database-engineering topic page so that developers can more easily learn about it.
To associate your repository with the database-engineering topic, visit your repo's landing page and select "manage topics."