which database system works for Kivy on Android (with Python3)

[Peter Peter]

Hello, I'm stuck for weeks to implement a working data base on Kivy for Android phones.

I'm working with Python3, Kivy 1.10.1 and buildozer on the VM 0.5.

Has someone already succeded to make a working Android APK with these settings?

If yes, I would be very happy to know how and wich data base system he used (sqlite3, mysql, ... ?)

[Peter Peter]

So should I deduce it is impossible since now ?

Someone to confirm ?

[ZenCODE]

Not sure what say. Our app using sqlite3, compiles on the VM 0.5 without problems and runs on the device, no problems. Are you sure your spec files contains all the correct values, as laid out in the python3 touchtracer example in the VM?

[epou...@gmail.com]

I had the same issues and decided to fall back to TinyDB.  This converts your data into a JSON file.  It should not be used for extensive databases, but since you're storing your information locally this shouldn't be an issue.  Here is the link to my solution: https://stackoverflow.com/questions/54119276/using-jsonstore-in-kivy

[Peter Peter]

Thank's a lot, I will have a look.

What is the best approach to deal with datas on server ?

My project is to made a app where you can deal with a data base about plants and search and select specific properties in this db.

I understood that localy db is not the best approach for security reasons.

So it is why I'm looking for a way to code an app who will just send the request to a server and this server will return a selection list of plants my app can deal with. Doing so I'm not dealing sqlite3 anymore via buildozer and staff.

So my question is:  How can I set a server up who can deal with sql request and return a list of selected items?

I'm completely newbie on that and in the same time a lot of energie to learn ;-)

Clear and simple approach will be appreciated.

Big thanks for your answers.