0

I will be working on a project for my friend. It will involve handling real time user data. Like SO, I would like to let a user login with his/her OpenID. I want advice on

  • MySQL db engine and or design for a real time system
  • authentication mechanisms
  • I am good at CodeIgniter and chances are I will be using it, any other suggestion
  • jQuery has most supporter/users here on SO and I am comfortable with jQuery as well as Prototype, out of these two which one is better or there is any other competitor to these?

The system will have users, who will be using a stand-alone client that will communicate with centralised server, one can have a view of this data on web front end.

halfer
  • 19,824
  • 17
  • 99
  • 186
Kumar
  • 5,038
  • 7
  • 39
  • 51
  • 2
    Please define "real time" in more detail - the term has [multiple meanings in IT](http://en.wikipedia.org/wiki/Real-time_computing) – Pekka Mar 07 '11 at 15:01
  • The term "real-time system" usually refers to something in the industrial or mechanical control domain, where hardware/software has to respond to events with very tight time constraints. – Pointy Mar 07 '11 at 15:02
  • 1
    One tip to share with you would be that you should ask targeted relevant questions rather than vague, overly broad ones. – John Parker Mar 07 '11 at 15:02
  • For any new development, I'd recommend Postgres over MySQL. Especially if you'll be running lots of complex queries. (The kind ORMs love to generate) – Tyler Eaves Mar 07 '11 at 15:02
  • @all: consider real time data to be equivalent of tweets, though it has nothing to do with twitter. – Kumar Mar 07 '11 at 15:04
  • 1
    @Kumar, you mean asynchronous? Ajax calls? – Shoe Mar 07 '11 at 15:05
  • @Kumar you should probably explain in more detail what you are planning to do – Pekka Mar 07 '11 at 15:05
  • @Pekka, I have added details, yes ajax will be involved, obvious – Kumar Mar 07 '11 at 15:10
  • @Kumar so you are looking to implement something like a chat? – Pekka Mar 07 '11 at 15:13
  • @Pekka, nothing like chat, not even remotely similar to chat or tweeting or facebook. consider it as a web front end for a p2p client – Kumar Mar 07 '11 at 15:20
  • @Kumar a p2p server in PHP? O_o ... PHP may not be the best technology for that. Sorry, this is really too broad to be answered meaningfully without more info – Pekka Mar 07 '11 at 15:22
  • @Pekka what would you suggest then? Python? – Kumar Mar 07 '11 at 15:31
  • I have voted to close this as Needs Focus, as it was far too broad to be answerable when it was asked, and the question requirements are even tighter now. – halfer Jun 02 '22 at 09:18

1 Answers1

0

Similar Question : Is there a way to have PHP print the data to a web browser in real time?

Javascript library is your choice.

For real time web applications trends like WebSocket, Server-Sent Events are not supported across all platforms. You might consider checking Push Technology, Comet. Hope this gives you some direction.

Community
  • 1
  • 1
bhu1st
  • 1,282
  • 11
  • 23