Activity Logging System

[SudiptaPaul-31]

Issue: Activity Logging System

Description
Implement a system to track user activities such as snippet creation, updates, deletions, and wallet connections. Logs should be stored securely for future analytics and auditing purposes, ensuring transparency and accountability.

Acceptance Criteria

• Log snippet creation, updates, deletions (including soft delete/restore)
• Log wallet connections and disconnections
• Store logs in a structured format (e.g., PostgreSQL table)
• Ensure logs are immutable and tamper‑resistant
• Provide API endpoints to query logs for analytics/auditing
• Support pagination and filtering for log retrieval

[EmmyKay0026]

@EmmyKay0026 has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

Hi @SudiptaPaul-31, I’m interested! Building a centralized activity logger is foundational for transforming a project from a simple app into an auditable, enterprise-ready platform. Ensuring that actions like user soft-deletes or wallet connections are stored immutably is a great move for both security and user transparency.

I’ll implement this logging engine by creating a dedicated table structured for fast filter queries. I will hook into your snippet lifecycle and wallet connection handlers to emit audit logs automatically. The query endpoints will come complete with offset or keyset pagination to protect backend performance from day one. Should I build the database layer to strictly throw an exception via Postgres rules if anyone tries to execute an UPDATE or DELETE on the log table, ensuring absolute immutability?

ℹ️ Repo Maintainers: To accept this application, review their application or assign @EmmyKay0026 to this issue.

[drips-wave]

Congratulations, @EmmyKay0026! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 2, 2026.

🧑‍💻 @EmmyKay0026: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