Command for browsing captured logs

[simonw]

Best way to do this will be with Datasette or sqlite-utils but it would be neat to have a basic history command built into llm itself.

[simonw]

Some ideas:

• llm log
• llm logs
• llm history

I think I like llm log better.

What should it do? The problem is that the outputs can be pretty long, but those are often what you want to see.

I mean the coolest thing here would be if it was an interactive interface using Textual...

[simonw]

I did a very rough prototype in Textual, but it's going to need a lot more work to be useful:

+from .ui import LogApp

+@cli.command()
+def logs():
+    path = get_log_db_path()
+    if not os.path.exists(path):
+        raise click.ClickException("No log database found at %s" % path)
+    app = LogApp(path)
+    app.run()

And in ui.py:

import sqlite_utils
from textual.app import App, ComposeResult
from textual.widgets import DataTable


class LogApp(App):
    def __init__(self, path):
        self.db = sqlite_utils.Database(path)
        super().__init__()

    def compose(self) -> ComposeResult:
        yield DataTable()

    def on_mount(self) -> None:
        table = self.query_one(DataTable)
        table.add_columns("provider", "prompt", "system", "response", "model", "timestamp")
        table.add_rows([r.values() for r in self.db.query(
            "select provider, prompt, system, response, model, timestamp from log order by timestamp desc"
        )])

[simonw]

I'm going to have it output your history as a pretty-printed JSON array. That will do for the moment.

It will output most recent first (like git log does).