News for hackers. Stuff that matters.
Re:Many small queries are efficient in SQLite by NelsonMinar on Tuesday February 16, 2021 @10:36AM (#26154828)
It's terrific right until you need multiple processes writing to the same database. It's no accident that SQLite is fast for many small queries; it's not doing a lot of the work required to, say, be a good database backend for multiple web frontends.
Re:Many small queries are efficient in SQLite by danenania on Tuesday February 16, 2021 @01:32PM (#26157119)
Yeah, I don’t really see sqlite as competing with postgres or mysql for this reason. It’s an alternative to the file system.