Android Question Need advice for an application

[microbox]

Hello everyone... I need to ask some guidance for an application in mind. I may have an idea on how to start but I want to make sure I'm heading the right way. I'll be using odroid U3 or raspberry pi development board to create a b4a app with sqlite as database server. I prefer to use android and sqlite because of portability and only few clients will be doing transactions. My hardware setup below...

On the pc side I'll be using vbnet to add/update/delete/search from database server.
Questions:
1. Is my setup will work or must I use another way?
2. What library must I need to learn in b4a so that database server and pc side will communicate?

Thanks in advance and more power!

 

[merlin2049er]

http://www.sqlite.org/faq.html#q5

 

[ivan.tellez]

Hi, The short answer is It cant be done that way. Or at least not in an easy way.

Thats because SQLite is designed to work with just a single process. So, the only way to make this wor is if you create a "Database server APP" a single app runing in the android device doing the access to SQLite databases and manage the comunication between PCs and server via http.

you have this options:

1 Develop an pseudo Android Server app to use concurrent conections in SQLite, you can exchange data with json like in this example, the lib you have to learn its

2. Use a Linux distro for raspberry pi, this way you can make the app in B4J a web app with concurrent access. [WebApp] Concurrent access to SQLite databases

3. Use a Linux distro for raspberry pi and install SQL server.


In any case you have to learn HttpUtils2

 

[Erel]

You can use SQLite in a server app. However it will be easier (and with much better results) to write it with B4J.

[WebApp] Concurrent access to SQLite databases

 

[microbox]

Thank you everyone for your inputs...gives me a clearer view how to work on it. I guess b4j is the easier way.