Home

Welcome to the openFEC wiki!

Database

AWS

• Amazon RDS upgrade process
• How to scale up the staging database

Query Performance

• Analyzing slow queries with AWS and PGBadger
• Notes on Performance Optimization

DB Modeling

• Create Database model diagram

API

• Create an endpoint
• Enabling an expression based sort
• Set up redis and celery on local and test the tasks
• Updating Python
• Deprecation policy

Cloud foundry/cloud.gov

• Managing S3 services in Cloud.gov
• Running cf tasks
• Switch out cf environment variables
• Set up Redis, Celery on local and test the tasks
• Rotate public API keys using task

Elasticsearch service on cloud.gov

• Elasticsearch 7.x.0 management instruction
• Elasticsearch 7.x.0 service and private s3 bucket setup on 'space'
• Elasticsearch 7.x.0 setup and test locally