SQLite as an Application File Format (2014)

Re:SQLite as an Application File Format (2014) by mongol on Saturday June 13, 2020 @11:58AM (#23510334)

I tried to do that with a Firefox SQLite database files but it had an exclusive lock.

[ Parent | on HN ]

Re:SQLite as an Application File Format (2014) by TheRealPomax on Saturday June 13, 2020 @12:02PM (#23510370)

This is the case for any application that constantly writes to their dbs, so you usually run your own application/utility on them when the "parent" application isn't running.

[ Parent | on HN ]

Re:SQLite as an Application File Format (2014) by simonw on Saturday June 13, 2020 @01:11PM (#23510907)

You can usually work around that by creating a copy - I run "cp /path/to/locked.db /tmp" all the time for this.

[ Parent | on HN ]

Re:SQLite as an Application File Format (2014) by pjscott on Saturday June 13, 2020 @04:52PM (#23512617)

Make sure to also copy locked.db-wal if it's present. (Is there a better way to do all this? I feel like there really ought to be a better way.)

[ Parent | on HN ]