Android Question Which databases can I use?

[Scotter]

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!

 

[MarkusR]

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.

 

[npsonic]

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!

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.

 

[Scotter]

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.

Thank you for your ideas and questions!
I do need to move data back and forth between the phone and a server.

 

[Scotter]

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.

Thank you for your advice!
Two questions:
- If I come from the relational database design world, how difficult to import tables from something like MS SQL Server or MS Access into MongoDB?
EDIT: I've studied up on the differences and pros/cons of SQL vs NoSQL. For my purposes, with so many database writes and scaling not being a super huge issue, I'm going to go with a SQL-type database.
- If I look at the pros and cons of using a noSQL style database vs relational, for my application purposes, and find relational to be preferred, what relational server database do you recommend?

 

[Scotter]

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?

 

[npsonic]

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?

Check RDC, but you may want to just write your own web server. You can get help from this tutorial.

 

[Peter Simpson]

Hey @Scotter,
You have 2 options for moving back and forth between your device and your server.

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/

Enjoy...