Access SQLite Remotely
 

Hi,

I am writing a GPS based application that stores some information at given intervals. My plan is to write this information to a sqlite3 db. Targeting an N810

My question is, if I were to connect the tablet to a network, is there a way for an application residing on another device (be it a tablet, laptop, desktop, etc.) to retrieve information from the database?

I have seen this, http://sqlitedbms.sourceforge.net/index.htm, but was unaware if it would possible to run on a N810 or not.

Right now, I would simply be performing selects, however I could see in the future making insert or deletes as well.

Thanks!

Re: Access SQLite Remotely
 

Generally, SQLite isn't well suited for use over the network due to performance and latency issues. A real RDBMS would be a better option. However, if you must, it should be possible as long as the SQLite DB in question is accessible on a mounted file system and can be opened with sqlite3_open().

Make sure to read the "Situations Where Another RDBMS May Work Better" section:
http://www.sqlite.org/whentouse.html