StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5905906
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-05-06T01:25:44.367
FavoriteCount
0
LastActivityDate
2011-05-06T01:25:44.367
LastEditDate
LastEditorUserId
0
OwnerUserId
56800
ParentId
2332113
PostTypeId
2
Score
19
ViewCount
0
LastEditorDisplayName
text
Body
If you're a relational database developer (as I am), I'd suggest/point out: <ul> <li>Get some experience working with Cassandra before you commit to its use on a production system... especially if that production system has a hard deadline for completion. Maybe use it as the backend for something unimportant first.</li> <li>It's proving more challenging than I'd anticipated to do simple things that I take for granted about data manipulation using SQL engines. In particular, indexing data and sorting result sets is non-trivial.</li> <li>Data modelling has proven challenging as well. As a relational database developer you come to the table with a lot of baggage... you need to be willing to learn how to model data very differently.</li> </ul> These things said, I strongly recommend building something in Cassandra. If you're like me, then doing so will challenge your understanding of data storage and make you rethink a relational-database-fits-all-situations outlook that I didn't even realize I held. Some good resources I've found include: <ul> <li><a href="http://ria101.wordpress.com/tag/cassandra/">Dominic Williams' Cassandra blog posts</a></li> <li><a href="http://www.anuff.com/2010/07/secondary-indexes-in-cassandra.html">Secondary Indexes in Cassandra</a></li> <li><a href="http://www.anuff.com/2011/02/indexing-in-cassandra.html">More from Ed Anuff on indexing</a></li> <li><a href="http://rads.stackoverflow.com/amzn/click/1449390412">Cassandra book (not fantastic, but a good start)</a></li> <li><a href="http://arin.s3.amazonaws.com/pub/docs/WTF-is-a-SuperColumn.pdf">"WTF is a SuperColumn" pdf</a></li> </ul>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POSwitching from MySQL to Cassandra - Pros/Cons?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. UScodemonkey
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. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COThe link to WTF-is-a-SuperColumn.pdf doesn't work, do you perhaps have a copy of it?
 singulars
 PostPostId
 PO
 UserUserId
 USFlo

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.