# A lake of GitHub activity

> Build a lake of GitHub activity with morca: see it running, then build it by handing a coding agent the skills and a prompt, or step by step from pixi and mojoshelf to morca pipelines, a flare console, a local run and a deploy to AWS.

The example is [the census](https://github.com/morca-dev/census): it imports every day of the [GH Archive](https://www.gharchive.org/) into an Iceberg table, finds the Mojo repositories in it, reads each one's git history, and serves a web console that shows how Mojo libraries have grown. Everything in it is Mojo, in one pixi project. An agent built it from a prompt, with only the skills as documentation.

## See it running

The example runs on AWS, deployed with `orca aws` as one image of 71.1 MB compressed, which holds the scheduler, the three pipelines and the console. Both sites are public to read.

[morca's UI orca.mojourney.dev  The three pipelines, their runs and logs, the Dista timeline of a run's tasks, the lineage of each table, and links to the code that made them.](https://orca.mojourney.dev) [Mojo census mojourney.dev  How Mojo libraries grew: their size and age, the Mojo versions and tooling they moved to over time, and a page per repository.](https://mojourney.dev)

## How it fits together

Three morca pipelines write five Iceberg tables. gharchive runs on a schedule; each day it commits starts mojo\_repos, and each batch of new repositories starts mojo\_history. The console reads the last three tables.

## Build it yourself

Two ways, one project, and guides to working on morca itself. Each page stands on its own.

[Let an agent build it  Install the skills for Mojo, magmalake, mojoshelf and AWS, then give a coding agent the prompt that built the census.](https://morca.dev/getting-started/agent) [Step by step  Install pixi and mojoshelf, create the project, read the code the agent wrote, run it locally, and deploy it to AWS. Or clone the example and run it as it is.](https://morca.dev/getting-started/step-by-step) [Develop locally  Change morca, Dista or the census and run the change on a laptop first: the checkouts to lay out, the test suites, a local lake, and testing a library change inside the census before it is released.](https://morca.dev/getting-started/develop) [Maintain and release  The runbook for the owner: pull requests and the flaky tests, releasing morca and Dista, running morca and the census in production, and where things are.](https://morca.dev/getting-started/maintain)

The libraries underneath have guides of their own on [magmalake.dev](https://magmalake.dev/getting-started), including how tins are released.