StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8070192
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-11-09T19:06:48.233
FavoriteCount
0
LastActivityDate
2011-11-09T19:33:26.337
LastEditDate
2011-11-09T19:33:26.337
LastEditorUserId
596781
OwnerUserId
596781
ParentId
8070106
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Your question isn't very specific, so I can only recommend some general ideas. You might like to read the file in chunks, for example 4096 bytes at a time (that's the typical page size) -- though larger chunks should also be fine (maybe 64kiB or 512kiB even, just experiment). Once you got a chunk read, process it from memory. To be correct, we should generate the chunk memory as an array of the target integer. For example, for 4-byte integers we could do this: <pre><code>#include <cstdint> #include <memory> #include <cstdio> uint32_t buf[1024]; typedef std::unique_ptr<std::FILE, int (*)(std::FILE *)> unique_file_ptr; static unique_file_ptr make_file(const char * filename, const char * flags) { std::FILE * const fp = std::fopen(filename, flags); return unique_file_ptr(fp ? fp : nullptr, std::fclose); } int main() { auto fp = make_file("thedata.bin", "rb"); if (!fp) return 1; while (true) { if (4096 != std::fread(reinterpret_cast<char*>(buf), 4096, fp.get())) break; // process buf[0] up to buf[1023] } } </code></pre> I chose the C-library <code>fopen</code>/<code>fread</code> over C++ iostreams for performance reasons; I cannot actually claim that that decision is based on personal experience. (If you have an old compiler, you might need the header <code><stdint.h></code> instead, and perhaps you don't have <code>unique_ptr</code>, in which case you cah just use <code>std::FILE*</code> and <code>std::fopen</code> manually.) Alternative to the global <code>buf</code>, you could also make an <code>std::vector<uint32_t></code>, resize it to something large enough and read into its data buffer directly (<code>&buf[0]</code> or <code>buf.data()</code>). If you need to read integers that are not 2, 4, 8 or 16 bytes long, you'll have to read into a char array and extract the numbers manually with algebraic operations (e.g. <code>buf[pos] + (buf[pos + 1] << 8) + (buf[pos + 2] << 16)</code> for a 3-byte integer). If your packing isn't even byte-aligned, you'll have to make an even greater effort.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to read bitN integer data from a binary file?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USKerrek SB
UserOwnerUserId
1. USKerrek SB
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.