indexes

var AddressableEvent = next()

AddressableEvent stores parameterized replaceable events (kinds 30000-39999) with inline data. Optimized storage for addressable events identified by pubkey+kind+d-tag. Key format enables direct lookup without additional index traversal.

prefix|8 pubkey_hash|2 kind|8 dtag_hash|2 size_uint16|data (variable length, max 384 bytes)

var CompactEvent = next()

CompactEvent stores events using serial references instead of full IDs/pubkeys. This dramatically reduces storage size by replacing: - 32-byte event ID with 5-byte serial - 32-byte author pubkey with 5-byte pubkey serial - 32-byte e-tag values with 5-byte event serials (or full ID if unknown) - 32-byte p-tag values with 5-byte pubkey serials

Format: cmp|5 serial|compact event data (variable length)

var CreatedAt = next()

CreatedAt is an index that allows search for the timestamp on the event.

3 prefix|8 timestamp|5 serial

var Event = next()

Event is the whole event stored in binary format

prefix|5 serial - event in binary format

var EventEventGraph = next()

EventEventGraph creates a bidirectional graph edge between events via e-tags. This stores source_event_serial -> target_event_serial relationships with event kind and direction. Used for thread traversal and finding replies/reactions/reposts to events. Direction: 0=outbound (this event references target)

3 prefix|5 source event serial|5 target event serial|2 kind|1 direction

var EventPubkeyGraph = next()

EventPubkeyGraph creates a bidirectional graph edge between events and pubkeys This stores event_serial -> pubkey_serial relationships with event kind and direction Direction: 0=author, 1=p-tag-out (event references pubkey)

3 prefix|5 event serial|5 pubkey serial|2 kind|1 direction

var Expiration = next()

Expiration

3 prefix|8 timestamp|5 serial

var FullIdPubkey = next()

FullIdPubkey is an index designed to enable sorting and filtering of results found via other indexes, without having to decode the event.

3 prefix|5 serial|32 ID|8 pubkey hash|8 timestamp

var GraphEventEvent = next()

GraphEventEvent creates the reverse edge: target_event_serial -> source_event_serial with kind and direction. This enables querying all events that reference a target event (e.g., all replies to a post). Direction: 1=inbound (target is referenced by source)

3 prefix|5 target event serial|2 kind|1 direction|5 source event serial

var Id = next()

Id contains a truncated 8-byte hash of an event index. This is the secondary key of an event, the primary key is the serial found in the Event.

3 prefix|8 ID hash|5 serial

var Kind = next()

Kind

3 prefix|2 kind|8 timestamp|5 serial

var KindPubkey = next()

KindPubkey

3 prefix|2 kind|8 pubkey hash|8 timestamp|5 serial

var Pubkey = next()

Pubkey is a composite index that allows search by pubkey filtered by timestamp.

3 prefix|8 pubkey hash|8 timestamp|5 serial

var PubkeyEventGraph = next()

PubkeyEventGraph creates the reverse edge: pubkey_serial -> event_serial with event kind and direction This enables querying all events related to a pubkey, optionally filtered by kind and direction Direction: 0=is-author, 2=p-tag-in (pubkey is referenced by event)

3 prefix|5 pubkey serial|2 kind|1 direction|5 event serial

var PubkeySerial = next()

PubkeySerial maps a pubkey hash to its unique serial number

3 prefix|8 pubkey hash|5 serial

var ReplaceableEvent = next()

ReplaceableEvent stores replaceable events (kinds 0,3,10000-19999) with inline data. Optimized storage for metadata events that are frequently replaced. Key format enables direct lookup by pubkey+kind without additional index traversal.

prefix|8 pubkey_hash|2 kind|2 size_uint16|data (variable length, max 384 bytes)

var SerialEventId = next()

SerialEventId maps an event serial to its full 32-byte event ID. This enables reconstruction of the original event ID from compact storage. The event ID is stored as the value (32 bytes), not inline in the key.

3 prefix|5 serial -> 32 byte event ID value

var SerialPubkey = next()

SerialPubkey maps a pubkey serial to the full 32-byte pubkey This stores the full pubkey (32 bytes) as the value, not inline

3 prefix|5 serial -> 32 byte pubkey value

var SmallEvent = next()

SmallEvent stores events <=384 bytes with inline data to avoid double lookup. This is a Reiser4-inspired optimization for small event packing. 384 bytes covers: ID(32) + Pubkey(32) + Sig(64) + basic fields + small content

prefix|5 serial|2 size_uint16|data (variable length, max 384 bytes)

var Tag = next()

Tag allows searching for a tag and filter by timestamp.

3 prefix|1 key letter|8 value hash|8 timestamp|5 serial

var TagKind = next()

TagKind

3 prefix|1 key letter|8 value hash|2 kind|8 timestamp|5 serial

var TagKindPubkey = next()

TagKindPubkey

3 prefix|1 key letter|8 value hash|2 kind|8 pubkey hash|8 bytes timestamp|5 serial

var TagPubkey = next()

TagPubkey allows searching for a pubkey, tag and timestamp.

3 prefix|1 key letter|8 value hash|8 pubkey hash|8 timestamp|5 serial

var Version = next()

Version

3 prefix|4 version

var Word = next()

Word index for tokenized search terms

3 prefix|8 word-hash|5 serial