Sync SQLite db from PC to Android?

I want to purchase this product if it supplies some options for me to solve this problem. Can anyone give me some advice? :BangHead:

In most of my database desktop applications I use SQLitening. SQLlitening is an OpenSource Client-/Server extension to SQLite written in PowerBasic. It is small, fast, reliable - choose any three. It can be found here: SQLitening Support Forum - Index

I have it running on LANs and also on internet based Windows Servers. Runs for months now without fail.

My dream - if I find enough time for it - would be to write a B4A client for it.

Rolf

I had a similar situation very recently, but since I didn't have enough tools to handle sqlite to my PC, I created an Access DB containing the data of sqlite DB and then handled requests between my Android and my PC, by sendind data which my code transforms into acceptable queries. Yet, I don't know if this is a good solution, even if it works for me so far.

I'm not an expert in this area, but I think some more information is required for you to get the answer you want.

When you say 'sync' do you mean one way, i.e. the db is updated on PC and not on the device?

Will the devices that need to get the information be on the same network, or will it need to connect over the internet?

From my limited knowledge of this area, there are a number of ways you could achieve this, FTP, Webserver and PHP, or even possibly email (I think the intents are available now).

Most of them will require some kind of server, what kind and how it's implemented will depend on what access is required (local or internet).

If you can provide as much information as you can, it will give someone who is an expert in this area a chance at outlining a solution for you.

What is the size of the database file?

If the file is not too large then the simplest solution is to copy the whole file.

There are several ways to connect to the desktop computer.
B4AServer is one solution that helps with avoiding firewall issues. It should be pretty easy to implement a solution that pulls the database from the desktop.