Dear all,
I'm thinking to extend the app functionality using remote db like mysql and remote storage.
One aspect is user management but the most important is to be generate a table including remote documents based on a db.
Regarding simple task as user management and log-in, I've seen around the possibility to use googlesheet but this is a new world for me and I'd prefer when possible to stick to the least number of techonoglies like mysql which is for me more familiar.
At the moment, my idea is to create a basic wordpress site using user registration and a table plug-in based on a db. afterwards, the web users will be the only one able to log-in to the app and the app will fetch/update/insert new items of the items manipulating the db and able to store documents remotly
How feasible and practical is the option of using remote db and storage?
this project does not require wordpress as standard but I'm looking for something easy to set up and test. I have a private webserver to test ghost web applications
fair...it is an example. correct to highlight the difference
What about it? Explain what it is you want to do...
With the app I organizing and save docs and publish the list of documents as table with preview.
At the moment I store the docs locally but I'm thinking to save everything directly into a remote server (not as backup of local folders). which options are available and are quick/relieble in read and write from the server?
The list of documents should be searchable and displayed in the app
Considering I'm succesfull using the remote dB the question is:
Let assume I generate a pdf with my phone, next I have a form with some field plus the document preview (or just name TBC). Once I confirm the form is correct I expect the app to insert a new row in the db (including document file_name.extension) and copy the file to the server.
On the other hand, when I search for a file, I expect the app to get an answer from the dB and if positive display the values including the possibility to fetch from the server the right document
The aim is to save all documents remotely and retrieve the files that I need when I need from the remote server
Again, if you are saving the document details to a mysql table, then you call the table contents back to your app you should have a list, which contains the names and urls for each of the documents?
I am working on the assumption that you kow how to use mysql, that you are storing your actual documents on a server and not inside mysql as blobs, and that you store the document name and url in your documents table, and that you know how to query your mysql database remotely.
confirmed I can use mysql and @TIMAI2 assumptions are correct
The question is still the same:
how I save (move) my docs to a remote server and how I fetch these?
In other words, when I click SAVE button on the app how do I phisically move let say a file home.pdf created by the app (locally on my phone) to the server and reverse?
regarding the table displaying the list of docs saved on the server, I can considere if available to use a sort of table.php on the server (running apache, php and mysql ) dispaying the script on the app as a browser will do a general .php file
those are 2 questions but I need to figure out the whole process before I found my self in a hole. Checking only one aspect of the process might bring me into a dead end situation with waste of time and resources
url: https://myserver.com/storage local file: myfile.jpg
how do I program a move/copy of the file to the server?
2nd part of the process
everything is store remotely and mysql is up and running. what option I have to create a table without downloading all time everysingle file from the server? I'm looking for an opportunity to possibly render a remote php (or equivalent script) within the app?
Are there other and different options?
Do not store the actual documents in your mysql (do as above), then all you are bringing down with a SELECT query is the data about the document, not the actual document. A user will select a document from the returned list, then it can be downloaded (if already downloaded then handle this too)
It is the generally recommended method to store binary files outside of databases, and to maintain a link to the file inside the database.
Second part:
I'm won't store binary file inside mysql but thanks to highlight.
I'm thinking of create a table with rows of documents with previews/thumbnails when possible.
with the url of the thumbnails, these shown in the table will be downloaded and rendered or will be displayed as a regular html/php page of a website (shown but not downloaded locally)?
When you upload your files to file server, you can ask the server give back the file url, and thumbnail url, then save them in the database like mysql.
