Archive

2025  16

May  5

Using SQL to turn all the buses around

May 28, 2025 · 14 min · 2894 words · Robin Kåveland

No-ops linux part 3: It puts the data in the pond. Nightly.

May 14, 2025 · 22 min · 4516 words · Robin Kåveland

No-ops linux part 2: Hosting a simple container on a lean mean systemd machine

May 14, 2025 · 15 min · 3112 words · Robin Kåveland

No-ops Linux part 1: Automation, security and essentials

May 13, 2025 · 12 min · 2444 words · Robin Kåveland

To create, or be consumed? That is the question

May 6, 2025 · 8 min · 1536 words · Robin Kåveland

April  6

That join sure is a natural

April 30, 2025 · 4 min · 823 words · Robin Kåveland

It’s okay to have no idea what you’re doing and try anyway

April 26, 2025 · 4 min · 832 words · Robin Kåveland

Deploying to BunnyCDN and protecting Norway from drop bears

April 20, 2025 · 8 min · 1609 words · Robin Kåveland

Checking SQL migrations with eugene

April 16, 2025 · 4 min · 658 words · Robin Kåveland

Running containers on no-ops linux in 2025

April 14, 2025 · 8 min · 1679 words · Robin Kåveland

Finding foreign keys missing indexes

April 4, 2025 · 7 min · 1468 words · Robin Kåveland

March  2

Constraint propagation: Mutual recursion for fun and profit

March 10, 2025 · 20 min · 4227 words · Robin Kåveland

Why would I use DuckDB for that?

March 2, 2025 · 13 min · 2570 words · Robin Kåveland

January  3

🎶 These points of data make a beautiful line 🎶

January 31, 2025 · 7 min · 1396 words · Robin Kåveland

What if that isn’t a bool?

January 8, 2025 · 4 min · 817 words · Robin Kåveland

Exploring a webapp using psql and pg_stat_statements

January 6, 2025 · 4 min · 688 words · Robin Kåveland

2024  13

September  1

Consider using array operators over the SQL in operator

September 21, 2024 · 4 min · 674 words · Robin Kåveland

August  1

Batch operations using composite keys in postgres over jdbc

August 30, 2024 · 5 min · 945 words · Robin Kåveland

June  1

Norwegian Wild Salmon Fishing Ban of 2024

June 27, 2024 · 6 min · 1245 words · Robin Kåveland

May  6

Using short lived postgres servers for testing

May 27, 2024 · 6 min · 1082 words · Robin Kåveland

Building documentation for Eugene

May 20, 2024 · 7 min · 1343 words · Robin Kåveland

Moving the blog to Hugo

May 18, 2024 · 1 min · 212 words · Robin Kåveland

Linting postgres migration scripts

May 16, 2024 · 7 min · 1475 words · Robin Kåveland

Porting an application from cats effects to ZIO

May 16, 2024 · 8 min · 1649 words · Robin Kåveland

Careful with That Lock, Eugene: Part 2

May 6, 2024 · 13 min · 2581 words · Robin Kåveland

April  2

Careful with That Lock, Eugene

April 12, 2024 · 9 min · 1759 words · Robin Kåveland

How to test for missing indexes on foreign keys

April 4, 2024 · 4 min · 665 words · Robin Kåveland

March  2

Friends don’t let friends export to CSV

March 24, 2024 · 9 min · 1915 words · Robin Kåveland

Isolating integration tests that commit transactions

March 10, 2024 · 2 min · 403 words · Robin Kåveland

2023  1

May  1

Protecting your postgres server from your application

May 9, 2023 · 7 min · 1391 words · Robin Kåveland