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://fun-in-family.hyper.media","origin","homeMetadata",{"_1569":4999,"_2794":5000,"_2795":5001,"_2797":4995,"_3844":24,"_2799":6},"Fun in Family","ipfs://bafybeien6rrgblcvbeu44ioj255a74xvq4w4o2lyjoqpwgtk2jrvbeq6b4","ipfs://bafybeibercc6b6l4vhef3e2xjxdxz44z2mkxadav4satzzrvzjhdf4dql4","originHomeId",{"_1586":5004,"_39":5005,"_1562":5006,"_1556":-5,"_1588":-5,"_1589":-5,"_1590":-5,"_1591":-5},"z6MkpounmYpAXwsojKHnTWuqCNVs1sJTzRttw1gMfUvCGvY2","hm://z6MkpounmYpAXwsojKHnTWuqCNVs1sJTzRttw1gMfUvCGvY2",[],"meta",{"_5009":5010,"_5574":5575},"values",{"_5011":5012,"_5014":5015,"_5016":5017,"_5018":5019,"_5021":5022,"_5023":5024,"_5025":5026,"_5028":5029,"_5030":5031,"_5032":5033,"_5034":5035,"_5036":5037,"_5038":5039,"_5040":5041,"_5042":5043,"_5044":5045,"_5046":5047,"_5048":5049,"_5050":5051,"_5052":5053,"_5054":5055,"_5056":5057,"_5058":5059,"_5060":5061,"_5062":5063,"_5064":5065,"_5066":5067,"_5068":5069,"_5070":5071,"_5072":5073,"_5074":5075,"_5076":5077,"_5078":5079,"_5080":5081,"_5082":5083,"_5084":5085,"_5086":5087,"_5088":5089,"_5090":5091,"_5092":5093,"_5094":5095,"_5096":5097,"_5098":5099,"_5100":5101,"_5102":5103,"_5104":5105,"_5106":5107,"_5108":5109,"_5110":5111,"_5112":5113,"_5114":5115,"_5116":5117,"_5118":5119,"_5120":5121,"_5122":5123,"_5124":5125,"_5126":5127,"_5128":5129,"_5130":5131,"_5132":5133,"_5134":5135,"_5136":5137,"_5138":5139,"_5140":5141,"_5142":5143,"_5144":5145,"_5146":5147,"_5148":5149,"_5150":5151,"_5152":5153,"_5154":5155,"_5156":5157,"_5158":5159,"_5160":5161,"_5162":5163,"_5164":5165,"_5166":5167,"_5168":5169,"_5170":5171,"_5172":5173,"_5174":5175,"_5176":5177,"_5178":5179,"_5180":5181,"_5182":5183,"_5184":5185,"_5186":5187,"_5188":5189,"_5190":5191,"_5192":5193,"_5194":5195,"_5196":5197,"_5198":5199,"_5200":5201,"_5202":5203,"_5204":5205,"_5206":5207,"_5208":5209,"_5210":5211,"_5212":5213,"_5214":5215,"_5216":5217,"_5218":5219,"_5220":5221,"_5222":5223,"_5224":5225,"_5226":5227,"_5228":5229,"_5230":5231,"_5232":5233,"_5234":5235,"_5236":5237,"_5238":5239,"_5240":5241,"_5242":5243,"_5244":5245,"_5246":5247,"_5248":5249,"_5250":5251,"_5252":5253,"_5254":5255,"_5256":5257,"_5258":5259,"_5260":5261,"_5262":5263,"_5264":5265,"_5266":5267,"_5268":5269,"_5270":5271,"_5272":5273,"_5274":5275,"_5276":5277,"_5278":5279,"_5280":5281,"_5282":5283,"_5284":5285,"_5286":5287,"_5288":5289,"_5290":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},"document.generationInfo.generation",[5013],"bigint","dehydratedState.queries.0.state.data.document.generationInfo.generation",[5013],"dehydratedState.queries.1.state.data.document.generationInfo.generation",[5013],"dehydratedState.queries.1.queryKey.2",[5020],"undefined","dehydratedState.queries.2.state.data.0.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.0.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.0.sortTime",[5027],"Date","dehydratedState.queries.2.state.data.0.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.0.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.0.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.0.redirectInfo",[5020],"dehydratedState.queries.2.state.data.1.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.1.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.1.sortTime",[5027],"dehydratedState.queries.2.state.data.1.activitySummary.latestCommentTime.seconds",[5013],"dehydratedState.queries.2.state.data.1.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.1.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.1.redirectInfo",[5020],"dehydratedState.queries.2.state.data.2.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.2.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.2.sortTime",[5027],"dehydratedState.queries.2.state.data.2.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.2.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.2.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.2.redirectInfo",[5020],"dehydratedState.queries.2.state.data.3.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.3.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.3.sortTime",[5027],"dehydratedState.queries.2.state.data.3.activitySummary.latestCommentTime.seconds",[5013],"dehydratedState.queries.2.state.data.3.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.3.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.3.redirectInfo",[5020],"dehydratedState.queries.2.state.data.4.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.4.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.4.sortTime",[5027],"dehydratedState.queries.2.state.data.4.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.4.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.4.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.4.redirectInfo",[5020],"dehydratedState.queries.2.state.data.5.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.5.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.5.sortTime",[5027],"dehydratedState.queries.2.state.data.5.activitySummary.latestCommentTime.seconds",[5013],"dehydratedState.queries.2.state.data.5.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.5.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.5.redirectInfo",[5020],"dehydratedState.queries.2.state.data.6.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.6.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.6.sortTime",[5027],"dehydratedState.queries.2.state.data.6.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.6.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.6.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.6.redirectInfo",[5020],"dehydratedState.queries.2.state.data.7.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.7.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.7.sortTime",[5027],"dehydratedState.queries.2.state.data.7.activitySummary.latestCommentTime.seconds",[5013],"dehydratedState.queries.2.state.data.7.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.7.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.7.redirectInfo",[5020],"dehydratedState.queries.2.state.data.8.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.8.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.8.sortTime",[5027],"dehydratedState.queries.2.state.data.8.activitySummary.latestCommentTime.seconds",[5013],"dehydratedState.queries.2.state.data.8.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.8.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.8.redirectInfo",[5020],"dehydratedState.queries.2.state.data.9.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.9.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.9.sortTime",[5027],"dehydratedState.queries.2.state.data.9.activitySummary.latestCommentTime.seconds",[5013],"dehydratedState.queries.2.state.data.9.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.9.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.9.redirectInfo",[5020],"dehydratedState.queries.2.state.data.10.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.10.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.10.sortTime",[5027],"dehydratedState.queries.2.state.data.10.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.10.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.10.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.10.redirectInfo",[5020],"dehydratedState.queries.2.state.data.11.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.11.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.11.sortTime",[5027],"dehydratedState.queries.2.state.data.11.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.11.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.11.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.11.redirectInfo",[5020],"dehydratedState.queries.2.state.data.12.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.12.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.12.sortTime",[5027],"dehydratedState.queries.2.state.data.12.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.12.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.12.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.12.redirectInfo",[5020],"dehydratedState.queries.2.state.data.13.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.13.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.13.sortTime",[5027],"dehydratedState.queries.2.state.data.13.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.13.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.13.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.13.redirectInfo",[5020],"dehydratedState.queries.2.state.data.14.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.14.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.14.sortTime",[5027],"dehydratedState.queries.2.state.data.14.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.14.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.14.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.14.redirectInfo",[5020],"dehydratedState.queries.2.state.data.15.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.15.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.15.sortTime",[5027],"dehydratedState.queries.2.state.data.15.activitySummary.latestCommentTime.seconds",[5013],"dehydratedState.queries.2.state.data.15.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.15.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.15.redirectInfo",[5020],"dehydratedState.queries.2.state.data.16.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.16.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.16.sortTime",[5027],"dehydratedState.queries.2.state.data.16.activitySummary.latestCommentTime.seconds",[5013],"dehydratedState.queries.2.state.data.16.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.16.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.16.redirectInfo",[5020],"dehydratedState.queries.2.state.data.17.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.17.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.17.sortTime",[5027],"dehydratedState.queries.2.state.data.17.activitySummary.latestCommentTime.seconds",[5013],"dehydratedState.queries.2.state.data.17.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.17.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.17.redirectInfo",[5020],"dehydratedState.queries.2.state.data.18.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.18.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.18.sortTime",[5027],"dehydratedState.queries.2.state.data.18.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.18.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.18.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.18.redirectInfo",[5020],"dehydratedState.queries.2.state.data.19.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.19.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.19.sortTime",[5027],"dehydratedState.queries.2.state.data.19.activitySummary.latestCommentTime.seconds",[5013],"dehydratedState.queries.2.state.data.19.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.19.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.19.redirectInfo",[5020],"dehydratedState.queries.2.state.data.20.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.20.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.20.sortTime",[5027],"dehydratedState.queries.2.state.data.20.activitySummary.latestCommentTime.seconds",[5013],"dehydratedState.queries.2.state.data.20.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.20.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.20.redirectInfo",[5020],"dehydratedState.queries.2.state.data.21.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.21.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.21.sortTime",[5027],"dehydratedState.queries.2.state.data.21.activitySummary.latestCommentTime.seconds",[5013],"dehydratedState.queries.2.state.data.21.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.21.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.21.redirectInfo",[5020],"dehydratedState.queries.2.state.data.22.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.22.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.22.sortTime",[5027],"dehydratedState.queries.2.state.data.22.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.22.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.22.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.22.redirectInfo",[5020],"dehydratedState.queries.2.state.data.23.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.23.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.23.sortTime",[5027],"dehydratedState.queries.2.state.data.23.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.23.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.23.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.23.redirectInfo",[5020],"dehydratedState.queries.2.state.data.24.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.24.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.24.sortTime",[5027],"dehydratedState.queries.2.state.data.24.activitySummary.latestCommentTime.seconds",[5013],"dehydratedState.queries.2.state.data.24.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.24.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.24.redirectInfo",[5020],"dehydratedState.queries.2.state.data.25.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.25.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.25.sortTime",[5027],"dehydratedState.queries.2.state.data.25.activitySummary.latestCommentTime.seconds",[5013],"dehydratedState.queries.2.state.data.25.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.25.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.25.redirectInfo",[5020],"dehydratedState.queries.2.state.data.26.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.26.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.26.sortTime",[5027],"dehydratedState.queries.2.state.data.26.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.26.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.26.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.26.redirectInfo",[5020],"dehydratedState.queries.2.state.data.27.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.27.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.27.sortTime",[5027],"dehydratedState.queries.2.state.data.27.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.27.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.27.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.27.redirectInfo",[5020],"dehydratedState.queries.2.state.data.28.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.28.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.28.sortTime",[5027],"dehydratedState.queries.2.state.data.28.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.28.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.28.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.28.redirectInfo",[5020],"dehydratedState.queries.2.state.data.29.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.29.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.29.sortTime",[5027],"dehydratedState.queries.2.state.data.29.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.29.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.29.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.29.redirectInfo",[5020],"dehydratedState.queries.2.state.data.30.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.30.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.30.sortTime",[5027],"dehydratedState.queries.2.state.data.30.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.30.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.30.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.30.redirectInfo",[5020],"dehydratedState.queries.2.state.data.31.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.31.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.31.sortTime",[5027],"dehydratedState.queries.2.state.data.31.activitySummary.latestCommentTime.seconds",[5013],"dehydratedState.queries.2.state.data.31.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.31.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.31.redirectInfo",[5020],"dehydratedState.queries.2.state.data.32.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.32.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.32.sortTime",[5027],"dehydratedState.queries.2.state.data.32.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.32.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.32.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.32.redirectInfo",[5020],"dehydratedState.queries.2.state.data.33.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.33.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.33.sortTime",[5027],"dehydratedState.queries.2.state.data.33.activitySummary.latestCommentTime.seconds",[5013],"dehydratedState.queries.2.state.data.33.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.33.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.33.redirectInfo",[5020],"dehydratedState.queries.2.state.data.34.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.34.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.34.sortTime",[5027],"dehydratedState.queries.2.state.data.34.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.34.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.34.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.34.redirectInfo",[5020],"dehydratedState.queries.2.state.data.35.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.35.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.35.sortTime",[5027],"dehydratedState.queries.2.state.data.35.activitySummary.latestCommentTime",[5020],"dehydratedState.queries.2.state.data.35.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.35.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.35.redirectInfo",[5020],"dehydratedState.queries.2.state.data.36.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.36.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.36.sortTime",[5027],"dehydratedState.queries.2.state.data.36.activitySummary.latestCommentTime.seconds",[5013],"dehydratedState.queries.2.state.data.36.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.36.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.36.redirectInfo",[5020],"dehydratedState.queries.2.state.data.37.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.37.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.37.sortTime",[5027],"dehydratedState.queries.2.state.data.37.activitySummary.latestCommentTime.seconds",[5013],"dehydratedState.queries.2.state.data.37.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.37.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.37.redirectInfo",[5020],"dehydratedState.queries.2.state.data.38.createTime.seconds",[5013],"dehydratedState.queries.2.state.data.38.updateTime.seconds",[5013],"dehydratedState.queries.2.state.data.38.sortTime",[5027],"dehydratedState.queries.2.state.data.38.activitySummary.latestCommentTime.seconds",[5013],"dehydratedState.queries.2.state.data.38.activitySummary.latestChangeTime.seconds",[5013],"dehydratedState.queries.2.state.data.38.generationInfo.generation",[5013],"dehydratedState.queries.2.state.data.38.redirectInfo",[5020],"dehydratedState.queries.5.state.data.document.generationInfo.generation",[5013],"dehydratedState.queries.5.queryKey.2",[5020],"dehydratedState.queries.6.state.data.metadata.summary",[5020],"referentialEqualities",{"_5011":5576,"_5016":5577,"_5023":5578,"_5032":5579,"_5038":5580,"_5050":5581,"_5066":5582,"_5080":5583,"_5094":5584,"_5106":5585,"_5122":5586,"_5136":5587,"_5150":5588,"_5162":5589,"_5176":5590,"_5190":5591,"_5204":5592,"_5218":5593,"_5234":5594,"_5248":5595,"_5262":5596,"_5274":5597,"_5290":5598,"_5304":5599,"_5318":5600,"_5332":5601,"_5344":5602,"_5360":5603,"_5374":5604,"_5388":5605,"_5402":5606,"_5414":5607,"_5430":5608,"_5444":5609,"_5458":5610,"_5472":5611,"_5486":5612,"_5498":5613,"_5514":5614,"_5528":5615,"_5542":5616,"_5556":5617},[5014],[5088,5148,5382,5494],[5030],[5568],[5044],[5052,5058],[5072],[5086],[5100],[5108,5114],[5128],[5142],[5156],[5164,5170],[5178,5184],[5192,5198],[5206,5212],[5220,5226],[5240],[5254],[5268],[5276,5282],[5296],[5310],[5324],[5338],[5346,5352],[5366],[5380],[5394],[5408],[5416,5422],[5436],[5450],[5464],[5478],[5492],[5500,5506],[5520],[5534],[5548],[5562],"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)