Is this a potential way to work around the single-writer nature of SQLite? It's probably the main limitation I hit when using SQLite, which otherwise fits a lot

Is this a potential way to work around the single-writer nature of SQLite? It's probably the main limitation I hit when using SQLite, which otherwise fits a lot of jobs very well. Obviously you would not want to use it for situations where there is contention, but SQLite locks the whole database even if you are writing to completely separate tables.