I think there may be some confusion in this thread between 2 issues:
1) shared (multi-user) access to LR library database:
- clearly needs more than SQLite, more difficult to implement, quite reasonably not done in LR V1 but presumably not excluded as a future line of development by Adobe.
2) storing LR library database on a network volume:
- even in single-user mode, this can be useful for several reasons - some users (like me) put all their critical files on a server to take advantage of regular backup, others use NAS and so forth.
- as far as I know there is nothing in SQLite which prevents an SQLite database being on a network volume.
- therefore I don't quite understand why Adobe blocked this in LR v1. Maybe they were just being hyper-cautious, foreseeing that people would try to share an LR database on a network volume and screw it up. On the other hand, I can give access to my PC's hard disk to other users on my network, so even local hard disk storage is not immune to attempts at simultanous access by multiple users.