Skip to content

User365www/sql-etl-optimization

View on GitHub ↗Related repositories →

# Dormitory ETL Pipeline ETL process for analyzing student dormitory data with PostgreSQL optimization. ## Features - Data extraction from JSON files - PostgreSQL database with optimized indexes - Analytical queries for room statistics - JSON/XML output formats ## Tech Stack - Python 3.9 - PostgreSQL - Docker - SQL optimization

active 2025-10-26 → 2025-11-14 (UTC)

Complete coverage28,375 / 28,375 hourly files (100%) · 2 absent upstream2023-08-15 → 2026-11-09 (UTC)
Events
2
Pushes
0
Pull requests
1
Issues
0
Stars
0
Forks
0

Activity over time

Daily event counts in the loaded window

Line chart, 20 days from 2025-10-26 to 2025-11-14. Pushes: 0 total, peak 0 in a day. Pull requests: 1 total, peak 1 in a day. Issues: 0 total, peak 0 in a day. Comments: 0 total, peak 0 in a day. Stars: 0 total, peak 0 in a day.

  • Pushes
  • Pull requests
  • Issues
  • Comments
  • Stars

Stars, PRs, issues and forks are under-captured in the later part of this window. GH Archive progressively stopped capturing non-push events during 2026 — −95% or worse by the end of the window. Every series here except Pushes fades for that reason, so a decline above reflects the archive, not this repository. Pushes stay reliable throughout, so read them, and the contributor counts derived from them, as the real signal. Data health has the measurements.

Top contributors

Pushes, PRs, issues, reviews and comments — stars and forks excluded, so this is contribution rather than popularity

ContributorContributionsPushesPRsComments
User365www1010

Recent activity

Latest issues, pull requests and releases

  • Pull request#1User365www2025-11-14 08:21

Totals cover only the window loaded into ClickHouse and count events, not GitHub's lifetime totals — 0 stars here means stars gained during the window, not the repo's star count.