Devam Ediyor

Need help publishing mysql data to mongo

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.

Beceriler: HTML, MySQL, NoSQL Couch & Mongo, PHP

Daha fazlasını gör: website to improve, website to find developers, to hand out, team approach database, static website developers, mysql data access, is there a website to find developers, first volunteer, find someone to help with building a website, code needed to build up a website, php mongo, mongodb php, go data feed, steps to make website, nosql php, need mysql developers, need a developers help, mysql for php developers, mongo, model view controller, json nosql, json and mysql, huge data building, html publishing, html developers needed

İşveren Hakkında:
( 7 değerlendirme ) Rockville, United States

Proje NO: #6553714

4 freelancers are bidding on average $177 for this job


Hi Sir I am a lead programmer as i have 10 years of working experience in php,mysql,wordpress, joomla, drupal, smarty, codeigniter, cakephp, YII, red5, zend, moodle, ajax, jquery, javascript, css, html, Graphics Des Daha Fazla

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(31 Değerlendirme)

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.

in %bids___i_period_sub_35% gün içinde175%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(88 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)

La propuesta todavía no ha sido proveída

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)