Searchable flight logs from Jeffrey Epstein’s plane

Re:Searchable flight logs from Jeffrey Epstein’s plane by simonw on Tuesday November 30, 2021 @06:03PM (#29398554)

I poked around and this is running off a GraphQL endpoint at https://api.epstein.flights/ - I pointed the GraphiQL desktop app at it and the following query returned some interesting data:

    {
      passengers {
        pageInfo {
          count
        }
        edges {
          __typename
          ... on VerifiedPassenger {
            id
            slug
            name
            biography
            wikipedia_link
            flightCount
            image
            histogram {
              month
              count
            }
          }
          ... on LiteralPassenger {
            literal
          }
        }
      }
    }

[ Parent | on HN ]

Re:Searchable flight logs from Jeffrey Epstein’s plane by epsteinflights on Tuesday November 30, 2021 @07:33PM (#29399255)

Yep, it's all GraphQL - I built the site a few years ago to play around with Apollo and AWS's serverless GraphQL offering and then it kind of snowballed from there.

[ Parent | on HN ]

Re:Searchable flight logs from Jeffrey Epstein’s plane by tylergetsay on Wednesday December 01, 2021 @07:36AM (#29403097)

What's this cost to host?

[ Parent | on HN ]

Re:Searchable flight logs from Jeffrey Epstein’s plane by epsteinflights on Wednesday December 01, 2021 @12:09PM (#29406205)

Not much - I made all GraphQL requests GETs and cached them in CloudFront, which has some drawbacks but is pretty effective at keeping costs down because it allows Aurora to scale to zero as long as every request is in cache. The last week has been interesting (60,000 page views) and if things continue at that scale (doubtful) I might be looking at $60/month, mostly in Aurora costs. Most other months of the year had less than 100 page views total, nearly all cached, and it cost under $3 to run for the whole month.

[ Parent | on HN ]

Re:Searchable flight logs from Jeffrey Epstein’s plane by SixDouble5321 on Tuesday November 30, 2021 @09:35PM (#29400022)

AppSync is a hell of a drug.

[ Parent | on HN ]