Sqlite being accessed remotely

Question

Would it be possible to create an App connection on Android with the Sqlite service with PC Local? I’m not talking about a database inside the Android itself, but communicating with the same PC.

Answer 1

Yes, it is possible, but not recommended.

Any direct access to the file is problematic, the operating system has difficulty dealing with direct competing remote access. Moreover it is not so simple to take care of the security to access this file and has chance to end up exposing the computer where the Sqlite file is.

Obviously I’m considering that the computer can be easily located on the network. There are a number of concerns to be noted that would depend on a deeper study of the subject. You can’t follow the recipe for cake, and I don’t think you even have one, for good reason.

What is more recommendable is the access to be done through an intermediate application on the computer where the Sqlite file is located and this application is what makes the access to DB.

• There is the possibility of create an own application for this and use a communication protocol between the server application and the client on Android:

  It is only recommended for experienced programmers or who have a good command of computing. If you don’t know how to do it, you have several points to fail.

• Or you can use a standard web server and create only the application that makes access to Sqlite simple and deliver to the HTTP server take care of communication with Android:

  • there are risks to do wrong but it is not so complicated;
  • has cake recipes (to be followed blindly and the solution is not so good, starting because it is being chosen because it is easy and not because it is the best);
  • and almost everyone can help because this is a standard solution adopted;
  • but it might not be the best performance if you don’t need HTTP access.