Search code examples
c#sqlitewindows-phonewin-universal-appwindows-10-mobile

Is it possible to use a SQLite database in a shared folder in a PC?


I am developing an UWP application (Windows phone 10) and I have a SQLite database in a shared folder in a PC in my LAN. I would like to know if I can use this database in the windows phone app, like I do with my WPF application, that I can set the path of the database and I can use it from any computer in my lan.

Thanks.


Solution

  • Short answer:
    Yes you can however you will need to be careful about the journaling mode you choose for example WAL does not work over a network file system.

    Long answer:
    If you see yourself in a situation where many clients/programs need to access a common database over a network you should consider a client/server database or provide an API of some sort that would sequentially persist the client's data to the SQLite DB.

    For more info see Appropriate Uses of SQLite