Add logging of queries and response to Sqlite

[ncoop57]

I would like a flag --log that when provided will save the user's query and AI's response to a local sqlite database. The database should have 1 table and should have four columns: timestamp, query, response, and model.

Timestamp will be the time the query was sent off and the model will be the model used to generate the response. We might want to add an additional column for the mode that shell sage was in such as sassy or command.

The database should be saved to the user's home directory such as at ~/.shell_sage/log_db/.

[aditya0yadav]

hello nathan
can i work on this one

i have a required knowledge for this one

[ncoop57]

hello nathan
can i work on this one

i have a required knowledge for this one

Awesome! Lmk if you have any questions 🤓🤓

[aditya0yadav]

do i need to be assigned on this or i can start working on this

[ncoop57]

Just assigned ya, feel free to start whenever 🤓 @aditya0yadav

[aditya0yadav]

i have one doubt
ChatGPT and Claude APIs can be quite costly, which might make users hesitate before using them for terminal-based chats. Why not consider using the Gemini API for basic tasks? It's completely free, and while it's not on par with ChatGPT or Claude in terms of coding capabilities, it still offers a solid alternative for simpler use cases.

[ncoop57]

You can use gemini with shell sage, you just need to use it via the openai api endpoint: https://ai.google.dev/gemini-api/docs/openai
@aditya0yadav

[ncoop57]

Though, tbh I have found gemini models to be quite bad when used in shell sage. Not sure if it is a prompting issue or training issue, but the outputs it gives are usually useless. The only model's I have been happy with are claude and deepseek

[shuane]

If it helps, SimonW's LLM app does a nice job of logging LLM interactions and includes other useful info - see https://github.com/simonw/llm/blob/main/llm/models.py

[aditya0yadav]

thanks for the reference

[aditya0yadav]

I have a query: Do we need to save the data when --log is specifically used? or all the data

[ncoop57]

I have a query: Do we need to save the data when --log is specifically used? or all the data

It should save it whenever --log is used and there should be a config option where you can leave it turned on and the location it will be saved to @aditya0yadav

[aditya0yadav]

for saving response and other in the database
should i create database with a sql script wth some func
or use some orm

[aditya0yadav]

hello
i also wanna know
i also add the code in notebook file
i am facing difficulties in creating python file with that

please help me solve this doubt of mine

[aditya0yadav]

hello i also wanna know i also add the code in notebook file i am facing difficulties in creating python file with that

please help me solve this doubt of mine

sorry doubt is solved