Hacker News Reader

Concurrent writes, no. Reads are fine though.

It's almost as if reading trending blog posts isn't a great way to decide software architecture

I'm still soyfacing over sqlite and how elegant and powerful it is, and I'll continue deciding software architecture based on random blog posts. I have learned nothing.

Were you using SQLite in WAL mode?

WAL Mode worked as advertised. But the project ended up being split into several autonomous workers, and even with WAL mode, sqlite gets problematic when you have several separate processes trying to read from and write to the same file.