StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
7867851
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-10-23T17:32:12.740
FavoriteCount
0
LastActivityDate
2011-10-23T17:32:12.740
LastEditDate
LastEditorUserId
0
OwnerUserId
1007856
ParentId
7867723
PostTypeId
2
Score
6
ViewCount
0
LastEditorDisplayName
text
Body
Daniel Wagner's solution is a great one. Here is another swing at it so you can get some more ideas about efficient file handling. <pre><code>{-# LANGUAGE OverloadedStrings #-} import System.IO import qualified Data.ByteString.Lazy.Char8 as B import Control.Applicative import Data.List sumNums :: B.ByteString -> Int sumNums s = foldl' sumStrs 0 $ B.split ' ' s sumStrs :: Int -> B.ByteString -> Int sumStrs m i = m+int where Just(int,_) = B.readInt i main = do sums <- map sumNums <$> B.lines <$> B.readFile "testy" print sums </code></pre> First, you'll see the OverloadedStrings pragma. This allows use to just use normal quotes for string literals that are actually bytestrings. We will be using Lazy ByteStrings for processing the file for several reasons. First, it allows us to stream the file through the program rather than forcing it all into memory at once. Also, bytestrings are faster and more efficient than strings in general. Everything else is pretty much straightforward. We readFile the file into a lazy list of lines, and then map a summing function over each of the lines. The <code><$></code> are just shortcuts to allow us to operate on the value inside of IO() functor -- if this is too much I apologize. I just mean that when you readFile you don't get back a ByteString, you get back a ByteString wrapped in IO an IO(ByteString). The <code><$></code> says "Hey' I want to operate on the thing inside the IO and then wrap it back up. B.split separates each line into numbers based on whitespace. (We could also use B.words for this) The only other interesting part is the in <code>sumStrs</code> we use deconstruction/pattern matching to extract the first value out of the Just that is returned by the readInt function. I hope this was helpful. Ask if you have any questions.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHaskell file reading
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USErik Hinton
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
CommentsPostId
1. COThank you! Your way has a lot more syntax that I'm not familiar with, but I will use it for reference when I get a chance to expand my knowledge for Haskell. (just starting) :)
 singulars
 PostPostId
 PO
 UserUserId
 USDustBunny

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.