Hacker News Reader

whats the best front end program to read those databases, for non-db folks? (windows or linux / CLI or GUI)

There's a reasonably full featured plugin for Firefox called SQLite Manager that lets you open arbitrary SQLite files and browse / edit the contents.

SQLite Studio works great

Yup, I can second that, stable with good feature set.