LLM should default to logging to SQLite

[simonw]

Currently you have to remember to run llm init-db first - but I think running llm logs may create that database as a side effect?

It should log by default, and provide an option for turning logging off using the same mechanism as:

• Way to configure the default model #31

TODO

• Log by default
• Setting mechanism for turning off log-by-default
• --log option for turning on logging for a specific prompt

[simonw]

There's already a --no-log option, I can add a --log mechanism for explicitly logging even if the setting is turned off.

[simonw]

Relevant code:

llm/llm/cli.py

Lines 249 to 254 in 1bdb2e7

	log_path = logs_db_path()
	if not log_path.exists():
	return
	db = sqlite_utils.Database(log_path)
	migrate(db)
	response.log_to_db(db)

[simonw]

Need to update the documentation around this too.

[simonw]

Setting the default model looks like this:

llm models default gpt-4

For disabling and enabling logs I'm going to go with:

llm logs off

llm logs on

[simonw]

I feel like there should be a way to tell the current status of logging too. Maybe:

llm logs status

Which could show not just the on/off state but also the size of the DB and number of records in it.

[simonw]

I just need the --log option now.