I need to restore a blog nested responses commenting system for a static site that was relying on a remote database as a service platform no longer active.
In a nutshell this is what was happening:
From a form on a static HTML page, comments were sent to a locale PHP page that via CURL was sending the comment to server where they were stored.
Comments were just stored, not available to the public, and later retrieved from a locale admin page that - via a RESTful API - was downloading a json file with the whole list of comments.
The json file was later parsed from a static site generator in ruby to include comments at the appropriate location.
WHAT IS REQUIRED
As it will not possible to reproduce in its entirety what it was once online, the output of this project can be represented with the short diagram below:
Posting
local form on the site -> local page to post comment -> RESTful api exposed on the SQL machine to accept comments -> sql server to store comments
Retrieving comments
remote sql server - restful api infrastructure exposing a URL from which comments can be retrieved -> local admin page to moderate (edit, delete, approve) comments and save a local json file.
The whole process should be designed in a way I can later support a second site I need to migrate on this commenting platform.
In detail, what I need is:
- support in setting up a database to store comments.
- As database may be hosted on a separate network from where the site is, create a RESTful API framework (or use anything existent) to work with the database for any CRUD operation like posting comments, moderating comments etc.
I found this online [login to view URL] as a potential solution. Feel free to suggest anything else that may work similarly or to code something from scratch.
- Remote data to be protected from indiscreet and random access, avoiding unauthorised inclusion or data retrieval.
In my mind, this can be achieved with a random hash key created on the local script passed to the remote script for decryption and grant access to any further operation.
- Two unique API keys should used, one for CRUD operations and one for data retrieval, thus making the process a bit more secure
- API keys to be used as part of the URLs
e.g.
Posting [login to view URL]
Reading [login to view URL]
- Amend an existing admin console, to remotely connect to the database with the above REST API to perform actions like
* approve comments
* delete comments
* inline edit comments
- provide support to integrate the designed solution within the already existing site.
e.g. how to amend the local PHP file to connect to the REST Api
Project can be initially developed locally on your end. We will integrate at a later stage.
It's my duty to deliver credible work to my clients. Check my previous work in Wordpress and the responses speak for themselves. I am ready to work for you. Thank you alot.
We are team of excellent developers. We have 2 year experience related to your project field. We can do your project and solve your all problems according to your requirements. We have read your description for projects and we understand what you want so we are confident that we can do it easily in mention time. We assure you that you will be completely satisfy with our work. And after delivering your project if you feel some issue in understanding the projects then we will teach you free until you understand. If you have any question then feel free to ask. We are here for you.
Thank you
MethisonExpert Team
Hey dude hope you are fine
I'm interested in the project you're offering .
I'm new in the the market but my experience and work will show you how best I am.
I assure you if you hire me you will get the best results /
we can disscuss the projects details in inbox .
I hope you've got what I want to say .
Don't hesitate to contact me.
Looking forward to disscuss the project details with you
Thanks dude !