Android Question Which databases can I use?

Scotter said:

Hi -
In order of preference, here are the databases I'd like to use for developing a database-driven B4A app.
But I really want to hear advice here and I can be flexible if a case is made for learning / using some other database system:
- MS Access
- MS SQL Server
Thanks!

Click to expand...

MarkusR said:

local database i would use SQLite.
if u have a mobile app with data access over internet i would use a indirect access via webapi or php.
it belongs what you will do with the collected data.
if it is a hobbie project or not, if u collect data just in wlan
or at any place on this world.
fit the data into phone (ex many pictures) or not.
must the data be at a save place at server for data protection.

Click to expand...

npsonic said:

Android apps use always SQLite. You get easy start by using KeyValueStore.
MongoDB is great for server applications. It's fast and with the dynamic schemas very easy to use. At least it's great NoSQL for android app development.

Click to expand...

Scotter said:

I remember using an ASP.Net script a couple years ago that ran on the server and was called by my B4A application to run SQL queries against a SQL Server database on the server.
It worked but seemed pretty kludgy to me.
Wondering if there is anything new available for B4A that is more integrated?

Click to expand...

1. Write your own synchronisation routine, I use my own for synchronising from SQLite on devices to MySQL on my server.
2. Look at this link https://www.b4x.com/android/forum/threads/b4x-cloudkvs-synchronized-key-value-store.63536/