Company
Date Published
Author
David Gomes, Lídia Custódio
Word count
2268
Language
English
Hacker News points
None

Summary

The project involved building a serverless application using Cloudflare Workers, SingleStore database, and OpenSky API to display real-time flight data worldwide. The team used Cloudflare Workers' cron trigger feature to automate the process of fetching data from the OpenSky API and uploading it to an S3 bucket. They also created a REST API using Cloudflare Workers that interacted with the SingleStore cluster via the SQL HTTP API, leveraging its connection pooling capabilities. This allowed them to simplify their architecture by removing the need for S3 in the future. The project utilized SingleStore's geospatial capabilities to filter flight data based on country boundaries. Continuous Integration and deployment were set up using Cloudflare Pages and GitHub Actions, allowing the frontend and API to be auto-deployed on every commit to the main branch. The hackathon experience was valuable, with the team learning about SingleStore's capabilities and how to build serverless edge applications. They also highlighted some rough edges in the technology but were pleased with the support from the Cloudflare Workers community.