✨ feat(database): added user memory activity#11680
Conversation
|
The latest updates on your projects. Learn more about Vercel for GitHub.
|
TestGru AssignmentSummary
Tip You can |
Reviewer's GuideIntroduces a new user_memories_activities table and associated TypeScript types to store and index rich, vector-searchable user memory activity records linked to users and user_memories. ER diagram for new user_memories_activities tableerDiagram
users {
text id PK
}
user_memories {
varchar255 id PK
text userId FK
}
user_memories_activities {
varchar255 id PK
text userId FK
varchar255 userMemoryId FK
jsonb metadata
text tags
varchar255 activityType
varchar255 status
varchar255 timezone
timestamptz startsAt
timestamptz endsAt
jsonb associatedObjects
jsonb associatedSubjects
jsonb associatedLocations
text notes
text narrative
vector narrativeVector
text feedback
vector feedbackVector
timestamptz capturedAt
timestamptz accessedAt
timestamptz createdAt
timestamptz updatedAt
}
users ||--o{ user_memories : has
users ||--o{ user_memories_activities : has
user_memories ||--o{ user_memories_activities : has
Class diagram for new user memory activity typesclassDiagram
class UserMemoryActivity {
+string id
+string userId
+string userMemoryId
+Record~string, unknown~ metadata
+string[] tags
+string activityType
+string status
+string timezone
+Date startsAt
+Date endsAt
+AssociatedObject[] associatedObjects
+AssociatedSubject[] associatedSubjects
+AssociatedLocation[] associatedLocations
+string notes
+string narrative
+number[] narrativeVector
+string feedback
+number[] feedbackVector
+Date capturedAt
+Date accessedAt
+Date createdAt
+Date updatedAt
}
class UserMemoryActivitiesWithoutVectors {
+string id
+string userId
+string userMemoryId
+Record~string, unknown~ metadata
+string[] tags
+string activityType
+string status
+string timezone
+Date startsAt
+Date endsAt
+AssociatedObject[] associatedObjects
+AssociatedSubject[] associatedSubjects
+AssociatedLocation[] associatedLocations
+string notes
+string narrative
+string feedback
+Date capturedAt
+Date accessedAt
+Date createdAt
+Date updatedAt
}
class NewUserMemoryActivity {
+string id
+string userId
+string userMemoryId
+Record~string, unknown~ metadata
+string[] tags
+string activityType
+string status
+string timezone
+Date startsAt
+Date endsAt
+AssociatedObject[] associatedObjects
+AssociatedSubject[] associatedSubjects
+AssociatedLocation[] associatedLocations
+string notes
+string narrative
+number[] narrativeVector
+string feedback
+number[] feedbackVector
+Date capturedAt
+Date accessedAt
+Date createdAt
+Date updatedAt
}
class AssociatedObject {
+Record~string, unknown~ extra
+string name
+string type
}
class AssociatedSubject {
+Record~string, unknown~ extra
+string name
+string type
}
class AssociatedLocation {
+string address
+string name
+string[] tags
+string type
}
UserMemoryActivity o-- AssociatedObject : associatedObjects
UserMemoryActivity o-- AssociatedSubject : associatedSubjects
UserMemoryActivity o-- AssociatedLocation : associatedLocations
UserMemoryActivitiesWithoutVectors o-- AssociatedObject : associatedObjects
UserMemoryActivitiesWithoutVectors o-- AssociatedSubject : associatedSubjects
UserMemoryActivitiesWithoutVectors o-- AssociatedLocation : associatedLocations
NewUserMemoryActivity o-- AssociatedObject : associatedObjects
NewUserMemoryActivity o-- AssociatedSubject : associatedSubjects
NewUserMemoryActivity o-- AssociatedLocation : associatedLocations
UserMemoryActivitiesWithoutVectors <|-- UserMemoryActivity
NewUserMemoryActivity <|-- UserMemoryActivity
File-Level Changes
Tips and commandsInteracting with Sourcery
Customizing Your ExperienceAccess your dashboard to:
Getting Help
|
a5b2c52 to
e8b6dcf
Compare
There was a problem hiding this comment.
Hey - I've found 1 issue, and left some high level feedback:
- If
user_memories_activitieswill frequently be queried byuserIdand/oruserMemoryId(e.g., fetching activities for a user or a memory), consider adding btree indexes on these foreign key columns to avoid full-table scans as the table grows. - If you expect to filter or search on
tags(and possiblyassociatedLocations.tags), adding appropriate GIN indexes on these jsonb/array fields could significantly improve query performance for those use cases.
Prompt for AI Agents
Please address the comments from this code review:
## Overall Comments
- If `user_memories_activities` will frequently be queried by `userId` and/or `userMemoryId` (e.g., fetching activities for a user or a memory), consider adding btree indexes on these foreign key columns to avoid full-table scans as the table grows.
- If you expect to filter or search on `tags` (and possibly `associatedLocations.tags`), adding appropriate GIN indexes on these jsonb/array fields could significantly improve query performance for those use cases.
## Individual Comments
### Comment 1
<location> `packages/database/src/schemas/userMemories/index.ts:134-135` </location>
<code_context>
+ .$defaultFn(() => idGenerator('memory'))
+ .primaryKey(),
+
+ userId: text('user_id').references(() => users.id, { onDelete: 'cascade' }),
+ userMemoryId: varchar255('user_memory_id').references(() => userMemories.id, {
+ onDelete: 'cascade',
+ }),
</code_context>
<issue_to_address>
**suggestion (performance):** Consider indexing userId / userMemoryId for common access patterns.
If this table is often queried by `user_id` or `user_memory_id`, adding standard btree indexes on these columns will keep those lookups fast as the table grows, since only the vector and status/activity_type indexes exist today.
Suggested implementation:
```typescript
export const userMemoriesActivities = pgTable(
'user_memories_activities',
{
id: varchar255('id')
.$defaultFn(() => idGenerator('memory'))
.primaryKey(),
userId: text('user_id').references(() => users.id, { onDelete: 'cascade' }),
userMemoryId: varchar255('user_memory_id').references(() => userMemories.id, {
onDelete: 'cascade',
}),
metadata: jsonb('metadata').$type<Record<string, unknown>>(),
tags: text('tags').array(),
activityType: varchar255('activity_type').notNull(),
status: varchar255('status').notNull().default('pending'),
timezone: varchar255('timezone'),
startsAt: timestamptz('starts_at'),
endsAt: timestamptz('ends_at'),
},
(table) => ({
userMemoriesActivitiesUserIdIdx: index('user_memories_activities_user_id_idx').on(
table.userId,
),
userMemoriesActivitiesUserMemoryIdIdx: index(
'user_memories_activities_user_memory_id_idx',
).on(table.userMemoryId),
```
1. Ensure `index` is imported from `drizzle-orm/pg-core` in this file (or reused from an existing import), e.g. extend the existing pg-core import to include `index`.
2. If `userMemoriesActivities` already has a third argument defining other indexes (e.g. vector/status/activityType indexes), merge the two by adding the `userMemoriesActivitiesUserIdIdx` and `userMemoriesActivitiesUserMemoryIdIdx` entries into that existing `(table) => ({ ... })` object instead of creating a new one.
</issue_to_address>Help me be more useful! Please click 👍 or 👎 on each comment and I'll use the feedback to improve your reviews.
There was a problem hiding this comment.
💡 Codex Review
Here are some automated review suggestions for this pull request.
Reviewed commit: e8b6dcffbf
ℹ️ About Codex in GitHub
Codex has been enabled to automatically review pull requests in this repo. Reviews are triggered when you
- Open a pull request for review
- Mark a draft as ready
- Comment "@codex review".
If Codex has suggestions, it will comment; otherwise it will react with 👍.
When you sign up for Codex through ChatGPT, Codex can also answer questions or update the PR, like "@codex address that feedback".
Codecov Report✅ All modified and coverable lines are covered by tests. Additional details and impacted files@@ Coverage Diff @@
## next #11680 +/- ##
=======================================
Coverage 74.59% 74.59%
=======================================
Files 1187 1187
Lines 93616 93616
Branches 12412 12412
=======================================
+ Hits 69836 69837 +1
+ Misses 23690 23689 -1
Partials 90 90
Flags with carried forward coverage won't be shown. Click here to find out more.
🚀 New features to boost your workflow:
|
e8b6dcf to
0286a21
Compare
f28a4b1 to
3809570
Compare
6993ca2 to
923a830
Compare
|
❤️ Great PR @nekomeowww ❤️ The growth of the project is inseparable from user feedback and contributions. Thanks for your contribution! If you are interested in the LobeHub developer community, please join our discord and then DM @arvinxx or @canisminor1990. They will invite you to our private developer channel. We are discussing lobe-chat development and sharing AI newsletters from around the world.
Original Content❤️ Great PR @nekomeowww ❤️ The growth of project is inseparable from user feedback and contribution, thanks for your contribution! If you are interesting with the lobehub developer community, please join our discord and then dm @arvinxx or @canisminor1990. They will invite you to our private developer channel. We are talking about the lobe-chat development or sharing ai newsletter around the world. |
## [Version 2.0.0-next.335](v2.0.0-next.334...v2.0.0-next.335) <sup>Released on **2026-01-22**</sup> #### ✨ Features - **database**: Added user memory activity. <br/> <details> <summary><kbd>Improvements and Fixes</kbd></summary> #### What's improved * **database**: Added user memory activity, closes [#11680](#11680) ([0160fbd](0160fbd)) </details> <div align="right"> [](#readme-top) </div>
|
🎉 This PR is included in version 2.0.0-next.335 🎉 The release is available on: Your semantic-release bot 📦🚀 |
## [Version 1.153.0](v1.152.0...v1.153.0) <sup>Released on **2026-01-23**</sup> #### ♻ Code Refactoring - **auth**: Remove NEXT_PUBLIC_AUTH_URL env variable. - **model-select**: Migrate FunctionCallingModelSelect to LobeSelect. - **ModelSwitchPanel**: Migrate from Popover to DropdownMenu with virtual scrolling. - **userMemories**: Removed un-used code. - **misc**: Improve memory data with experience and identity, move vercel-react-best-practices skills to .agents directory. #### ✨ Features - **database**: Added user memory activity. - **desktop**: Add legacy local database detection and migration guidance. - **misc**: Add platform-aware download client menu option, add server version check for desktop app, remove Clerk authentication code, skill setting page and skill store, support agent group unpublish agents, support client tasks mode, update the sandbox preinstall libs in sys role. #### 🐛 Bug Fixes - **copilot**: Pass correct scope when creating new session in PageEditor. - **desktop**: Gracefully handle missing update manifest 404 errors. - **model-runtime**: Filter unsupported image types (SVG) before sending to vision models. - **pdf**: Upgrade pdfjs-dist and react-pdf to v5.x. - **sidebar-drawer**: Fix drawer positioning and title style. - **misc**: Fix group broadcast trigger tool use, fix local system tools, fix memory schema, fix multi agent tasks issue, fix multi tasks no summary issue, fix scope issue, fix tool argument scape and improve multi task run, fixed the sandbox tools call when error should use right callback, improve e2e server and complete i18n resources, slove the agent group editor not focus in editdata area, slove the agents header switch agents the lobeAI not show problem, sloved the old removeSessionTopics not work, TypewriterEffect not refreshing on language change, updata cron job ui & fixed commnuity pagenation goto error, update the agentbuilder tools not always use humanIntervention. #### 💄 Styles - **misc**: Improve auto scroll and group profile, update og, update share style. <br/> <details> <summary><kbd>Improvements and Fixes</kbd></summary> #### Code refactoring * **auth**: Remove NEXT_PUBLIC_AUTH_URL env variable, closes [lobehub#11658](https://github.com/jaworldwideorg/OneJA-Bot/issues/11658) ([c0f9875](c0f9875)) * **model-select**: Migrate FunctionCallingModelSelect to LobeSelect, closes [lobehub#11664](https://github.com/jaworldwideorg/OneJA-Bot/issues/11664) ([ad51305](ad51305)) * **ModelSwitchPanel**: Migrate from Popover to DropdownMenu with virtual scrolling, closes [lobehub#11663](https://github.com/jaworldwideorg/OneJA-Bot/issues/11663) ([c9d9dff](c9d9dff)) * **userMemories**: Removed un-used code, closes [lobehub#11713](https://github.com/jaworldwideorg/OneJA-Bot/issues/11713) ([89750fc](89750fc)) * **misc**: Improve memory data with experience and identity, closes [lobehub#11717](https://github.com/jaworldwideorg/OneJA-Bot/issues/11717) ([bdb3eb4](bdb3eb4)) * **misc**: Move vercel-react-best-practices skills to .agents directory, closes [lobehub#11703](https://github.com/jaworldwideorg/OneJA-Bot/issues/11703) ([6df7731](6df7731)) #### What's improved * **database**: Added user memory activity, closes [lobehub#11680](https://github.com/jaworldwideorg/OneJA-Bot/issues/11680) ([0160fbd](0160fbd)) * **desktop**: Add legacy local database detection and migration guidance, closes [lobehub#11682](https://github.com/jaworldwideorg/OneJA-Bot/issues/11682) ([5664b84](5664b84)) * **misc**: Add platform-aware download client menu option, closes [lobehub#11676](https://github.com/jaworldwideorg/OneJA-Bot/issues/11676) ([55abddc](55abddc)) * **misc**: Add server version check for desktop app, closes [lobehub#11710](https://github.com/jaworldwideorg/OneJA-Bot/issues/11710) ([0cf2723](0cf2723)) * **misc**: Remove Clerk authentication code, closes [lobehub#11711](https://github.com/jaworldwideorg/OneJA-Bot/issues/11711) ([395595a](395595a)) * **misc**: Skill setting page and skill store, closes [lobehub#11665](https://github.com/jaworldwideorg/OneJA-Bot/issues/11665) ([d8c0c26](d8c0c26)) * **misc**: Support agent group unpublish agents, closes [lobehub#11687](https://github.com/jaworldwideorg/OneJA-Bot/issues/11687) ([4e060be](4e060be)) * **misc**: Support client tasks mode, closes [lobehub#11666](https://github.com/jaworldwideorg/OneJA-Bot/issues/11666) ([98cf57b](98cf57b)) * **misc**: Update the sandbox preinstall libs in sys role, closes [lobehub#11688](https://github.com/jaworldwideorg/OneJA-Bot/issues/11688) ([404c577](404c577)) #### What's fixed * **copilot**: Pass correct scope when creating new session in PageEditor, closes [lobehub#11714](https://github.com/jaworldwideorg/OneJA-Bot/issues/11714) ([0259270](0259270)) * **desktop**: Gracefully handle missing update manifest 404 errors, closes [lobehub#11625](https://github.com/jaworldwideorg/OneJA-Bot/issues/11625) ([13e95b9](13e95b9)) * **model-runtime**: Filter unsupported image types (SVG) before sending to vision models, closes [lobehub#11698](https://github.com/jaworldwideorg/OneJA-Bot/issues/11698) ([c0c99a7](c0c99a7)) * **pdf**: Upgrade pdfjs-dist and react-pdf to v5.x, closes [lobehub#11686](https://github.com/jaworldwideorg/OneJA-Bot/issues/11686) ([2b620df](2b620df)) * **sidebar-drawer**: Fix drawer positioning and title style, closes [lobehub#11655](https://github.com/jaworldwideorg/OneJA-Bot/issues/11655) ([cf5320e](cf5320e)) * **misc**: Fix group broadcast trigger tool use, closes [lobehub#11646](https://github.com/jaworldwideorg/OneJA-Bot/issues/11646) ([831a9b3](831a9b3)) * **misc**: Fix local system tools, closes [lobehub#11702](https://github.com/jaworldwideorg/OneJA-Bot/issues/11702) ([6548fc7](6548fc7)) * **misc**: Fix memory schema, closes [lobehub#11645](https://github.com/jaworldwideorg/OneJA-Bot/issues/11645) ([3baf780](3baf780)) * **misc**: Fix multi agent tasks issue, closes [lobehub#11672](https://github.com/jaworldwideorg/OneJA-Bot/issues/11672) ([9de773b](9de773b)) * **misc**: Fix multi tasks no summary issue, closes [lobehub#11685](https://github.com/jaworldwideorg/OneJA-Bot/issues/11685) ([26ce317](26ce317)) * **misc**: Fix scope issue, closes [lobehub#11719](https://github.com/jaworldwideorg/OneJA-Bot/issues/11719) ([17adde8](17adde8)) * **misc**: Fix tool argument scape and improve multi task run, closes [lobehub#11691](https://github.com/jaworldwideorg/OneJA-Bot/issues/11691) ([b13bb8a](b13bb8a)) * **misc**: Fixed the sandbox tools call when error should use right callback, closes [lobehub#11721](https://github.com/jaworldwideorg/OneJA-Bot/issues/11721) ([e8fce68](e8fce68)) * **misc**: Improve e2e server and complete i18n resources, closes [lobehub#11678](https://github.com/jaworldwideorg/OneJA-Bot/issues/11678) ([d450dd9](d450dd9)) * **misc**: Slove the agent group editor not focus in editdata area, closes [lobehub#11677](https://github.com/jaworldwideorg/OneJA-Bot/issues/11677) ([9ac84e6](9ac84e6)) * **misc**: Slove the agents header switch agents the lobeAI not show problem, closes [lobehub#11726](https://github.com/jaworldwideorg/OneJA-Bot/issues/11726) ([f45f508](f45f508)) * **misc**: Sloved the old removeSessionTopics not work, closes [lobehub#11671](https://github.com/jaworldwideorg/OneJA-Bot/issues/11671) ([06d41e5](06d41e5)) * **misc**: TypewriterEffect not refreshing on language change, closes [lobehub#11657](https://github.com/jaworldwideorg/OneJA-Bot/issues/11657) ([ba30f46](ba30f46)) * **misc**: Updata cron job ui & fixed commnuity pagenation goto error, closes [lobehub#11700](https://github.com/jaworldwideorg/OneJA-Bot/issues/11700) ([42ad2a0](42ad2a0)) * **misc**: Update the agentbuilder tools not always use humanIntervention, closes [lobehub#11696](https://github.com/jaworldwideorg/OneJA-Bot/issues/11696) ([0d3017b](0d3017b)) #### Styles * **misc**: Improve auto scroll and group profile, closes [lobehub#11725](https://github.com/jaworldwideorg/OneJA-Bot/issues/11725) ([550acc2](550acc2)) * **misc**: Update og, closes [lobehub#11709](https://github.com/jaworldwideorg/OneJA-Bot/issues/11709) ([01cf4e4](01cf4e4)) * **misc**: Update share style, closes [lobehub#11716](https://github.com/jaworldwideorg/OneJA-Bot/issues/11716) ([3c70dfa](3c70dfa)) </details> <div align="right"> [](#readme-top) </div>
💻 Change Type
🔗 Related Issue
Related to #10464
🔀 Description of Change
🧪 How to Test
📸 Screenshots / Videos
📝 Additional Information
Summary by Sourcery
Add a new database table and schema for tracking user memory activities, including metadata, associations, and vector-searchable narrative and feedback fields.
New Features:
Enhancements: