SCJPC Search Database System
2M+ records searchable through WordPress with PostgreSQL, Elasticsearch, RabbitMQ, S3, and Python behind it.
WordPress-facing search pages for poles and JPA records backed by PostgreSQL, Elasticsearch, RabbitMQ, S3, and Python workflows.
Project type
Backend search and data workflow
Timeline
2023 – 2024
- 2M+ records made searchable through a WordPress-facing experience
- Manual monthly CSV uploads handled through a controlled S3 and queue workflow
- PostgreSQL materialized views and Elasticsearch were used for the jobs they were best suited for
Sanitized case study based on production work. Deeper technical details can be discussed privately where appropriate.