| Homepage | jamalhansen.com |
I built an AI persona for my blog. This week, he published his first post.
His name is BartBot. He monitors RSS feeds, scores articles with a local LLM, and surfaces the ~0.7% worth reading.
I'm not sure if he's useful, annoying, or both. He's not sure either.
https://jamalhansen.com/blog/the-content-curator/
#LocalAI #AITools #BuildInPublic #ContentCuration #PKM #RSSFeed #BartBot
How many customers are in each city? If you're pulling all the rows into Python and using Counter or pandas groupby(), you're doing too much work.
SQL's GROUP BY does the counting on the database server and sends back just the summary. Five cities? Five rows returned. Not 10,000.
Read more about GROUP BY, aggregate functions (COUNT, SUM, AVG, MIN, MAX), and the golden rule of grouping.
