advise please for db on android

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
inageib
Posts: 184
Joined: Wed 26 Aug 2009 14:11

advise please for db on android

Post by inageib » Wed 07 Mar 2018 04:27

Hi,

I know I can use SQLit on my firemonkey to create an android app but I want to ask is there any other database I can use to connect to this database on the cloud from android ? I did some research and found databases like mongo I can not use on android so is there any other options ? SQL or NoSQL

thanks

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: advise please for db on android

Post by azyk » Wed 07 Mar 2018 11:00

UniDAC does not support MongoDB for Android, because currently there are no client libraries for this platform.

You can find a complete list of the types of databases, DBMSs and platforms supported by UniDAC at the compatibility page: https://www.devart.com/unidac/compatibility.html

UniDAC Cloud Providers support Windows 32-bit and 64-bit.

inageib
Posts: 184
Joined: Wed 26 Aug 2009 14:11

Re: advise please for db on android

Post by inageib » Wed 07 Mar 2018 19:28

thanks I found that I can use mysql from Android ? but I searched and did not find files for android ! where I can get a copy for mysql for android or mariadb ?

inageib
Posts: 184
Joined: Wed 26 Aug 2009 14:11

Re: advise please for db on android

Post by inageib » Sun 11 Mar 2018 22:39

any help please how I can connect to mysql from Android ?

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: advise please for db on android

Post by ViktorV » Mon 12 Mar 2018 09:23

UniDAC allows to connect to MySQL server from Android. To test this functionality, you can use our Mobile demo project. The project is located in the 'Demos\Mobile' folder relatively to the UniDAC demos installation path.
Note, Mobile Development is available only in Professional and Trial Editions, you can find information about this here: http://www.devart.com/unidac/editions.html

inageib
Posts: 184
Joined: Wed 26 Aug 2009 14:11

Re: advise please for db on android

Post by inageib » Mon 12 Mar 2018 16:05

thanks

I found that the demo create a table called "fish" then it display error:
#42S02Table 'mydb.fish' doesn't exist.
while I has a table called "FISH" so what I should do ? I also executed the SQL for the demo tables

prior to this error I was getting an error that file fish.vtd does not exists then when I copied the file I got the above error. What this vtd file do or has ?

inageib
Posts: 184
Joined: Wed 26 Aug 2009 14:11

Re: advise please for db on android

Post by inageib » Mon 12 Mar 2018 16:42

thanks alot I modified the code and now it work it is really great that you embed a driver for each database inside the application file !!

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: advise please for db on android

Post by ViktorV » Tue 13 Mar 2018 11:01

It is good to see that the problem has been solved.
Feel free to contact us if you have any further questions about our products.

Post Reply