I assume you’re asking about concurrent writes and yes, if you use WAL mode you can have that too.

https://www.sqlite.org/wal.html