I need to create a feature which will allow to store PDF files locations in a local SQLite. Another words I need a simple database which will store: Filename, Tible, size, CreationDate, Author etc.
I have web App which creates a record, assigns specific Filename, and its location, Title etc to SQLite database. This database resides on the server. initially I want to be able to download the whole database along with all external PDF files to the local device. Perhaps later I would rather do just a partial download (of the updated records and files only). At the moment I need to make it as simple as possible.
On the device:
The list of available PDF files should be displayed on the screen and when the user clicks/selects a specified record the assigned PDF file will be displayed on the screen. Since there could be cryptic Filenames (like XC0459sGT.PDF) I need to display PDF title (not the physical filename).
I would probably also need some mechanism to allow user to download the PDF file to local device and store that PDF info in the database.
To sumarize the idea:
1. User submits a PDF article through the WEbApp
2. Another user downloads the database along with submited PDF files
3. USer opens App which lists available PDF file Titles and when clicking on a title he opens PDF file for reading (no editing of any kind on the device is necessary)
I'm novice here so I need simple solution
what would be the best approach to implement it ?
Arthur
I have web App which creates a record, assigns specific Filename, and its location, Title etc to SQLite database. This database resides on the server. initially I want to be able to download the whole database along with all external PDF files to the local device. Perhaps later I would rather do just a partial download (of the updated records and files only). At the moment I need to make it as simple as possible.
On the device:
The list of available PDF files should be displayed on the screen and when the user clicks/selects a specified record the assigned PDF file will be displayed on the screen. Since there could be cryptic Filenames (like XC0459sGT.PDF) I need to display PDF title (not the physical filename).
I would probably also need some mechanism to allow user to download the PDF file to local device and store that PDF info in the database.
To sumarize the idea:
1. User submits a PDF article through the WEbApp
2. Another user downloads the database along with submited PDF files
3. USer opens App which lists available PDF file Titles and when clicking on a title he opens PDF file for reading (no editing of any kind on the device is necessary)
I'm novice here so I need simple solution
what would be the best approach to implement it ?
Arthur
Last edited: