Espen Andersen's site

Espen Andersen's site

Search
Skip to content
  • Computer assisted reporting
  • Contact
  • Privacy
Database research reports with SQL
Journalism, Programming

Database research reports with SQL

2017-03-16 espena Leave a comment

How about a super-simple tool for making, pretty-printed PDF research reports from your usual mess of intricate SQL queries?

Continue reading Database research reports with SQL →

databasejournalismtechnical
New GPG key
Security

New GPG key

2016-12-22 espena Leave a comment

I have created a new encryption key, and will transition away from the old one. Inspired by Simon Josefsson at Yubico, I have created (that is, copied) his key transition statement. It can be found at https://espenandersen.no/key-transition-2016-12-22.txt. The statement is signed by both my old and my new key.

Continue reading New GPG key →

GnuPGinfosec
Sign a web page with PGP
Programming, Security

Sign a web page with PGP

2016-05-21 espena Leave a comment

If you want your audience to be absolutely certain that the web page you just served them has not been tampered with, read on. This method may be a good way to calm down even your most paranoid readers.
Continue reading Sign a web page with PGP →

GnuPGinfosec
Watering pump controller
Electronics

Watering pump controller

2015-01-14 espena 2 Comments

My friend Per Ervland nurtures his practical skills by crafting a solution to relieve him and his wife from the rather cumbersome task of keeping their container garden alive. I helped him with some of the inner workings.

Continue reading Watering pump controller →

pcbtechnical
SOSI shape-up
Programming

SOSI shape-up

2015-01-10 espena 9 Comments

I have written an open-source program to convert Norwegian SOSI map data files into the more widely used Shapefile format.

Continue reading SOSI shape-up →

c++geomaticstechnical
Insect focusing
Photography

Insect focusing

2015-01-08 espena Leave a comment

Get razor sharp macro shots with a system camera and a couple of gadgets. The tehcnique is called focus stacking.

Continue reading Insect focusing →

macrotechnical

Posts navigation

← Previous 1 2

About Espen Andersen

Espen Andersen

I've been engaged in journalism since 1992, now working as development editor at Kommunal Rapport. Previously I worked 12 years as a researcher and developer at the digital investigative unit at Norwegian Broadcast Corporation. I am also a former member of the Norwegian Press Associations Commission for Freedom of information. Currently I participate in the technology committee at Association of Norwegian Editors and am a member of the jury for the Norwegian Foundation for Investigtative Journalism's annual SKUP award.

Since this is my personal blog, I'll write about anything that I think might be of interest to you. That includes articles about journalism, photography, electronics and programming.

Electronics DIY projects

  • Broadcast clock
  • Invitation card for geeks
  • Dual button doorbell
  • Infrared light barrier
  • Watering pump controller

Computer assisted reporting



Support pages centered around my book «Datastøttet journalistikk» (Norwegian for «Computer assisted reporting«). In this section, you will find course files, link collections and dummy data.

Geeky projects sharing

Recent Posts

  • Accurate 3D modeling with a flatbed scanner
  • How to hide drilling mistakes
  • U-blox module with ESP32
  • 3D-fixing broken parts
  • Broadcast clock with ESP32 and NTP/GPS receiver

Recent Comments

  • espena on Dashcam upload to personal server
  • Priscilla Jones on Accurate 3D modeling with a flatbed scanner
  • Apostolos on Dashcam upload to personal server
  • Accurate 3D modeling with a flatbed scanner - Espen Andersen's site on 3D-fixing broken parts
  • espena on Broadcast clock with ESP32 and NTP/GPS receiver

Archives

  • January 2025
  • December 2024
  • November 2024
  • August 2024
  • March 2024
  • July 2023
  • November 2022
  • October 2020
  • July 2018
  • March 2017
  • December 2016
  • May 2016
  • January 2015

Categories

  • 3D
  • Electronics
  • Fix and repair
  • GNSS
  • Journalism
  • Photography
  • Programming
  • Security

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Proudly powered by WordPress