Example dashboard

Various statistics from my blog.

Owned by simonw, visibility: Public

Entries

3069

SQL query
select 'Entries' as label, count(*) as big_number from blog_entry

Blogmarks

7120

SQL query
select 'Blogmarks' as label, count(*) as big_number from blog_blogmark

Quotations

888

SQL query
select 'Quotations' as label, count(*) as big_number from blog_quotation

Chart of number of entries per month over time

SQL query
select '<h2>Chart of number of entries per month over time</h2>' as html
SQL query
select to_char(date_trunc('month', created), 'YYYY-MM') as bar_label,
count(*) as bar_quantity from blog_entry group by bar_label order by count(*) desc

Ten most recent blogmarks (of 7120 total)

SQL query
select '## Ten most recent blogmarks (of ' || count(*) || ' total)' as markdown from blog_blogmark
SQL query
select link_title, link_url, commentary, created from blog_blogmark order by created desc limit 10

10 rows

link_title link_url commentary created
Spam, junk … slop? The latest wave of AI behind the ‘zombie internet’ https://www.theguardian.com/technology/article/2024/may/19/spam-junk-slop-the-latest-wave-of-ai-behind-the-zombie-internet I'm quoted in this piece in the Guardian about slop: > I think having a name for this is really important, because it gives people a concise way to talk about the problem. > > Before the term ‘spam’ entered general use it wasn’t necessarily clear to everyone that unwanted marketing messages were a bad way to behave. I’m hoping ‘slop’ has the same impact – it can make it clear to people that generating and publishing unreviewed AI-generated content is bad behaviour. 2024-05-19 19:54:50+00:00
NumFOCUS DISCOVER Cookbook: Minimal Measures https://discover-cookbook.numfocus.org/02_minimal_measures.html NumFOCUS publish [a guide](https://discover-cookbook.numfocus.org/intro.html) "for organizers of conferences and events to support and encourage diversity and inclusion at those events." It includes this useful collection of the easiest and most impactful measures that events can put in place, covering topics such as accessibility, speaker selection, catering and provision of gender-neutral restrooms. 2024-05-19 18:24:21+00:00
Fast groq-hosted LLMs vs browser jank https://taras.glek.net/post/groq-vs-html-reflows/ [Groq](https://groq.com/) is now serving LLMs such as Llama 3 so quickly that JavaScript which attempts to render Markdown strings on every new token can cause performance issues in browsers. Taras Glek's [solution](https://github.com/tarasglek/chatcraft.org/pull/640/files) was to move the rendering to a `requestAnimationFrame()` callback, effectively buffering the rendering to the fastest rate the browser can support. 2024-05-19 13:35:47+00:00
A Plea for Sober AI https://www.dbreunig.com/2024/05/16/sober-ai.html Great piece by Drew Breunig: "Imagine having products THIS GOOD and still over-selling them." 2024-05-19 00:47:49+00:00
AI counter app from my PyCon US keynote https://github.com/simonw/count-ai In my keynote at PyCon US this morning I ran a counter at the top of my screen that automatically incremented every time I said the words "AI" or "artificial intelligence", using [vosk](https://alphacephei.com/vosk/), [pyaudio](https://people.csail.mit.edu/hubert/pyaudio/) and Tkinter. I wrote it in a few minutes with [the help of GPT-4o](https://chatgpt.com/share/58f2352d-1f17-495b-94f1-4eb44cd574b9) - here's the code I ran as a GitHub repository. I'll publish full detailed notes from my talk once the video is available on YouTube. 2024-05-18 15:49:55+00:00
Understand errors and warnings better with Gemini https://developer.chrome.com/docs/devtools/console/understand-messages As part of Google's Gemini-in-everything strategy, Chrome DevTools now includes an opt-in feature for passing error messages in the JavaScript console to Gemini for an explanation, via a lightbulb icon. Amusingly, this documentation page includes a warning about prompt injection: > Many of LLM applications are susceptible to a form of abuse known as prompt injection. This feature is no different. It is possible to trick the LLM into accepting instructions that are not intended by the developers. They include a screenshot of a harmless example, but I'd be interested in hearing if anyone has a theoretical attack that could actually cause real damage here. 2024-05-17 22:10:06+00:00
Commit: Add a shared credentials relationship from twitter.com to x.com https://github.com/apple/password-manager-resources/commit/34c37ad0c28c05cce2e9fc6f283c838267a32dda#diff-545b7db9a560748a31f14a61b89132b3df144d9363bcb9698295def59f844dfd A commit to `shared-credentials.json` in Apple's `password-manager-resources` repository. Commit message: "Pour one out." 2024-05-17 20:04:40+00:00
PSF announces a new five year commitment from Fastly https://fosstodon.org/@ThePSF/112456715341751673 Fastly have been donating CDN resources to Python - most notably to the PyPI package index - for ten years now. The PSF just announced at PyCon US that Fastly have agreed to a new five year commitment. This is a really big deal, because it addresses the strategic risk of having a key sponsor like this who might change their support policy based on unexpected future conditions. Thanks, Fastly. Very much appreciated! 2024-05-17 13:52:16+00:00
Programming mantras are proverbs https://lukeplant.me.uk/blog/posts/programming-mantras-are-proverbs/ I like this idea from Luke Plant that the best way to think about mantras like "Don’t Repeat Yourself" is to think of them as _proverbs_ that can be accompanied by an equal and opposite proverb. DRY, "Don't Repeat Yourself" matches with WET, "Write Everything Twice". Proverbs as tools for thinking, not laws to be followed. 2024-05-17 12:10:22+00:00
PaliGemma model README https://github.com/google-research/big_vision/blob/main/big_vision/configs/proj/paligemma/README.md?ref=blog.roboflow.com One of the more over-looked announcements from Google I/O yesterday was PaliGemma, an openly licensed VLM (Vision Language Model) in the Gemma family of models. The model accepts an image and a text prompt. It outputs text, but that text can include special tokens representing regions on the image. This means it can return both bounding boxes and fuzzier segment outlines of detected objects, behavior that can be triggered using a prompt such as "segment puffins". You can try it out [on Hugging Face](https://huggingface.co/spaces/google/paligemma). It's a 3B model, making it feasible to run on consumer hardware. 2024-05-15 21:16:36+00:00
Copy and export data

Duration: 4.51ms