Handling sqlite in a local network of android devices

Once you have a connection between two devices you should work with the two socket objects. Using AsyncStreams allows you to safely send data from both devices at the same time.

Hello Erel and thank you for your reply. I will surely move to Async, I think this is the best as suggested.

I am not quite sure I follow you on this, since in my case I have 2 'clients' and 1 'server'.
I connect from clientA to server, by using your recommended code:

Socket1.Initialize("Socket1")
Socket1.Connect ("xxx.xxx.x.xxx",xxxx,20000)

Then the socket1 event is raised, so I am sending data:

If Successful = False Then
Msgbox(LastException.Message, "Error connecting")
Return
End If

Dim sb As StringBuilder
sb.Initialize
Dim tr2 As TextWriter
sb.Append ("something")
Dim s As String
s=sb.ToString
tr2.Initialize2 (Socket1.OutputStream,"PrefEncoding")
tr2.WriteLine (s)
tr2.close
Socket1.Close

Now, what if at the very same moment, clientB sends data? Server is listening so it will handle both requests without a conflict? This thing is very important to me, since for 'server' I have a network printer and also another android for updating db records.

(By the way, I've noticed that 'successful' is always true, even if my 'server' is out of order, but I think there is a thread dealing with this, so I will check it out very soon.)

I'm not sure that I understand your configuration. Do you connect the two Android devices to a third server?

Exactly. Two (or more) android devices, connecting to a 'server' Android device which stores all separate db records.

Communication is done between two sockets. One server can handle many connected clients without any problem. In the server side you will have one socket (and one AsyncStream object) for each connected client.

Thank you very much for your reply, I am on to checking the stability of my code and I hope it goes well