We need someone to create a json schema for each of the dynamic pages and save that json in mongo
We are building a website to improve disaster relief and help make civil society NGOs are able to access the resources they need. The site will improve disaster relief/recovery accountability, transparency and effectiveness.
Our team of volunteer developers built a CMS that organizations will log into and enter data, which is captured in mysql.
For the public facing site, which will display all this data being entered to the public via our website, we will need to build templates -- PHP snippets embedded in the static HTML -- to make the pages show the dynamic data. Normally a request would come in, the controller would request the data model and then inject the data object into a view. And we are still going to do that -- the major difference in our approach tho is that instead of the data model asking MYSQL for the data, we are going to ask a NOSQL database called MongoDB for the data, which will return one giant data feed that will represent all the needed data on the public facing page. The reason we are taking this approach is because the data is spread across many takes which will require many joins and also, there is a revisions table that holds a timestamp for every time a field is updated by a CMS user and they need every field to display the corresponding timestamp. This is going to be a huge performance hit and is not scalable solution for when the site starts getting a lot of traffic. MongoDB on the other hand requires no table joins and is very fast and is highly scalable.
The first steps to make this happen is upon every save an organization makes, we need to also send the data to mongo. the data in mongo is json that will represent the data needed to build out one of the pages, so we also need to come up with a json schema for each of the dynamic pages and basically save that json in mongo. one of the tricky parts is that for every field, we need to look it up in the revisions table to get the timestamp. Once this is all set up, the rest of the front end will go quickly since we have a majority of the static html already completed.
Is this something you can/want to help with? Do you think you could find the right spots in our code to also save data to mongo?
We are a small NGO and all of our developers are currently volunteers. We are willing to pay for this job but we're also looking for something at a low cost. Volunteers are welcome.
4 freelancers are bidding on average $177 for this job
HI I m ready to find correct place pass value to mongo. I have 4 years experienced in PHP,MYSQL,AJAJX,JQUERY,HTML,CSS. Ready to start Right now.
Hello sir, I am professional php developer,I have 4 year experience in php development,I read your job,description I am intrestrested to join your job,I am working on codeigniter,wordpress,magento,core PHP,jquery,java Daha Fazla