Changelog

Riwayat perubahan dan pembaruan aplikasi Database Pemilu 2024

Version 1.16.1

2025-10-27

🐛 Fixed

  • DPRD Provinsi Partai TPS Data Source:

Version 1.16.0

2025-10-24

✨ Added

  • Database Optimization for DPRD Prov Partai TPS Download:
  • Excel Header Format Enhancement:
  • Download Excel DPRD Provinsi per Kabupaten:
  • Download Excel DPRD Kabupaten Partai with Kabupaten Filtering:
  • Download Excel DPD per Kabupaten via Data Per TPS:
  • Download Excel DPRD Prov Partai per Kabupaten via Data Per TPS:
  • Download Excel DPRD Prov Caleg per Kabupaten via Data Per TPS:

🔧 Changed

  • MySQL configuration in `/etc/mysql/mysql.conf.d/mysqld.cnf`:
  • DPRD Provinsi Data Source Migration:

🐛 Fixed

  • Critical performance issue: CPU usage reduced from 181% to ~10%
  • Eliminated slow queries (1000-2000 seconds execution time)
  • System load reduced from 10.90 to 0.76
  • DPRD Provinsi JSON Parsing:
  • DPRD Provinsi Party Data Source:

⚡ Performance

  • Database Indexes:
  • DPRD Provinsi Index Optimization:
  • DPRD Kabupaten Index Optimization:
  • Query Performance:
  • CPU Usage:
  • Memory:

Version 1.15.0

2025-10-22

✨ Added

  • HTTPS Support with Let's Encrypt:
  • Domain Migration:
  • Enhanced Pilpres Download:

Version 1.14.0

2025-10-20

✨ Added

  • Download Excel Data Suara DPR RI per Dapil:

🏗️ Infrastructure

  • Comprehensive database index optimization (40+ indexes)
  • MySQL performance tuning for 8GB RAM systems
  • OPTIMIZATION_REPORT.md with detailed performance metrics

Version 0.1.0

2025-10-14

✨ Added

  • Initial commit with database structure
  • Province data table from `pdpr_wil_pro`
  • Administrative hierarchy tables setup:
  • Candidate tables:

🏗️ Infrastructure

  • Nginx web server configuration with reverse proxy
  • MySQL 8.0+ database server
  • Domain: pileg2024.pemilu.biz.id (HTTPS enabled)
  • Previous domain: datapemilu2024.aplikasiweb.my.id
  • SSL/TLS: Let's Encrypt with auto-renewal
  • Application directory: `/home/polmark/excel-pemilu/datapemilu2024`
  • Systemd service: `pileg2024.service`

📝 v0.1.0 - Initial Release (2025-10-14)

  • Complete Indonesian election data structure
  • 880K+ polling stations (TPS)
  • Province, regency, district, and village level data
  • All candidate data for DPD, DPR RI, DPRD Province, and DPRD Regency
  • Optimized database performance with comprehensive indexing

📝 Performance Optimization (2025-10-14)

  • Fixed CPU overload issue (181% → 10%)
  • Added 40+ strategic indexes
  • Configured MySQL for optimal performance
  • Eliminated all slow queries

Tentang Aplikasi

Database Pemilu 2024 adalah aplikasi web untuk mengelola dan menampilkan data pemilihan umum Indonesia 2024 di semua tingkat administratif.

Dikembangkan oleh aswandi.or.id