Android Question database options in B4A

colibri999

Member
Licensed User
Longtime User
I went through the documentation and forums and made myself a list of the possibilities B4A offers concerning databases.
I came to the following possibilities and conclusions

1. local: SQLite
>>> advantage: simplicity
>>> disadvantage: in many cases you'll need to sync/share data beyond the device

2. remote: PHB - MySQL/SQLServer/...
>>> advantage: shared hosting easy to find
>>> disadvantage: lower performance, security?

3. remote: (RDC) Java Webserver - MySQL/SQLServer/.../SQLite
http://www.b4x.com/android/forum/threads/remote-database-connector-connect-to-any-remote-db.31540/
>>> advantage: increased performance, BLOBS...
>>> disadvantage:need to set up Java web server on own infrastruture: VPN+SSH setup required for external access (shared hosting probably difficult to find)

Did l forget any option or wrote any lies?
Is RDC the only option to connect to a remote SQLite DB?
 
Top