This FEP describes how instances are to expose a queryable Online Analytical Processing (OLAP) store of governable events to moderators via Apache Arrow Flight SQL (over gRPC-Web) and Substrait, enabling them to identify events requiring intervention or review actions automatically taken by instance policy. Specific actions and enforcement mechanisms are deliberately out of scope for this proposal.
The key words “MUST”, “MUST NOT”, “REQUIRED”, “SHALL”, “SHALL NOT”, “SHOULD”, “SHOULD NOT”, “RECOMMENDED”, “NOT RECOMMENDED”, “MAY”, and “OPTIONAL” in this document are to be interpreted as described in BCP 14 [RFC2119] [RFC8174] when, and only when, they appear in all capitals, as shown here.
Governable events: Activity Streams and associated instance policy metadata recorded for moderator review and/or auditing
Moderators: Delegated actors authorized to query the governable event store, as determined by the instance’s access control policy
Instances SHALL provide a queryable endpoint for accessing the governable event store to moderators at a sensible location to be determined by the instance.
Instances SHALL provide for the discovery of this endpoint in the endpoints object under the key governableEvents on an authorized moderator’s actor object.
Instances MAY limit the providing of this endpoint to requests with authentication provided, or MAY utilize a different endpoint URL for each moderator, as to obscure discovery from the public. Utilization of these obscurity mechanisms SHALL NOT be sufficient authentication.
{
"@context": [
"https://www.w3.org/ns/activitystreams",
"https://w3id.org/fep/c0a8",
{
"@language": "ja"
}
],
"type": "Person",
"id": "https://kenzoishii.example.com/",
"following": "https://kenzoishii.example.com/following.json",
"followers": "https://kenzoishii.example.com/followers.json",
"liked": "https://kenzoishii.example.com/liked.json",
"inbox": "https://kenzoishii.example.com/inbox.json",
"outbox": "https://kenzoishii.example.com/feed.json",
"preferredUsername": "kenzoishii",
"name": "石井健蔵",
"summary": "この方はただの例です",
"icon": [
"https://kenzoishii.example.com/image/165987aklre4"
],
"endpoints": {
"governableEvents": "https://kenzoishii.example.com/governableEvents"
}
}
Modified from Example 9 in the ActivityPub specification.
Apache Arrow Flight SQL, building on the Apache Arrow Flight RPC framework, SHALL be the sole protocol utilized by the advertised queryable endpoint. The queryable endpoint SHALL support gRPC-Web and SHOULD support gRPC.
Every RPC request to the queryable endpoint SHALL be authenticated via the HTTP Authorization header using an OAuth 2.0 Bearer Token RFC6750 issued for the moderator’s ActivityPub Client-to-Server session. An instance MAY require a specific OAuth 2.0 scope RFC6749 or Rich Authorization Request RFC9396, as defined in a future vocabulary.
Requests lacking valid credentials SHALL be rejected with RPC status UNAUTHENTICATED. Requests authenticated as an actor without moderator authorization or lacking a required scope SHALL be rejected with RPC status UNAUTHORIZED.
Queries SHALL be a Substrait query plan submitted via CommandStatementSubstraitPlan (GetFlightInfoSubstraitPlan and DoGet). Queryable endpoints SHOULD reject raw SQL queries (e.g. CommandStatementQuery) with RPC status UNIMPLEMENTED.
Instances MAY enforce operational limits on query execution.
The governable event store SHALL be immutable by any external actor other than the instance internally, and as such, the queryable endpoint SHALL reject all RPC mutation calls with RPC status UNIMPLEMENTED.
The governable event store SHALL contain a governable_events table consisting of the following columns, with each row reflecting an Activity Stream activity observed by the instance:
| Name | Type | Description |
|---|---|---|
observed_at |
Timestamp(Millisecond, “UTC”) | Time activity was observed |
direction |
'inbound' \| 'outbound' \| 'local' |
Activity boundary. Inbound/outbound for Server-to-Server, Local for Client-to-Server. |
activity_json |
Utf8 (arrow.json) | Full Activity Stream |
source_ip? |
String | Source IP address |
verdicts? |
List<Verdict> |
List of automated rule outcomes for a given activity |
? means a column is nullable for a given row
It is RECOMMENDED that instances include all activities transmitted to the server in the store, including Client-to-Server and Server-to-Server communication.
The Verdict struct SHALL contain the following fields, based on the Open Digital Rights Language (ODRL) vocabulary:
| Name | Type | Description |
|---|---|---|
rule |
String | IRI of odrl:Rule that was triggered |
action |
String | IRI of odrl:Action that was taken |
target |
String | IRI of action target |
applied_at |
Timestamp(Millisecond, “UTC”) | Time action was taken |
CC0 1.0 Universal (CC0 1.0) Public Domain Dedication
To the extent possible under law, the authors of this Fediverse Enhancement Proposal have waived all copyright and related or neighboring rights to this work.