Dear All,
I need to have some background information about B4A working with files located on a NAS in my local network.
The idea is as following:
I installed a SQLite database located on a NAS. A Python program running on a Raspberry Pi is collecting permantently data from my solar panels and store them in the SQL database. I’ve written another Python program to monitor the stored data, which is running on the Raspbery Pi, too, but can also be started from Windows 10. Everything is running in my local network.
Now, I plan to monitor the data with my smartphone running on Android, too. I’ve some experience with B4A to program apps for Android, but I couldn’t get any valid information in the B4A forum how to connect an app to a SQLite database which is located on the NAS. I need only read operations to monitor my solar panels.
Is it possible to query some data from a SQLite database located in the network from Android (e.g. via SMB2) and process them inside my app? I don’t want to copy the whole database from the NAS to the local Android storage for each operation (too much data).
Does anybody have other ideas how to get it solved?
Wosl
I need to have some background information about B4A working with files located on a NAS in my local network.
The idea is as following:
I installed a SQLite database located on a NAS. A Python program running on a Raspberry Pi is collecting permantently data from my solar panels and store them in the SQL database. I’ve written another Python program to monitor the stored data, which is running on the Raspbery Pi, too, but can also be started from Windows 10. Everything is running in my local network.
Now, I plan to monitor the data with my smartphone running on Android, too. I’ve some experience with B4A to program apps for Android, but I couldn’t get any valid information in the B4A forum how to connect an app to a SQLite database which is located on the NAS. I need only read operations to monitor my solar panels.
Is it possible to query some data from a SQLite database located in the network from Android (e.g. via SMB2) and process them inside my app? I don’t want to copy the whole database from the NAS to the local Android storage for each operation (too much data).
Does anybody have other ideas how to get it solved?
Wosl
