irc-repartee 1.2.0

the irc crate – usable, async IRC for Rust. Temporary fork for repartee IRC client (bind_address, immediate flush, rustls fix, flood protection).
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184

SQLite format 3@  	"#	.�*���z
�
3�>g6
�
��
QC���M�o����H%%�Utablememories_ftsmemories_ftsCREATE VIRTUAL TABLE memories_fts USING fts5(
          memory_id UNINDEXED,
          content,
          summary,
          tokenize = 'porter unicode61'
        )s?�indexidx_memories_access_countmemoriesCREATE INDEX idx_memories_access_count ON memories(access_count DESC)�a�tablememoriesmemoriesCREATE TABLE memories (
          id TEXT PRIMARY KEY,
          content TEXT NOT NULL,
          type TEXT NOT NULL CHECK(type IN ('fact', 'entity', 'relationship', 'self')),
          importance REAL NOT NULL CHECK(importance >= 0 AND importance <= 10),
          embedding BLOB,
          created_at INTEGER NOT NULL,
          last_accessed INTEGER NOT NULL,
          expires_at INTEGER,
          metadata TEXT NOT NULL DEFAULT '{}',
          is_deleted INTEGER NOT NULL DEFAULT 0 CHECK(is_deleted IN (0, 1))
        , summary TEXT, access_count INTEGER NOT NULL DEFAULT 0)m=!�	indexidx_provenance_operationprovenanceCREATE INDEX idx_provenance_operation ON provenance(operation)m=!�	indexidx_provenance_timestampprovenanceCREATE INDEX idx_provenance_timestamp ON provenance(timestamp)m=!�	indexidx_provenance_memory_idprovenanceCREATE INDEX idx_provenance_memory_id ON provenance(memory_id)�K!!�atableprovenanceprovenanceCREATE TABLE provenance (
          id TEXT PRIMARY KEY,
          memory_id TEXT NOT NULL,
          operation TEXT NOT NULL CHECK(operation IN ('create', 'update', 'delete', 'access', 'restore')),
          timestamp INTEGER NOT NULL,
          source TEXT NOT NULL,
          context TEXT,
          user_id TEXT,
          changes TEXT,
          FOREIGN KEY (memory_id) REFERENCES memories(id) ON DELETE CASCADE
        )3G!indexsqlite_autoindex_provenance_1provenance�G+�indexidx_memory_entities_entity_idmemory_entitiesCREATE INDEX idx_memory_entities_entity_id ON memory_entities(entity_id)�G+�indexidx_memory_entities_memory_idmemory_entitiesCREATE INDEX idx_memory_entities_memory_id ON memory_entities(memory_id)�++�Etablememory_entitiesmemory_entitiesCREATE TABLE memory_entities (
          memory_id TEXT NOT NULL,
          entity_id TEXT NOT NULL,
          created_at INTEGER NOT NULL,
          PRIMARY KEY (memory_id, entity_id),
          FOREIGN KEY (memory_id) REFERENCES memories(id) ON DELETE CASCADE,
          FOREIGN KEY (entity_id) REFERENCES entities(id) ON DELETE CASCADE
        )=Q+indexsqlite_autoindex_memory_entities_1memory_entitiesU/mindexidx_entities_typeentitiesCREATE INDEX idx_entities_type ON entities(type)U
/mindexidx_entities_nameentitiesCREATE INDEX idx_entities_name ON entities(name)�u
�=tableentitiesentitiesCREATE TABLE entities (
          id TEXT PRIMARY KEY,
          name TEXT NOT NULL UNIQUE,
          type TEXT NOT NULL,
          metadata TEXT NOT NULL DEFAULT '{}',
          created_at INTEGER NOT NULL
        )/Cindexsqlite_autoindex_entities_2entities
/Cindexsqlite_autoindex_entities_1entities�	=�cindexidx_memories_hot_contextmemories
CREATE INDEX idx_memories_hot_context ON memories(last_accessed DESC, importance DESC) WHERE is_deleted = 0h;�indexidx_memories_is_deletedmemories	CREATE INDEX idx_memories_is_deleted ON memories(is_deleted)h;�indexidx_memories_expires_atmemoriesCREATE INDEX idx_memories_expires_at ON memories(expires_at)qA�indexidx_memories_last_accessedmemoriesCREATE INDEX idx_memories_last_accessed ON memories(last_accessed)h;�indexidx_memories_importancememoriesCREATE INDEX idx_memories_importance ON memories(importance)U/mindexidx_memories_typememoriesCREATE INDEX idx_memories_type ON memories(type)/Cindexsqlite_autoindex_memories_1memories�))�]tableschema_versionschema_versionCREATE TABLE schema_version (
      version INTEGER PRIMARY KEY,
      applied_at INTEGER NOT NULL

����	��)��	��)��	��)��























���


