| ▲ | Kinrany 6 days ago | |
> Read only databases are a lot easier to deal with regarding locking. "A lot easier" sounds like an understatement. What's there to lock when the data is read only? | ||
| ▲ | pstuart 3 days ago | parent [-] | |
> What's there to lock when the data is read only? That's my point (it was an intentional understatement). Data that is rarely updated can be treated as read only and updates are done offline and swapped in as needed. This is very much a cope for SQLite's limited concurrency but I think it's worthy of consideration for when the situation merits it. | ||