Click Below to Get the Code

Browse, clone, and build from real-world templates powered by Harper.
Podcast
GitHub Logo

Building a Smarter 311 App

Discover how Harper Hack winners Colin and Josh built MELL, an AI-powered community reporting app. Learn about their inspiration, tech stack, UX approach, and how AI streamlines issue reporting for local communities.
Select*
Podcast
Select*

Building a Smarter 311 App

Austin Akers
Head of Developer Relations
at Harper
November 20, 2025
Austin Akers
Head of Developer Relations
at Harper
November 20, 2025
Austin Akers
Head of Developer Relations
at Harper
November 20, 2025
November 20, 2025
Discover how Harper Hack winners Colin and Josh built MELL, an AI-powered community reporting app. Learn about their inspiration, tech stack, UX approach, and how AI streamlines issue reporting for local communities.
Austin Akers
Head of Developer Relations

In this podcast, Austin interviews Colin and Josh, the creators of MELL, a community reporting app that utilizes AI to streamline the process of reporting local issues like potholes and broken streetlights. They discuss the ideation process, their technical backgrounds, the challenges of building the app, and their vision for future improvements. The conversation highlights the importance of user experience and the potential for the app to make a real impact in communities.

Github:

https://github.com/VoxelPenguin/mell

Demo:

https://www.youtube.com/watch?v=M1qu3i8D9Is

In this podcast, Austin interviews Colin and Josh, the creators of MELL, a community reporting app that utilizes AI to streamline the process of reporting local issues like potholes and broken streetlights. They discuss the ideation process, their technical backgrounds, the challenges of building the app, and their vision for future improvements. The conversation highlights the importance of user experience and the potential for the app to make a real impact in communities.

Github:

https://github.com/VoxelPenguin/mell

Demo:

https://www.youtube.com/watch?v=M1qu3i8D9Is

Discover how Harper Hack winners Colin and Josh built MELL, an AI-powered community reporting app. Learn about their inspiration, tech stack, UX approach, and how AI streamlines issue reporting for local communities.

Download

White arrow pointing right
Discover how Harper Hack winners Colin and Josh built MELL, an AI-powered community reporting app. Learn about their inspiration, tech stack, UX approach, and how AI streamlines issue reporting for local communities.

Download

White arrow pointing right
Discover how Harper Hack winners Colin and Josh built MELL, an AI-powered community reporting app. Learn about their inspiration, tech stack, UX approach, and how AI streamlines issue reporting for local communities.

Download

White arrow pointing right

Explore Recent Resources

Comparison
GitHub Logo

Kafka-Centered Stacks vs. a Single Harper Cluster: Where Real-Time Latency Actually Comes From

End-to-end latency in real-time pipelines comes from coordination across systems, not from any single component. Four common workloads, tested two ways, show where multi-hop architectures compound delays and where collapsing storage, messaging, and compute into one runtime changes the math.
Cache
Comparison
End-to-end latency in real-time pipelines comes from coordination across systems, not from any single component. Four common workloads, tested two ways, show where multi-hop architectures compound delays and where collapsing storage, messaging, and compute into one runtime changes the math.
Person with short dark hair and moustache, wearing a colorful plaid shirt, smiling outdoors in a forested mountain landscape.
Aleks Haugom
Senior Manager of GTM
Comparison

Kafka-Centered Stacks vs. a Single Harper Cluster: Where Real-Time Latency Actually Comes From

End-to-end latency in real-time pipelines comes from coordination across systems, not from any single component. Four common workloads, tested two ways, show where multi-hop architectures compound delays and where collapsing storage, messaging, and compute into one runtime changes the math.
Aleks Haugom
Jun 2026
Comparison

Kafka-Centered Stacks vs. a Single Harper Cluster: Where Real-Time Latency Actually Comes From

End-to-end latency in real-time pipelines comes from coordination across systems, not from any single component. Four common workloads, tested two ways, show where multi-hop architectures compound delays and where collapsing storage, messaging, and compute into one runtime changes the math.
Aleks Haugom
Comparison

Kafka-Centered Stacks vs. a Single Harper Cluster: Where Real-Time Latency Actually Comes From

End-to-end latency in real-time pipelines comes from coordination across systems, not from any single component. Four common workloads, tested two ways, show where multi-hop architectures compound delays and where collapsing storage, messaging, and compute into one runtime changes the math.
Aleks Haugom
Tutorial
GitHub Logo

Your API cache is secretly a database

Most teams treat a cache as a black box: URL-keyed blobs with a TTL, useful for speed and nothing else. In Harper, cached data lands in a real table inside the same query engine. That means filtering, joining, real-time subscriptions, and vector search all work against it.
Cache
Tutorial
Most teams treat a cache as a black box: URL-keyed blobs with a TTL, useful for speed and nothing else. In Harper, cached data lands in a real table inside the same query engine. That means filtering, joining, real-time subscriptions, and vector search all work against it.
Person with very short blonde hair wearing a light gray button‑up shirt, standing with arms crossed and smiling outdoors with foliage behind.
Kris Zyp
SVP of Engineering
Tutorial

Your API cache is secretly a database

Most teams treat a cache as a black box: URL-keyed blobs with a TTL, useful for speed and nothing else. In Harper, cached data lands in a real table inside the same query engine. That means filtering, joining, real-time subscriptions, and vector search all work against it.
Kris Zyp
Jun 2026
Tutorial

Your API cache is secretly a database

Most teams treat a cache as a black box: URL-keyed blobs with a TTL, useful for speed and nothing else. In Harper, cached data lands in a real table inside the same query engine. That means filtering, joining, real-time subscriptions, and vector search all work against it.
Kris Zyp
Tutorial

Your API cache is secretly a database

Most teams treat a cache as a black box: URL-keyed blobs with a TTL, useful for speed and nothing else. In Harper, cached data lands in a real table inside the same query engine. That means filtering, joining, real-time subscriptions, and vector search all work against it.
Kris Zyp
Tutorial
GitHub Logo

Introducing Structon: Random-Access Binary Encoding for JavaScript

Deserializing entire records to read one field is a bottleneck at scale. Structon stores objects in a binary format where any field is reachable by byte offset, with lazy getters that never allocate until you access a property. It's the encoding Harper has used internally for years, now a standalone package.
JavaScript
Tutorial
Deserializing entire records to read one field is a bottleneck at scale. Structon stores objects in a binary format where any field is reachable by byte offset, with lazy getters that never allocate until you access a property. It's the encoding Harper has used internally for years, now a standalone package.
Person with very short blonde hair wearing a light gray button‑up shirt, standing with arms crossed and smiling outdoors with foliage behind.
Kris Zyp
SVP of Engineering
Tutorial

Introducing Structon: Random-Access Binary Encoding for JavaScript

Deserializing entire records to read one field is a bottleneck at scale. Structon stores objects in a binary format where any field is reachable by byte offset, with lazy getters that never allocate until you access a property. It's the encoding Harper has used internally for years, now a standalone package.
Kris Zyp
Jun 2026
Tutorial

Introducing Structon: Random-Access Binary Encoding for JavaScript

Deserializing entire records to read one field is a bottleneck at scale. Structon stores objects in a binary format where any field is reachable by byte offset, with lazy getters that never allocate until you access a property. It's the encoding Harper has used internally for years, now a standalone package.
Kris Zyp
Tutorial

Introducing Structon: Random-Access Binary Encoding for JavaScript

Deserializing entire records to read one field is a bottleneck at scale. Structon stores objects in a binary format where any field is reachable by byte offset, with lazy getters that never allocate until you access a property. It's the encoding Harper has used internally for years, now a standalone package.
Kris Zyp