Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Small-Dollar Fundraising

Small-Dollar Fundraising

Lightning presentation for Boston PostgreSQL Users Group (BPUG)
March 2019

Braulio Carreno

March 25, 2019
Tweet

More Decks by Braulio Carreno

Other Decks in Programming

Transcript

  1. Who I am • Braulio Carreño • amateur DBA •

    SQL since college (Ingres) • 10 years Oracle • 7 years PostgreSQL • Senior Software Engineer ActBlue
  2. ActBlue • founded 2004 • nonprofit organization • independent from

    political organizations • fundraising platform for Democratic campaigns and committees and nonprofit organizations • as of today every democratic campaign running for president is relying on ActBlue
  3. 2018 election cycle • 41 million contributions • $1.6 billion

    • 15 thousand unique campaigns, committees, and organizations
  4. How we use PostgreSQL • everything! • since first version

    2004 from Ruby (Rails in 2005) • process donations and disbursements • compliance • tools for campaigns and nonprofit organizations • why? ACID-compliant (Atomicity, Consistency, Isolation, Durability)
  5. Architecture • 380 GB database • hosting with AWS and

    Rackspace • manage our own PostgreSQL • multiple replicas for performance and redundancy • heavily cached (Fastly) • use Sidekiq for asynchronous processing
  6. Challenges • performance • availability • migrating to Amazon Relational

    DB Service (RDS) • execution plans differ between environments • query planner doesn’t use my index
  7. Join us! ActBlue is always looking for top talent www.actblue.com/jobs

    or email [email protected] Braulio Carreno twitter: @bcarreno blog: http://carreno.me thanks!