* Bruno Barbier <brubar.cs@gmail.com> [2024-12-10 01:57]:
> The package repository has a nice video that shows this package in
> action.  I think it will answer your questions better than I could
> (I discovered this package recently; I just tried it out of curiosity,
> no real needs).

I have so much real need. It is indispensable, and I can't wait buying
strong GPU to run it locally and fast. It already works locally, just
it is so slow as I don't have GPU. I will upgrade memory, GPU so that
I can run free LLMs locally.

(defun rcd-pie-llm-usage-per-day ()
  "Generate an R PNG image showing LLM usage per day."
  (interactive)
  (rcd-sql-pie-chart "LLM usage per day" 
		     "SELECT extract(day from log_datecreated)::text AS day, 
                             count(log_id) AS count 
                        FROM log 
                    WHERE log_logtypes IN (8, 11, 12, 14)
                      AND log_datecreated > (current_date - 30)
                    GROUP BY day 
                    ORDER BY day ASC"))

The above higher level function uses GNU R Langugage to generate the
attached file `llm-usage-per-day.png'

(defun rcd-llm-usage-by-day ()
  (interactive)
  (cf-chart-bar-quickie "SELECT date_part('day', log_datecreated)::int AS day, 
                                count(log_name) 
                           FROM log 
                          WHERE log_logtypes IN (8, 11, 12, 14)
                       GROUP BY date_part('day', log_datecreated)::int
                       ORDER BY day DESC" 
			"LLM usage by day" 
			"LLM usage by day" 
			"Totals"))

The above higher level function uses Emacs Lisp function
`chart-bar-quickie' to generate the attached file
`LLM-usage-per-day2.png'

I can't agree to asynchronous injection of text, it sounds dangerous
to me. When there is any lag in computer, my text anyway doesn't get
well written due to whatever problems and often my speed writing.

And I am often using temporary buffers for that reason that I do not
disturb my other buffers with whatever changes.

My LLM usage is such that I just do C-u F5 and then text will be added
to the previous text, or I do F5 and text will be inserted, if region
was marked it is used as part of the prompt.

Everything is logged in the database, so I can convert each response
later to other objects.

Basically I get fundamentally same result as gptel with just few functions in background.

-- 
Jean Louis