SQLite support is done. AIP dependency is gone. Now I'm adding support for external auth via WASM plugins. @bmann.ca knows what this is for, cuz it was his idea. 😎
#atproto

👀

Wrapping up support for SQLite (removes the Postgres dependency). Next up is built-in auth to remove the AIP dependency.

I dunno if we'll remove the Tap dependency in this build, but we're deffo reducing the footprint. 😎

we got @chadtmiller.com
we got @flo-bit.dev
i got @happyview.dev

who else is making appviews

we can have an appview homies meetup at #AtmosphereConf where we plan our rebellion against the term

v2.0 is cooooooking. Permissions, support for labels, new Lua modules, handle resolution, massive performance improvement for backlinks... plus more.

Issa gunna be tasty. 😎
#atproto

My most recent release post, with a highlighted area that says "Reskeeted by Paul Frazee"

That's right suckers, I'm famous! 😎

P.S. - We're on the brink of HappyView v2. I'm gonna be releasing lots of cool new stuff soon, and it's gonna feel sooooooooo gooooooooooo. 😎

HappyView HappyView is the best way to build an AppView for the AT Protocol. Upload your lexicon schemas and get a fully functional AppView, complete with XRPC endpoints, OAuth, real-time network sync, and hist...

So... you know the drill. Build weird things, make them cool, come back and tell me all about them. 😎

happyview.dev

Smaller stuff: query XRPCs receive auth now, the event logs UI has a lot more detail, and error logging for scripts is way more helpful when something goes wrong.

I took the training wheels off db.raw. It's no longer restricted to read-only queries, so your scripts can write directly when you need to. Create new tables, do weird shit.

Index hooks now run before I store records instead of after. That means your Lua scripts can modify records on the way in, or tell me to skip them entirely. You're in control of what actually gets indexed.

Super useful if you're indexing lexicons from other apps.

Let's start with the big one: Tap events are now processed concurrently. Previously I was handling them one at a time like some kind of animal. We're talking roughly a 1000x increase in indexing performance. Backfills are now 🔥blazingly fast. 🔥

HappyView HappyView is the best way to build an AppView for the AT Protocol. Upload your lexicon schemas and get a fully functional AppView, complete with XRPC endpoints, OAuth, real-time network sync, and hist...

New day, new release. I got some new tricks in v1.12. 🧵
#atproto

happyview.dev

GitHub - gamesgamesgamesgamesgames/happyview: A lexicon-driven AppView for ATProto. A lexicon-driven AppView for ATProto. Contribute to gamesgamesgamesgamesgames/happyview development by creating an account on GitHub.

In v1.11.0, users can now create API keys for things like CI/CD pipelines or anything else that needs to talk to the admin API without an OAuth session. Create and manage them from the settings page in the dashboard.

GitHub - gamesgamesgamesgamesgames/happyview: A lexicon-driven AppView for ATProto. A lexicon-driven AppView for ATProto. Contribute to gamesgamesgamesgamesgames/happyview development by creating an account on GitHub.

Also added did:web support for DID resolution. Small fix, but if you were running into issues resolving non-PLC identities, that's sorted now.
github.com/gamesgamesgamesgamesgames/happyview

I'll probs add some more config around that feature later (disable, limit allowed domain authorities, etc), but it's pretty cool to no longer need to include a special handler for app.bsky.actor.getProfile. 😎

Say a request comes in for com.example.doThing and your instance doesn't have that lexicon. HappyView resolves the domain authority (example.com), makes the XRPC call there, and proxies the result back. Way more useful as general-purpose ATProto infrastructure.

HappyView can now resolve and proxy XRPC calls it doesn't have lexicons for. Instead of rejecting unrecognized methods, it'll resolve the target and proxy the call through.

Release v1.10.0 · gamesgamesgamesgamesgames/happyview 1.10.0 (2026-03-05) Bug Fixes add support for did:web when resolving DIDs (1bc5114) Features resolve and proxy unrecognized XRPCs (ee43d05)

A new release already wuuuuuuuuuuuuut 🧵
github.com/gamesgamesga...

OH, sneak preview: within the next couple of releases, I'll very likely be adding support for writing your scripts in Typescript instead of just Lua. 😉

GitHub - gamesgamesgamesgamesgames/happyview: A lexicon-driven AppView for ATProto. A lexicon-driven AppView for ATProto. Contribute to gamesgamesgamesgamesgames/happyview development by creating an account on GitHub.

Plus the usual batch of bug fixes: Tap reconnections now properly sync collections, backfill edge cases are cleaned up, and a handful of UI fixes.

Curious what y'all wire up with index hooks. Let me know if you build something cool.
github.com/gamesgamesgamesgamesgames/happyview

The dashboard also picked up an event log, so you can keep track of what's happening under the hood. Record indexing, script runs, errors, backfills, and significantly more.

Super helpful for debugging hooks or just keeping an eye on things in general.

@trezy.codes is already using index hooks to push records to Algolia for search. A few lines of Lua and every record indexed by HappyView automatically gets synced over. That's the kind of thing these are built for.

Those hooks can actually do things, too. There's a new http module so your Lua scripts can make outbound requests, plus support for environment variables so you're not hardcoding secrets into your scripts. Sorting support in the db module rounds it out.

The headline feature: Index Hooks.

You can now write Lua scripts that run automatically when records are indexed. Want to transform data, trigger side effects, or filter incoming records? Write a hook and HappyView runs it as records come in from the network.

A doozy indeed. HappyView v1.9.0 is out, and this one's all about making the Lua scripting layer way more powerful. 🧵
#atproto

GitHub - gamesgamesgamesgamesgames/happyview: A lexicon-driven AppView for ATProto. A lexicon-driven AppView for ATProto. Contribute to gamesgamesgamesgamesgames/happyview development by creating an account on GitHub.

All open source under MIT as always:
github.com/gamesgamesgamesgamesgames/happyview

These are the kinds of building blocks that get fun when people start combining them. Curious to see what y'all do with backlinks especially.
#atproto

And the big one for v1.8: advanced queries. db.backlinks() lets you find all records that reference a given AT URI, and db.raw() opens up read-only SQL with parameterized queries and automatic column type mapping. If the built-in query functions aren't enough, you can write straight SQL.

The Lua scripting layer got a bunch of love. There's a new db.search() function for full-text search, and a toarray() utility that fixes the classic Lua "is this an empty object or an empty array" problem when serializing to JSON.