Overview

Reactions (emojis, upvotes, etc.) will be added as a new signed blob type, mirroring the existing comment pattern. Reactions support four target types: documents, comments, blocks, and block-level text fragments.

1. Design Decisions

Storage Model: Individual Signed Blobs

Each reaction action is its own content-addressed signed blob. This follows the same pattern as comments and gives verifiability, p2p sync, and consistent tooling.

Add = create a new Reaction blob (signed by the user)
Remove = create a tombstone Reaction blob with the same TSID (empty emoji + deleted flag in extra_attrs, same as comment deletion)

Target Granularity: Four Levels

A reaction can target any of these:

$\"\"$

Emoji Model: Free-Form

Any Unicode emoji codepoint is valid. No predefined set.

Mutations: Explicit Add/Remove

Separate AddReaction and RemoveReaction RPCs. A user can have multiple distinct emoji reactions on the same target (e.g. both 👍 and ❤️ on the same comment).

Visibility: Inherited from Target

Same as comments — reactions on a private document are visible only to the document owner and their writers (via blob_visibility propagation).

Aggregation: In ActivitySummary

Reaction counts per document/space will be tracked alongside comment counts in ActivitySummary, document_generations, and spaces tables.

Resource Union

Reaction will be added to the Resource union in resources.proto, alongside Document, Comment, and Contact.

2. Proto Definitions

2a. New File: `proto/documents/v3alpha/reactions.proto`

syntax = "proto3";\npackage com.seed.documents.v3alpha;\n\nimport "google/protobuf/empty.proto";\nimport "google/protobuf/timestamp.proto";\n\noption go_package = "seed/backend/genproto/documents/v3alpha;documents";\n\nservice Reactions {\n  rpc AddReaction(AddReactionRequest) returns (Reaction);\n  rpc RemoveReaction(RemoveReactionRequest) returns (google.protobuf.Empty);\n  rpc ListReactions(ListReactionsRequest) returns (ListReactionsResponse);\n  rpc GetReactionAggregates(GetReactionAggregatesRequest) returns (GetReactionAggregatesResponse);\n}\n\nmessage Reaction {\n  string id = 1;\n  string author = 2;\n  string emoji = 3;\n  oneof target {\n    DocumentTarget document_target = 4;\n    CommentTarget comment_target = 5;\n    BlockTarget block_target = 6;\n    BlockFragmentTarget block_fragment_target = 7;\n  }\n  string target_version = 8;\n  google.protobuf.Timestamp create_time = 9;\n  string version = 10;\n  string visibility = 11;\n}\n\nmessage DocumentTarget {\n  string account = 1;\n  string path = 2;\n}\n\nmessage CommentTarget {\n  string comment_id = 1;\n}\n\nmessage BlockTarget {\n  string account = 1;\n  string path = 2;\n  string block_id = 3;\n}\n\nmessage BlockFragmentTarget {\n  string account = 1;\n  string path = 2;\n  string block_id = 3;\n  int32 start = 4;\n  int32 end = 5;\n}\n\nmessage AddReactionRequest {\n  string target_account = 1;\n  string target_path = 2;\n  string target_comment_id = 3;\n  string target_block_id = 4;\n  optional int32 target_fragment_start = 5;\n  optional int32 target_fragment_end = 6;\n  string emoji = 10;\n  string target_version = 11;\n  string signing_key_name = 12;\n  string capability = 13;\n}\n\nmessage RemoveReactionRequest {\n  string id = 1;\n  string signing_key_name = 2;\n}\n\nmessage ListReactionsRequest {\n  string target_account = 1;\n  string target_path = 2;\n  optional string target_comment_id = 3;\n  optional string target_block_id = 4;\n  optional int32 target_fragment_start = 5;\n  optional int32 target_fragment_end = 6;\n  int32 page_size = 10;\n  string page_token = 11;\n}\n\nmessage ListReactionsResponse {\n  repeated Reaction reactions = 1;\n  string next_page_token = 2;\n  map<string, int32> emoji_counts = 3;\n}\n\nmessage GetReactionAggregatesRequest {\n  string target_account = 1;\n  string target_path = 2;\n  optional string target_comment_id = 3;\n  optional string target_block_id = 4;\n  optional int32 target_fragment_start = 5;\n  optional int32 target_fragment_end = 6;\n}\n\nmessage GetReactionAggregatesResponse {\n  map<string, int32> emoji_counts = 1;\n  int32 total_reactions = 2;\n}

