I think it can only be locally used by Damus, so no other app can access it as far as I understand.
Discussion
nostrdb is built on lmdb which allows concurrent access. You could have multiple processes reading from and writing to the same database. Probably not on phones, but desktop apps could do this.
Probably not on phones because apps are pretty insulated from each other. But it would be awesome though