Database/Notification Setup for Tracking Conversation Posting Status

[jkbrooks]

Title: Set Up Database and Notification Logic to Track Conversation Posting Status to Twitter

Description: Implement a system for tracking and updating the status of conversation posting to Twitter. This will involve setting up database fields and a basic notification system to monitor and display the status of conversations.

Requirements:

Database Changes:

Add a field (e.g., twitterPostStatus) to track whether the conversation has been posted, is pending, or failed.
Include any necessary timestamps for when the conversation was posted or an attempt was made.
Backend Implementation:

Update the backend logic to change the status in the database when a conversation is successfully posted or when posting fails.
Implement a retry mechanism to handle rate limits or temporary issues with the Twitter API.
Notification System:

Create a simple notification system to inform users of the current status (e.g., "Pending", "Posted", "Failed").
Display status updates in the UI where conversations are managed.
Error Handling:

Ensure that any errors during posting are logged and the twitterPostStatus is updated accordingly.
Provide details about the reason for failure (e.g., rate limits, invalid handles).
Acceptance Criteria:

The database includes a twitterPostStatus field for conversations.
Backend logic updates the posting status appropriately.
Users receive status updates about the posting process.
The system handles errors and retries when necessary.
Estimated Time: 5-7 hours

Priority: High

[jkbrooks]

IMPT: I'm not sure this is the best way to do this and/or is necessary, feel free to modify as needed