StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
20707989
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-12-20T16:32:14.947
FavoriteCount
0
LastActivityDate
2013-12-21T02:58:55.663
LastEditDate
2013-12-21T02:58:55.663
LastEditorUserId
914967
OwnerUserId
914967
ParentId
18302242
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
Take a look at this article: <a href="http://howtonode.org/socket-io-auth" rel="nofollow">Session-based Authorization with Socket.IO</a> Your code works fine, but need 2 improvements to do what you want (send session data to clients from server): <ol> <li>it extracts <code>sessionID</code> during authorization only</li> <li>it extracts session data from store by this <code>sessionID</code> during connection where you can send data from server to clients in an interval.</li> </ol> Here's the improved code: <pre><code>var express = require('express'); var connect = require('connect'); var cookie = require('cookie'); var sessionStore = new express.session.MemoryStore(); var app = express(); app.use(express.logger('dev')); app.use(express.cookieParser()); app.use(express.session({store: sessionStore, secret: "secret", key: 'express.sid'})); // web page app.use(express.static('public')); app.get('/', function(req, res) { var body = ''; if (req.session.views) { ++req.session.views; } else { req.session.views = 1; body += 'First time visiting? view this page in several browsers :)'; } res.send(body + 'viewed ' + req.session.views + ' times.'); }); var sio = require('socket.io').listen(app.listen(3000)); sio.set('authorization', function (data, accept) { // check if there's a cookie header if (data.headers.cookie) { // if there is, parse the cookie var rawCookies = cookie.parse(data.headers.cookie); data.sessionID = connect.utils.parseSignedCookie(rawCookies['express.sid'],'secret'); // it checks if the session id is unsigned successfully if (data.sessionID == rawCookies['express.sid']) { accept('cookie is invalid', false); } } else { // if there isn't, turn down the connection with a message // and leave the function. return accept('No cookie transmitted.', false); } // accept the incoming connection accept(null, true); }); sio.sockets.on('connection', function (socket) { //console.log(socket); console.log('A socket with sessionID ' + socket.handshake.sessionID + ' connected!'); // it sets data every 5 seconds var handle = setInterval(function() { sessionStore.get(socket.handshake.sessionID, function (err, data) { if (err || !data) { console.log('no session data yet'); } else { socket.emit('views', data); } }); }, 5000); socket.on('disconnect', function() { clearInterval(handle); }); }); </code></pre> Then you can have a client page under <code>public/client.html</code> at <code>http://localhost:3000/client.html</code> to see the session data populated from <code>http://localhost:3000</code>: <pre><code><html> <head> <script src="/socket.io/socket.io.js" type="text/javascript"></script> <script type="text/javascript"> tick = io.connect('http://localhost:3000/'); tick.on('data', function (data) { console.log(data); }); tick.on('views', function (data) { document.getElementById('views').innerText = data.views; }); tick.on('error', function (reason){ console.error('Unable to connect Socket.IO', reason); }); tick.on('connect', function (){ console.info('successfully established a working and authorized connection'); }); </script> </head> <body> Open the browser console to see tick-tocks! This session is viewed times. </body> </code></pre> 
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POexpress.session.MemoryStore not returning session?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USshawnzhu
UserOwnerUserId
1. USshawnzhu
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.