Add Chat History Storage and Datasette Integration. closes #1859

[lockmeister]

Summary of Changes: Write Chat History to SQLite:

Implemented functionality to store all chat interactions in an SQLite database for future reference and analysis. New /datasette Command:

Added a command /datasette that enables users to browse the stored chat history via Datasette. This allows users to explore their chat interactions in a structured and interactive way. Inspiration: This feature was inspired by Simon Willison’s LLM tool, which similarly tracks all chat in an SQLite database and provides a simple method to browse the history using Datasette.

Benefits:

• Structured Chat History: Storing chat history in SQLite allows for more organized and structured tracking of conversations. This makes it easier to query and analyze specific conversations. This will enable a methodical approach to experimenting with prompts
• Enhanced User Experience: The /datasette command provides an intuitive way for users to browse and explore their chat history in a user-friendly interface powered by Datasette.
• Data Persistence: SQLite ensures that chat history is saved locally and can be backed up or shared easily, allowing for better continuity and review across sessions.
• Powerful Querying: With SQLite as the backend, users can perform complex queries on their chat history, making it easier to extract insights or search for past interactions.
• Datasette Integration: Leveraging Datasette provides a seamless browsing experience with an easy-to-use web interface, turning chat logs into a browsable dataset for enhanced exploration and analysis.

Screenshot browsing a sample aider chat:

[paul-gauthier]

This is a very specific integration that is not likely to make sense to merge into the main aider releases.

[CLAassistant]

Thank you for your submission! We really appreciate it. Like many open source projects, we ask that you sign our Contributor License Agreement before we can accept your contribution.

---

Lachlan seems not to be a GitHub user. You need a GitHub account to be able to sign the CLA. If you have already a GitHub account, please add the email address used for this commit to your account.
_{You have signed the CLA already but the status is still pending? Let us recheck it.}

[maliayas]

@lockmeister You may be interested in my PR: https://github.com/Aider-AI/aider/pull/4079