2b. Modify `proto/documents/v3alpha/documents.proto`

Add two fields to ActivitySummary (after is_unread):

int32 reaction_count = 6;\ngoogle.protobuf.Timestamp latest_reaction_time = 7;

2c. Modify `proto/documents/v3alpha/resources.proto`

Add to the Resource.oneof kind (using field number 5, since 4 is taken by version):

Reaction reaction = 5;

Add the import:

import "documents/v3alpha/reactions.proto";

3. Backend Domain Model

3a. New File: `backend/blob/blob_reaction.go`

const TypeReaction Type = "Reaction"\n\ntype ReactionTargetType string\nconst (\n    ReactionTargetDocument ReactionTargetType = "document"\n    ReactionTargetComment  ReactionTargetType = "comment"\n    ReactionTargetBlock    ReactionTargetType = "block"\n    ReactionTargetFragment ReactionTargetType = "fragment"\n)\n\ntype ReactionTarget struct {\n    Type          ReactionTargetType\n    Account       string\n    Path          string\n    CommentID     string\n    BlockID       string\n    FragmentStart int32\n    FragmentEnd   int32\n}\n\ntype Reaction struct {\n    BaseBlob\n    ID         TSID\n    Space_     core.Principal  // only set when signer != space owner\n    Path       string\n    Version    []cid.Cid       // target document version at reaction time\n    Emoji      string\n    Target     ReactionTarget\n    Visibility Visibility\n}

Key methods:

NewReaction(kp, id, space, path, version, emoji, target, visibility, ts) (*EncodedReaction, error) — signs and encodes
TSID() TSID — implements ReplacementBlob
Space() core.Principal — convenience for when Space_ is empty

CBOR Registration: Register Reaction{} and ReactionTarget{} types via cbornode.RegisterCborType.

Decoder: Follow the same pattern as comments — validate signature against raw map first, then decode into Reaction struct.

3b. Indexer Logic (`indexReaction`)

Parse target IRI from space + path
Detect tombstones: isTombstone := v.Emoji == ""
Build structuralBlob with:
- Type: TypeReaction
- ExtraAttrs: {emoji, tsid, target_type, target_comment_id?, target_block_id?, target_fragment_start?, target_fragment_end?, visibility?, deleted?}
Set visibility spaces for private reactions (signer + target space)
Link to document resource via resource_links (type: "reaction/target")
Call ictx.SaveBlob(sb)
Update reaction stats using pattern from comments:
- Compute reactionCountDelta() (same logic as commentCountDelta)
- For each matching documentGeneration: update LastReaction, LastReactionTime, ReactionCount
- Update spaceReactionStats on the spaces table
No FTS indexing needed (reactions aren't searchable text)

3c. `reactionCountDelta` Function

Same logic as commentCountDelta in blob_comment.go:

New TSID → +1
Same TSID (edit) → 0
First tombstone for live TSID → -1
Live after tombstone (out-of-order P2P) → +1

Query uses extra_attrs->>'tsid' and extra_attrs->>'deleted' on structural_blobs WHERE type = 'Reaction'.

3d. `spaceReactionStats` Struct

Mirrors spaceCommentStats:

type spaceReactionStats struct {\n    shouldUpdate     bool\n    ID               string\n    LastReaction     int64\n    LastReactionTime int64\n    ReactionCount    int64\n}\n

With load() and save() methods using qLoadSpaceReactionStats, qInsertSpaceReactionStats, qUpdateSpaceReactionStats.

3e. Registration in `blob_reaction.go` (init)

func init() {\n    matcher := makeCBORTypeMatch(TypeReaction)\n    registerIndexer(TypeReaction, decodeFunc, indexReaction)\n}\n

4. Schema Changes

4a. `backend/storage/schema.sql`

spaces table — add after comment_count:

last_reaction INTEGER REFERENCES blobs (id) ON UPDATE CASCADE ON DELETE CASCADE,\nlast_reaction_time INTEGER NOT NULL DEFAULT (0),\nreaction_count INTEGER NOT NULL DEFAULT (0),

document_generations table — add after comment_count:

last_reaction INTEGER REFERENCES blobs (id) ON UPDATE CASCADE ON DELETE CASCADE,\nlast_reaction_time INTEGER NOT NULL DEFAULT (0),\nreaction_count INTEGER NOT NULL DEFAULT (0),

New indexes (foreign key requirement):

CREATE INDEX spaces_by_last_reaction ON spaces (last_reaction) WHERE last_reaction IS NOT NULL;\nCREATE INDEX document_generations_by_last_reaction ON document_generations (last_reaction) WHERE last_reaction IS NOT NULL;

4b. `backend/storage/storage_migrations.go`

New migration (added at top of descending list):

{Version: "2026-05-14.000000", Run: func(_ *Store, conn *sqlite.Conn) error {\n    return sqlitex.ExecScript(conn, sqlfmt(`\n        ALTER TABLE document_generations ADD COLUMN last_reaction INTEGER REFERENCES blobs (id) ON UPDATE CASCADE ON DELETE CASCADE;\n        ALTER TABLE document_generations ADD COLUMN last_reaction_time INTEGER NOT NULL DEFAULT (0);\n        ALTER TABLE document_generations ADD COLUMN reaction_count INTEGER NOT NULL DEFAULT (0);\n\n        ALTER TABLE spaces ADD COLUMN last_reaction INTEGER REFERENCES blobs (id) ON UPDATE CASCADE ON DELETE CASCADE;\n        ALTER TABLE spaces ADD COLUMN last_reaction_time INTEGER NOT NULL DEFAULT (0);\n        ALTER TABLE spaces ADD COLUMN reaction_count INTEGER NOT NULL DEFAULT (0);\n\n        CREATE INDEX IF NOT EXISTS document_generations_by_last_reaction ON document_generations (last_reaction) WHERE last_reaction IS NOT NULL;\n        CREATE INDEX IF NOT EXISTS spaces_by_last_reaction ON spaces (last_reaction) WHERE last_reaction IS NOT NULL;\n    `))\n}},

4c. `backend/storage/schema.gen.go`

Auto-regenerated by ./dev gen //backend/.... Will get new column constants for the six new columns.

5. Modify `backend/blob/blob_ref.go` — documentGeneration Fields

Add three new fields to the documentGeneration struct:

LastReaction     int64\nLastReactionTime int64\nReactionCount    int64

Update fromRow(): Read new columns after CommentCount.

Update save(): Write reaction columns in the sqlitex.Exec call with lastReaction (nullable via maybe.Value), dg.LastReactionTime, dg.ReactionCount.

Update SQL queries to include the three new columns:

qLoadDocumentGeneration
qLoadGenerationsForResource
qInsertDocumentGeneration (add columns + values)
qUpdateDocumentGeneration (add SET clauses, renumber params after 6)

6. Backend API Layer

6a. New File: `backend/api/documents/v3alpha/reactions.go`

AddReaction (follows CreateComment pattern):

Validate signing key, emoji, target version
Parse target type from request fields (document / comment / block / fragment)
Get document visibility from target
Call blob.NewReaction(kp, "", space, path, versionHeads, emoji, target, visibility, ts)
Call srv.idx.Put(ctx, eb)
Return proto via reactionToProto()

RemoveReaction (follows DeleteComment pattern):

Decode reaction record ID
Verify signing key matches reaction author
Load original reaction to get target info
Create tombstone: NewReaction(kp, rid.TSID, space, path, version, "", originalTarget, visibility, ts)
Store and index

ListReactions:

Query structural_blobs WHERE type = 'Reaction' for the target IRI
Use ROW_NUMBER() OVER (PARTITION BY tsid ORDER BY ts DESC) to dedupe versions
Filter out deleted reactions
Restrict visibility if cfg.PublicOnly
Aggregate emoji counts in-app

GetReactionAggregates:

SQL: SELECT emoji, COUNT(*) FROM (...) WHERE rn = 1 AND deleted IS NULL GROUP BY emoji ORDER BY cnt DESC
Return emoji→count map + total

DB mapper (reactionDBMapper): Same pattern as commentDBMapper — decompress blob data, decode CBOR into *blob.Reaction.

SQL queries:

qIterReactions / qIterReactionsPublicOnly — list reactions for a resource
qGetReactionByTSID — lookup by author + TSID
qGetReactionByCID — lookup by CID
qReactionAggregates / qReactionAggregatesPublicOnly — GROUP BY emoji counts

6b. Modify `backend/api/documents/v3alpha/documents.go`

Register ReactionsServer:

documents.RegisterReactionsServer(rpc, srv)

Update baseAccountQuery() — add to SELECT:

"spaces.last_reaction",\n"spaces.last_reaction_time",\n"spaces.reaction_count",

Update accountFromRow() — read new columns and populate:

ActivitySummary: &documents.ActivitySummary{\n    ...\n    ReactionCount:      int32(reactionCount),\n    LatestReactionTime: latestReactionTime,\n}

Update baseListDocumentsQuery() — add to SELECT:

"dg.last_reaction",\n"dg.last_reaction_time",\n"dg.reaction_count",

Update documentInfoFromRow() — read new columns and populate ActivitySummary similarly.

Note: Only reaction_count and latest_reaction_time are in ActivitySummary. There is no latest_reaction_id field in the proto summary (unlike comments which have latest_comment_id). This keeps the reaction aggregation more lightweight.

7. Change Summary (Files Touched)

$\"\"$

8. Testing Strategy

Unit tests: NewReaction() encoding/decoding, tombstone detection, target serialization, reactionCountDelta edge cases
Integration tests: Add + List + Remove cycle, verifying count toggles correctly
Schema tests: Verify new columns exist via schema_test.go
API tests: Following existing comment test patterns

9. Open Question

For block fragment targets (text selections within a block):

Raw offsets (start, end ints): Simpler to implement, but fragile — if the block text changes, the offsets may no longer be meaningful.
Annotation reference (reference an existing Annotation on the block): More stable, but requires the annotation to exist first.

The plan above uses raw offsets. This should be confirmed before implementation.

","enableWebSigning","https://seed.hyper.media","origin","homeMetadata",{"_1569":5263,"_2794":5264,"_2795":50,"_2797":5259,"_3849":24,"_2799":24,"_2800":2801},"Seed Hypermedia","ipfs://bafkreihpk5v5hk3zh33bqhibxo2o3r6xzdlvh2bn7bn5oljawttvshcqaa","originHomeId",{"_1586":5267,"_39":5268,"_1562":5269,"_1556":-5,"_1588":-5,"_1589":-5,"_1590":-5,"_1591":-5},"z6Mko5npVz4Bx9Rf4vkRUf2swvb568SDbhLwStaha3HzgrLS","hm://z6Mko5npVz4Bx9Rf4vkRUf2swvb568SDbhLwStaha3HzgrLS",[],"meta",{"_5272":5273,"_5837":5838},"values",{"_5274":5275,"_5277":5278,"_5279":5280,"_5281":5282,"_5284":5285,"_5286":5287,"_5288":5289,"_5291":5292,"_5293":5294,"_5295":5296,"_5297":5298,"_5299":5300,"_5301":5302,"_5303":5304,"_5305":5306,"_5307":5308,"_5309":5310,"_5311":5312,"_5313":5314,"_5315":5316,"_5317":5318,"_5319":5320,"_5321":5322,"_5323":5324,"_5325":5326,"_5327":5328,"_5329":5330,"_5331":5332,"_5333":5334,"_5335":5336,"_5337":5338,"_5339":5340,"_5341":5342,"_5343":5344,"_5345":5346,"_5347":5348,"_5349":5350,"_5351":5352,"_5353":5354,"_5355":5356,"_5357":5358,"_5359":5360,"_5361":5362,"_5363":5364,"_5365":5366,"_5367":5368,"_5369":5370,"_5371":5372,"_5373":5374,"_5375":5376,"_5377":5378,"_5379":5380,"_5381":5382,"_5383":5384,"_5385":5386,"_5387":5388,"_5389":5390,"_5391":5392,"_5393":5394,"_5395":5396,"_5397":5398,"_5399":5400,"_5401":5402,"_5403":5404,"_5405":5406,"_5407":5408,"_5409":5410,"_5411":5412,"_5413":5414,"_5415":5416,"_5417":5418,"_5419":5420,"_5421":5422,"_5423":5424,"_5425":5426,"_5427":5428,"_5429":5430,"_5431":5432,"_5433":5434,"_5435":5436,"_5437":5438,"_5439":5440,"_5441":5442,"_5443":5444,"_5445":5446,"_5447":5448,"_5449":5450,"_5451":5452,"_5453":5454,"_5455":5456,"_5457":5458,"_5459":5460,"_5461":5462,"_5463":5464,"_5465":5466,"_5467":5468,"_5469":5470,"_5471":5472,"_5473":5474,"_5475":5476,"_5477":5478,"_5479":5480,"_5481":5482,"_5483":5484,"_5485":5486,"_5487":5488,"_5489":5490,"_5491":5492,"_5493":5494,"_5495":5496,"_5497":5498,"_5499":5500,"_5501":5502,"_5503":5504,"_5505":5506,"_5507":5508,"_5509":5510,"_5511":5512,"_5513":5514,"_5515":5516,"_5517":5518,"_5519":5520,"_5521":5522,"_5523":5524,"_5525":5526,"_5527":5528,"_5529":5530,"_5531":5532,"_5533":5534,"_5535":5536,"_5537":5538,"_5539":5540,"_5541":5542,"_5543":5544,"_5545":5546,"_5547":5548,"_5549":5550,"_5551":5552,"_5553":5554,"_5555":5556,"_5557":5558,"_5559":5560,"_5561":5562,"_5563":5564,"_5565":5566,"_5567":5568,"_5569":5570,"_5571":5572,"_5573":5574,"_5575":5576,"_5577":5578,"_5579":5580,"_5581":5582,"_5583":5584,"_5585":5586,"_5587":5588,"_5589":5590,"_5591":5592,"_5593":5594,"_5595":5596,"_5597":5598,"_5599":5600,"_5601":5602,"_5603":5604,"_5605":5606,"_5607":5608,"_5609":5610,"_5611":5612,"_5613":5614,"_5615":5616,"_5617":5618,"_5619":5620,"_5621":5622,"_5623":5624,"_5625":5626,"_5627":5628,"_5629":5630,"_5631":5632,"_5633":5634,"_5635":5636,"_5637":5638,"_5639":5640,"_5641":5642,"_5643":5644,"_5645":5646,"_5647":5648,"_5649":5650,"_5651":5652,"_5653":5654,"_5655":5656,"_5657":5658,"_5659":5660,"_5661":5662,"_5663":5664,"_5665":5666,"_5667":5668,"_5669":5670,"_5671":5672,"_5673":5674,"_5675":5676,"_5677":5678,"_5679":5680,"_5681":5682,"_5683":5684,"_5685":5686,"_5687":5688,"_5689":5690,"_5691":5692,"_5693":5694,"_5695":5696,"_5697":5698,"_5699":5700,"_5701":5702,"_5703":5704,"_5705":5706,"_5707":5708,"_5709":5710,"_5711":5712,"_5713":5714,"_5715":5716,"_5717":5718,"_5719":5720,"_5721":5722,"_5723":5724,"_5725":5726,"_5727":5728,"_5729":5730,"_5731":5732,"_5733":5734,"_5735":5736,"_5737":5738,"_5739":5740,"_5741":5742,"_5743":5744,"_5745":5746,"_5747":5748,"_5749":5750,"_5751":5752,"_5753":5754,"_5755":5756,"_5757":5758,"_5759":5760,"_5761":5762,"_5763":5764,"_5765":5766,"_5767":5768,"_5769":5770,"_5771":5772,"_5773":5774,"_5775":5776,"_5777":5778,"_5779":5780,"_5781":5782,"_5783":5784,"_5785":5786,"_5787":5788,"_5789":5790,"_5791":5792,"_5793":5794,"_5795":5796,"_5797":5798,"_5799":5800,"_5801":5802,"_5803":5804,"_5805":5806,"_5807":5808,"_5809":5810,"_5811":5812,"_5813":5814,"_5815":5816,"_5817":5818,"_5819":5820,"_5821":5822,"_5823":5824,"_5825":5826,"_5827":5828,"_5829":5830,"_5831":5832,"_5833":5834,"_5835":5836},"document.generationInfo.generation",[5276],"bigint","dehydratedState.queries.0.state.data.document.generationInfo.generation",[5276],"dehydratedState.queries.1.state.data.document.generationInfo.generation",[5276],"dehydratedState.queries.1.queryKey.2",[5283],"undefined","dehydratedState.queries.2.state.data.0.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.0.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.0.sortTime",[5290],"Date","dehydratedState.queries.2.state.data.0.activitySummary.latestCommentTime",[5283],"dehydratedState.queries.2.state.data.0.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.0.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.0.redirectInfo",[5283],"dehydratedState.queries.2.state.data.1.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.1.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.1.sortTime",[5290],"dehydratedState.queries.2.state.data.1.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.1.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.1.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.1.redirectInfo",[5283],"dehydratedState.queries.2.state.data.2.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.2.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.2.sortTime",[5290],"dehydratedState.queries.2.state.data.2.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.2.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.2.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.2.redirectInfo",[5283],"dehydratedState.queries.2.state.data.3.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.3.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.3.sortTime",[5290],"dehydratedState.queries.2.state.data.3.activitySummary.latestCommentTime",[5283],"dehydratedState.queries.2.state.data.3.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.3.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.3.redirectInfo",[5283],"dehydratedState.queries.2.state.data.4.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.4.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.4.sortTime",[5290],"dehydratedState.queries.2.state.data.4.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.4.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.4.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.4.redirectInfo",[5283],"dehydratedState.queries.2.state.data.5.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.5.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.5.sortTime",[5290],"dehydratedState.queries.2.state.data.5.activitySummary.latestCommentTime",[5283],"dehydratedState.queries.2.state.data.5.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.5.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.5.redirectInfo",[5283],"dehydratedState.queries.2.state.data.6.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.6.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.6.sortTime",[5290],"dehydratedState.queries.2.state.data.6.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.6.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.6.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.6.redirectInfo",[5283],"dehydratedState.queries.2.state.data.7.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.7.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.7.sortTime",[5290],"dehydratedState.queries.2.state.data.7.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.7.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.7.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.7.redirectInfo",[5283],"dehydratedState.queries.2.state.data.8.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.8.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.8.sortTime",[5290],"dehydratedState.queries.2.state.data.8.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.8.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.8.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.8.redirectInfo",[5283],"dehydratedState.queries.2.state.data.9.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.9.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.9.sortTime",[5290],"dehydratedState.queries.2.state.data.9.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.9.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.9.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.9.redirectInfo",[5283],"dehydratedState.queries.2.state.data.10.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.10.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.10.sortTime",[5290],"dehydratedState.queries.2.state.data.10.activitySummary.latestCommentTime",[5283],"dehydratedState.queries.2.state.data.10.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.10.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.10.redirectInfo",[5283],"dehydratedState.queries.2.state.data.11.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.11.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.11.sortTime",[5290],"dehydratedState.queries.2.state.data.11.activitySummary.latestCommentTime",[5283],"dehydratedState.queries.2.state.data.11.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.11.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.11.redirectInfo",[5283],"dehydratedState.queries.2.state.data.12.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.12.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.12.sortTime",[5290],"dehydratedState.queries.2.state.data.12.activitySummary.latestCommentTime",[5283],"dehydratedState.queries.2.state.data.12.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.12.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.12.redirectInfo",[5283],"dehydratedState.queries.2.state.data.13.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.13.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.13.sortTime",[5290],"dehydratedState.queries.2.state.data.13.activitySummary.latestCommentTime",[5283],"dehydratedState.queries.2.state.data.13.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.13.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.13.redirectInfo",[5283],"dehydratedState.queries.2.state.data.14.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.14.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.14.sortTime",[5290],"dehydratedState.queries.2.state.data.14.activitySummary.latestCommentTime",[5283],"dehydratedState.queries.2.state.data.14.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.14.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.14.redirectInfo",[5283],"dehydratedState.queries.2.state.data.15.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.15.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.15.sortTime",[5290],"dehydratedState.queries.2.state.data.15.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.15.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.15.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.15.redirectInfo",[5283],"dehydratedState.queries.2.state.data.16.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.16.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.16.sortTime",[5290],"dehydratedState.queries.2.state.data.16.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.16.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.16.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.16.redirectInfo",[5283],"dehydratedState.queries.2.state.data.17.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.17.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.17.sortTime",[5290],"dehydratedState.queries.2.state.data.17.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.17.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.17.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.17.redirectInfo",[5283],"dehydratedState.queries.2.state.data.18.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.18.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.18.sortTime",[5290],"dehydratedState.queries.2.state.data.18.activitySummary.latestCommentTime",[5283],"dehydratedState.queries.2.state.data.18.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.18.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.18.redirectInfo",[5283],"dehydratedState.queries.2.state.data.19.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.19.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.19.sortTime",[5290],"dehydratedState.queries.2.state.data.19.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.19.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.19.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.19.redirectInfo",[5283],"dehydratedState.queries.2.state.data.20.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.20.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.20.sortTime",[5290],"dehydratedState.queries.2.state.data.20.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.20.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.20.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.20.redirectInfo",[5283],"dehydratedState.queries.2.state.data.21.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.21.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.21.sortTime",[5290],"dehydratedState.queries.2.state.data.21.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.21.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.21.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.21.redirectInfo",[5283],"dehydratedState.queries.2.state.data.22.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.22.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.22.sortTime",[5290],"dehydratedState.queries.2.state.data.22.activitySummary.latestCommentTime",[5283],"dehydratedState.queries.2.state.data.22.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.22.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.22.redirectInfo",[5283],"dehydratedState.queries.2.state.data.23.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.23.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.23.sortTime",[5290],"dehydratedState.queries.2.state.data.23.activitySummary.latestCommentTime",[5283],"dehydratedState.queries.2.state.data.23.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.23.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.23.redirectInfo",[5283],"dehydratedState.queries.2.state.data.24.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.24.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.24.sortTime",[5290],"dehydratedState.queries.2.state.data.24.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.24.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.24.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.24.redirectInfo",[5283],"dehydratedState.queries.2.state.data.25.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.25.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.25.sortTime",[5290],"dehydratedState.queries.2.state.data.25.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.25.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.25.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.25.redirectInfo",[5283],"dehydratedState.queries.2.state.data.26.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.26.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.26.sortTime",[5290],"dehydratedState.queries.2.state.data.26.activitySummary.latestCommentTime",[5283],"dehydratedState.queries.2.state.data.26.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.26.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.26.redirectInfo",[5283],"dehydratedState.queries.2.state.data.27.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.27.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.27.sortTime",[5290],"dehydratedState.queries.2.state.data.27.activitySummary.latestCommentTime",[5283],"dehydratedState.queries.2.state.data.27.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.27.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.27.redirectInfo",[5283],"dehydratedState.queries.2.state.data.28.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.28.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.28.sortTime",[5290],"dehydratedState.queries.2.state.data.28.activitySummary.latestCommentTime",[5283],"dehydratedState.queries.2.state.data.28.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.28.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.28.redirectInfo",[5283],"dehydratedState.queries.2.state.data.29.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.29.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.29.sortTime",[5290],"dehydratedState.queries.2.state.data.29.activitySummary.latestCommentTime",[5283],"dehydratedState.queries.2.state.data.29.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.29.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.29.redirectInfo",[5283],"dehydratedState.queries.2.state.data.30.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.30.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.30.sortTime",[5290],"dehydratedState.queries.2.state.data.30.activitySummary.latestCommentTime",[5283],"dehydratedState.queries.2.state.data.30.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.30.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.30.redirectInfo",[5283],"dehydratedState.queries.2.state.data.31.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.31.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.31.sortTime",[5290],"dehydratedState.queries.2.state.data.31.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.31.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.31.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.31.redirectInfo",[5283],"dehydratedState.queries.2.state.data.32.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.32.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.32.sortTime",[5290],"dehydratedState.queries.2.state.data.32.activitySummary.latestCommentTime",[5283],"dehydratedState.queries.2.state.data.32.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.32.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.32.redirectInfo",[5283],"dehydratedState.queries.2.state.data.33.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.33.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.33.sortTime",[5290],"dehydratedState.queries.2.state.data.33.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.33.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.33.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.33.redirectInfo",[5283],"dehydratedState.queries.2.state.data.34.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.34.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.34.sortTime",[5290],"dehydratedState.queries.2.state.data.34.activitySummary.latestCommentTime",[5283],"dehydratedState.queries.2.state.data.34.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.34.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.34.redirectInfo",[5283],"dehydratedState.queries.2.state.data.35.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.35.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.35.sortTime",[5290],"dehydratedState.queries.2.state.data.35.activitySummary.latestCommentTime",[5283],"dehydratedState.queries.2.state.data.35.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.35.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.35.redirectInfo",[5283],"dehydratedState.queries.2.state.data.36.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.36.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.36.sortTime",[5290],"dehydratedState.queries.2.state.data.36.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.36.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.36.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.36.redirectInfo",[5283],"dehydratedState.queries.2.state.data.37.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.37.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.37.sortTime",[5290],"dehydratedState.queries.2.state.data.37.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.37.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.37.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.37.redirectInfo",[5283],"dehydratedState.queries.2.state.data.38.createTime.seconds",[5276],"dehydratedState.queries.2.state.data.38.updateTime.seconds",[5276],"dehydratedState.queries.2.state.data.38.sortTime",[5290],"dehydratedState.queries.2.state.data.38.activitySummary.latestCommentTime.seconds",[5276],"dehydratedState.queries.2.state.data.38.activitySummary.latestChangeTime.seconds",[5276],"dehydratedState.queries.2.state.data.38.generationInfo.generation",[5276],"dehydratedState.queries.2.state.data.38.redirectInfo",[5283],"dehydratedState.queries.5.state.data.document.generationInfo.generation",[5276],"dehydratedState.queries.5.queryKey.2",[5283],"dehydratedState.queries.6.state.data.metadata.summary",[5283],"referentialEqualities",{"_5274":5839,"_5279":5840,"_5284":5841,"_5301":5842,"_5315":5843,"_5329":5844,"_5337":5845,"_5343":5846,"_5355":5847,"_5371":5848,"_5385":5849,"_5399":5850,"_5413":5851,"_5425":5852,"_5439":5853,"_5453":5854,"_5467":5855,"_5481":5856,"_5497":5857,"_5511":5858,"_5525":5859,"_5537":5860,"_5553":5861,"_5567":5862,"_5581":5863,"_5595":5864,"_5607":5865,"_5623":5866,"_5637":5867,"_5651":5868,"_5665":5869,"_5677":5870,"_5693":5871,"_5707":5872,"_5721":5873,"_5735":5874,"_5749":5875,"_5761":5876,"_5777":5877,"_5791":5878,"_5805":5879,"_5819":5880},[5277],[5323,5411,5645,5757],[5286,5293],[5307],[5321],[5335],[5831],[5349],[5357,5363],[5377],[5391],[5405],[5419],[5427,5433],[5441,5447],[5455,5461],[5469,5475],[5483,5489],[5503],[5517],[5531],[5539,5545],[5559],[5573],[5587],[5601],[5609,5615],[5629],[5643],[5657],[5671],[5679,5685],[5699],[5713],[5727],[5741],[5755],[5763,5769],[5783],[5797],[5811],[5825],"actionData","errors"]

Overview

1. Design Decisions

Storage Model: Individual Signed Blobs

Target Granularity: Four Levels

Emoji Model: Free-Form

Mutations: Explicit Add/Remove

Visibility: Inherited from Target

Aggregation: In ActivitySummary

Resource Union

2. Proto Definitions

2a. New File: proto/documents/v3alpha/reactions.proto

2b. Modify proto/documents/v3alpha/documents.proto

2c. Modify proto/documents/v3alpha/resources.proto

3. Backend Domain Model

3a. New File: backend/blob/blob_reaction.go

3b. Indexer Logic (indexReaction)

3c. reactionCountDelta Function

3d. spaceReactionStats Struct

3e. Registration in blob_reaction.go (init)