ol;�z
�
3�>g6
�
�����}�o��VNs//�tablememories_fts_datamemories_fts_dataCREATE TABLE 'memories_fts_data'(id INTEGER PRIMARY KEY, block BLOB)�H%%�Utablememories_ftsmemories_ftsCREATE VIRTUAL TABLE memories_fts USING fts5(
          memory_id UNINDEXED,
          content,
          summary,
          tokenize = 'porter unicode61'
        )s?�indexidx_memories_access_countmemoriesCREATE INDEX idx_memories_access_count ON memories(access_count DESC)�a�tablememoriesmemoriesCREATE TABLE memories (
          id TEXT PRIMARY KEY,
          content TEXT NOT NULL,
          type TEXT NOT NULL CHECK(type IN ('fact', 'entity', 'relationship', 'self')),
          importance REAL NOT NULL CHECK(importance >= 0 AND importance <= 10),
          embedding BLOB,
          created_at INTEGER NOT NULL,
          last_accessed INTEGER NOT NULL,
          expires_at INTEGER,
          metadata TEXT NOT NULL DEFAULT '{}',
          is_deleted INTEGER NOT NULL DEFAULT 0 CHECK(is_deleted IN (0, 1))
        , summary TEXT, access_count INTEGER NOT NULL DEFAULT 0)
Q0=!�	indexidx_provenance_operationprovenancem=!�	indexidx_provenance_timestampprovenanceCREATE INDEX idx_provenance_timestamp ON provenance(timestamp)m=!�	indexidx_provenance_memory_idprovenanceCREATE INDEX idx_provenance_memory_id ON provenance(memory_id)3G!indexsqlite_autoindex_provenance_1provenance�K!!�atableprovenanceprovenanceCREATE TABLE provenance (
          id TEXT PRIMARY KEY,
          memory_id TEXT NOT NULL,
          operation TEXT NOT NULL CHECK(operation IN ('create', 'update', 'delete', 'access', 'restore')),
          timestamp INTEGER NOT NULL,
          source TEXT NOT NULL,
          context TEXT,
          user_id TEXT,
          changes TEXT,
          FOREIGN KEY (memory_id) REFERENCES memories(id) ON DELETE CASCADE
        )�G+�indexidx_memory_entities_entity_idmemory_entitiesCREATE INDEX idx_memory_entities_entity_id ON memory_entities(entity_id)�G+�indexidx_memory_entities_memory_idmemory_entitiesCREATE INDEX idx_memory_entities_memory_id ON memory_entities(memory_id)=Q+indexsqlite_autoindex_memory_entities_1memory_entities�++�Etablememory_entitiesmemory_entitiesCREATE TABLE memory_entities (
          memory_id TEXT NOT NULL,
          entity_id TEXT NOT NULL,
          created_at INTEGER NOT NULL,
          PRIMARY KEY (memory_id, entity_id),
          FOREIGN KEY (memory_id) REFERENCES memories(id) ON DELETE CASCADE,
          FOREIGN KEY (entity_id) REFERENCES entities(id) ON DELETE CASCADE
        )?Q+indexsqlite_autoindex_memory_entities_1memory_entitiesU/mindexidx_entities_typeentitiesCREATE INDEX idx_entities_type ON entities(type)U
/mindexidx_entities_nameentitiesCREATE INDEX idx_entities_name ON entities(name)�u
�=tableentitiesentitiesCREATE TABLE entities (
          id TEXT PRIMARY KEY,
          name TEXT NOT NULL UNIQUE,
          type TEXT NOT NULL,
          metadata TEXT NOT NULL DEFAULT '{}',
          created_at INTEGER NOT NULL
        )/Cindexsqlite_autoindex_entities_2entities
/Cindexsqlite_autoindex_entities_1entities�	=�cindexidx_memories_hot_contextmemories
CREATE INDEX idx_memories_hot_context ON memories(last_accessed DESC, importance DESC) WHERE is_deleted = 0h;�indexidx_memories_is_deletedmemories	CREATE INDEX idx_memories_is_deleted ON memories(is_deleted)h;�indexidx_memories_expires_atmemoriesCREATE INDEX idx_memories_expires_at ON memories(expires_at)qA�indexidx_memories_last_accessedmemoriesCREATE INDEX idx_memories_last_accessed ON memories(last_accessed)h;�indexidx_memories_importancememoriesCREATE INDEX idx_memories_importance ON memories(importance)U/mindexidx_memories_typememoriesCREATE INDEX idx_memories_type ON memories(type)/Cindexsqlite_autoindex_memories_1memories�))�]tableschema_versionschema_versionCREATE TABLE schema_version (
      version INTEGER PRIMARY KEY,
      applied_at INTEGER NOT NULL
    )

