Hacker News new | ask | show | jobs
by mbaris 1382 days ago
I really like this series of blog posts on SQLite, thanks if you are reading this. It was really informative for me since I did not know much about its internals before
1 comments

Author here. Thank you for the kind words! I'm glad to hear it's been helpful.
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!