How to access data from a server app running on Linux?

Question

How to access data from a server app running on Linux?

I have a database app on an iPad (Ninox) that can export data to iCloud or Google Drive in csv form.

I'd like to be able to write an application (maybe in PHP or Node.js) that can pick that data up and put it into a more grown-up database (eg. MySQL) as part of a web-based portal access to the data.

I get the feeling that this will be a lot easier with the (more open) Google Drive, but I'd like to get a more authoritative view that using iCloud isn't a flyer!

iPad Pro Wi-Fi, iOS 11.1

Posted on Nov 1, 2017 4:03 PM

Reply

Answer 1

Nov 3, 2017 4:56 AM in response to Alexander Lake

Hi. Am I correct in understanding that this doesn't involve iPad at all?

Certainly, Apple makes it difficult for 3rd parties to access iCloud by requiring app-specific passwords. A generic cloud service would probably be more suitable.

Reply

Answer 2

rccharles

Level 6

13,037 points

Nov 2, 2017 10:08 AM in response to Alexander Lake

I'd like to be able to write an application (maybe in PHP or Node.js) that can pick that data up and put it into a more grown-up database (eg. MySQL) as part of a web-based portal access to the data.

I'm ot certain of the data flow.

Are you planning on using the Ninox app on the ipad? PHP is typically used as a server based app to manage a web client browser.

R

Reply

Answer 3

Nov 3, 2017 3:40 AM in response to rccharles

Yes, but there's a handy little data export feature that enables one to save a database to a filestore on the cloud (iCloud, Google Drive, Dropbox etc). Once there, I can have a server pick up that data and do stuff with it.

Reply

Answer 4

Nov 3, 2017 12:25 PM in response to Diana.McCall

Actually, you're quite right! I should have posted in iCloud....

Reply