Are you still planning to write the article about cases when SQLite is not a good fit? Would be really interesting because we only hear stories when someone believes it is the best fit.

Yes, I am still planning on writing about when SQLite is not a good fit. Folks on Twitter were helpful in listing use cases where it doesn't well. :)

I am under the impression that sqlite may struggle with many concurrent writers

I'm having a great time with it. SQLite's documentation is so good that it's difficult to usefully add to it, but you've managed that.

Some else said this, but I'd also love to see a deeper dive into the query plan, if you get to it.

hey, while you're here, the links to the other articles from this one are broken

Oh shoot, thanks for letting me know. I'm getting them fixed up right now!