News for hackers. Stuff that matters.
Re:Performance/Avoid SQLite in Your Next Firefox Feature (2014) by adrianmonk on Sunday June 14, 2020 @01:40PM (#23519609)
> Features that regularly add data to the DB (e.g. visited URIs), but have no expiration policy for the data, can easily cause the DB to balloon into tens or hundreds of MBs.

I don't know if it's fair to call that a SQLite pitfall. If they can recommend an alternative storage option where this problem doesn't occur, I'd be extremely interested to hear about it.

Re:Performance/Avoid SQLite in Your Next Firefox Feature (2014) by hobs on Sunday June 14, 2020 @02:09PM (#23519837)
I think the only real critique is that a file system already has systems to identify individual ballooning items, whereas the database would be a single container that is opaque to many basic users.