Janne Anttila's Avatar

Janne Anttila

@janneaa.com

A senior data engineer living in Kuopio, Finland. Loves running, snowboarding and music. My blog: https://janneaa.com

32
Followers
60
Following
11
Posts
26.01.2025
Joined
Posts Following

Latest posts by Janne Anttila @janneaa.com

Parannetut pelit Microsoft Edge -pelituki - Microsoft-tuki

Kyllä peleihinkin pitäisi lisätä suomenkieliset nimet, kuten leffoissa oli aikoinaan. Sen verran hienoja on esim "Vanhin vierittää online-tilassa", "Detroit: Ryhdy ihmiseksi" ja "Nössöt aallot". support.microsoft.com/fi-fi/topic/...

27.10.2025 13:49 👍 0 🔁 0 💬 0 📌 0
Since I love collecting questionable analogies for LLMs, here's a new one I just came up with: an LLM is a lossy encyclopedia. They have a huge array of facts compressed into them but that compression is lossy (see also Ted Chiang).

The key thing is to develop an intuition for questions it can usefully answer vs questions that are at a level of detail where the lossiness matters.

This thought sparked by a comment on Hacker News asking why an LLM couldn't "Create a boilerplate Zephyr project skeleton, for Pi Pico with st7789 spi display drivers configured". That's more of an lossless encyclopedia question!

My answer:

The way to solve this particular problem is to make a correct example available to it. Don't expect it to just know extremely specific facts like that - instead, treat it as a tool that can act on facts presented to it.

Since I love collecting questionable analogies for LLMs, here's a new one I just came up with: an LLM is a lossy encyclopedia. They have a huge array of facts compressed into them but that compression is lossy (see also Ted Chiang). The key thing is to develop an intuition for questions it can usefully answer vs questions that are at a level of detail where the lossiness matters. This thought sparked by a comment on Hacker News asking why an LLM couldn't "Create a boilerplate Zephyr project skeleton, for Pi Pico with st7789 spi display drivers configured". That's more of an lossless encyclopedia question! My answer: The way to solve this particular problem is to make a correct example available to it. Don't expect it to just know extremely specific facts like that - instead, treat it as a tool that can act on facts presented to it.

An LLM is a lossy encyclopedia simonwillison.net/2025/Aug/29/...

29.08.2025 09:31 👍 272 🔁 36 💬 22 📌 7

#TIL that the CSV settings in Azure Data Factory can be quite random. If the character used as a delimiter is inside a quoted value then it may be treated as a delimiter. Setting the "Escape character" in ADF to double quote fixes this even if nothing is actually escaped in the CSV.

21.08.2025 09:49 👍 0 🔁 0 💬 0 📌 0
Listing all the permissions in an Azure SQL Database | Janne Anttila The most common methods of giving permissions in an Azure SQL Database

Just posted some tips on the blog on how to list permissions in an Azure SQL Database. janneaa.com/posts/listin...

12.05.2025 16:06 👍 0 🔁 0 💬 0 📌 0
Sun shining in a snowy forest.

Sun shining in a snowy forest.

Spring is coming!

21.03.2025 18:21 👍 2 🔁 0 💬 0 📌 0
An Outlook emoji reaction

An Outlook emoji reaction

Emoji reactions are not how email is supposed to work... Receiving an email that contains only this seems like wasted time.

20.03.2025 06:45 👍 1 🔁 0 💬 0 📌 0
Creating a free blog with Hugo and Cloudflare Pages | Janne Anttila In this guide I'll go through the steps required to create a Hugo blog hosted on Cloudflare.

Just posted on the blog: Creating a free Hugo blog that's hosted on Cloudflare. janneaa.com/posts/creati...

19.03.2025 18:21 👍 0 🔁 0 💬 0 📌 0
Preview
The DuckDB Local UI The DuckDB team and MotherDuck are excited to announce the release of a local UI for DuckDB shipped as part of the ui extension.

DuckDB's local UI extension seems really interesting. It's always good to have some high quality local tools for data exploration. duckdb.org/2025/03/12/d...

13.03.2025 08:37 👍 1 🔁 0 💬 0 📌 0

I finally rebuilt my blog. It was high time since the last time was a decade ago 😁 janneaa.com/posts/hello-...

24.02.2025 21:16 👍 0 🔁 0 💬 0 📌 0
Preview
Garmin Issues Warning About Watch Boot Loop Bug Garmin watch down or bricked? There's a nasty bug going around afflicting Fenix, Epix, Forerunner watches and more. Here's what you need to know.

This boot loop also happened on my Garmin Forerunner 255. I got the watch to start with a master reset (2nd link). www.forbes.com/sites/andrew... forums.garmin.com/sports-fitne...

28.01.2025 16:13 👍 1 🔁 0 💬 0 📌 0

DeepSeek-R1 seems like quite a good AI model. It's also possible to run it locally in the browser.

28.01.2025 10:35 👍 0 🔁 0 💬 0 📌 0

Let's give this Bluesky thing a try 🙂 Sure hope it stays better than most of the other social media sites these days.

26.01.2025 19:51 👍 1 🔁 0 💬 0 📌 0