��i
�
)	�	*�1��+7��
Y
U��Z'%%ytablesqlite_stat4sqlite_stat4"CREATE TABLE sqlite_stat4(tbl,idx,neq,nlt,ndlt,sample)K&%%[tablesqlite_stat1sqlite_stat1!CREATE TABLE sqlite_stat1(tbl,idx,stat)�L#//�Kviewv_active_memoriesv_active_memoriesCREATE VIEW v_active_memories AS
    SELECT
      m.*,
      COUNT(me.entity_id) as entity_count
    FROM memories m
    LEFT JOIN memory_entities me ON m.id = me.memory_id
    WHERE m.is_deleted = 0
      AND (m.expires_at IS NULL OR m.expires_at > unixepoch() * 1000)
    GROUP BY m.id�C"5�?triggermemories_fts_restorememoriesCREATE TRIGGER memories_fts_restore
        AFTER UPDATE OF is_deleted ON memories
        WHEN NEW.is_deleted = 0 AND OLD.is_deleted = 1
        BEGIN
          INSERT INTO memories_fts (memory_id, content, summary)
          VALUES (NEW.id, NEW.content, NEW.summary);
        END�q!3�triggermemories_fts_deletememoriesCREATE TRIGGER memories_fts_delete
        AFTER UPDATE OF is_deleted ON memories
        WHEN NEW.is_deleted = 1
        BEGIN
          DELETE FROM memories_fts WHERE memory_id = NEW.id;
        END�m 3�triggermemories_fts_updatememoriesCREATE TRIGGER memories_fts_update
        AFTER UPDATE OF content, summary ON memories
        WHEN NEW.is_deleted = 0
        BEGIN
          DELETE FROM memories_fts WHERE memory_id = NEW.id;
          INSERT INTO memories_fts (memory_id, content, summary)
          VALUES (NEW.id, NEW.content, NEW.summary);
        END�3�striggermemories_fts_insertmemoriesCREATE TRIGGER memories_fts_insert
        AFTER INSERT ON memories
        WHEN NEW.is_deleted = 0
        BEGIN
          INSERT INTO memories_fts (memory_id, content, summary)
          VALUES (NEW.id, NEW.content, NEW.summary);
        ENDu33�tablememories_fts_configmemories_fts_config CREATE TABLE 'memories_fts_config'(k PRIMARY KEY, v) WITHOUT ROWIDy55�tablememories_fts_docsizememories_fts_docsizeCREATE TABLE 'memories_fts_docsize'(id INTEGER PRIMARY KEY, sz BLOB)|55�tablememories_fts_contentmemories_fts_contentCREATE TABLE 'memories_fts_content'(id INTEGER PRIMARY KEY, c0, c1, c2)�--�Atablememories_fts_idxmemories_fts_idxCREATE TABLE 'memories_fts_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWIDs//�tablememories_fts_datamemories_fts_dataCREATE TABLE 'memories_fts_data'(id INTEGER PRIMARY KEY, block BLOB)�H%%�Utablememories_ftsmemories_ftsCREATE VIRTUAL TABLE memories_fts USING fts5(
          memory_id UNINDEXED,
          content,
          summary,
          tokenize = 'porter unicode61'
        )s?�indexidx_memories_access_countmemoriesCREATE INDEX idx_memories_access_count ON memories(access_count DESC)m=!�	indexidx_provenance_operationprovenanceCREATE INDEX idx_provenance_operation ON provenance(operation)5=!�	indexidx_provenance_timestampprovena'�I%33�=viewv_memory_provenancev_memory_provenanceCREATE VIEW v_memory_provenance AS
    SELECT
      m.id,
      m.content,
      m.type,
      p.operation,
      p.timestamp,
      p.source,
      p.context,
      p.user_id
    FROM memories m
    LEFT JOIN provenance p ON m.id = p.memory_id
    ORDER BY m.id, p.timestamp DESC�$$''�viewv_hot_contextv_hot_contextCREATE VIEW v_hot_context AS
    SELECT
      m.*,
      (m.importance * 0.6 +
       CASE
         WHEN (unixepoch() * 1000 - m.last_accessed) < 3600000 THEN 5
         WHEN (unixepoch() * 1000 - m.last_accessed) < 21600000 THEN 4
         WHEN (unixepoch() * 1000 - m.last_accessed) < 86400000 THEN 3
         WHEN (unixepoch() * 1000 - m.last_accessed) < 604800000 THEN 2
         WHEN (unixepoch() * 1000 - m.last_accessed) < 2592000000 THEN 1
         ELSE 0
       END * 0.4) as hot_score
    FROM memories m
    WHERE m.is_deleted = 0
      AND (m.expires_at IS NULL OR m.expires_at > unixepoch() * 1000)
    ORDER BY hot_score DESC


��version
y���y/memories_fts_data2)schema_version3)=memoriesidx_memories_hot_context0 0 0-33memories_fts_configmemories_fts_config1 1
��933memories_fts_configmemories_fts_config100version