We want to stream or push certain text outputs to an audience. We have a spreadsheet which is monitoring a large dataset for changes and values. Once certain criteria is met we generate an output in real time to the SQL dbase. The spreadsheet typically generates a few thousand lines of output per day.
1. The output will be similar to this
INSERT INTO TableName (Company, Field1,Field2,Field3) VALUES (ABC,10,8,Yes)
The dbase will take that line and input the values into the corresponding Company Name, Fields1, 2, 3 in the dbase.
2. The dbase will perform a count on how many instances a particular output is received for a Company.
3. Publish in real-time from SQL to webpage, using JQuery, AJAX or any other technology, Pls specify what tools you will use.
4. Users need to be able to select filters on the queries/data stream, PHP scripting for users to select based on multiple fields that tie back to the SQL dbase fields.
5. User registration and permissioning.
6. Clean and minimalist website design. Around 10 pages max.
7. Ideally should be in CMS form where I can update some pages when I need to or add in components.
In order to be considered, pls outline what technologies you would use, and what similar projects you have done. Any portfolio reference is welcome. Any questions or clarifications are also welcome. Thank you.
