StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
38203
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2008-09-01T17:48:33.683
FavoriteCount
0
LastActivityDate
2016-02-09T21:40:46.167
LastEditDate
2016-02-09T21:40:46.167
LastEditorUserId
19750
OwnerUserId
4085
ParentId
36567
PostTypeId
2
Score
6
ViewCount
0
LastEditorDisplayName
secr
text
Body
<ol> <li>This problem is basically about mapping functions to arrays of numbers. A language that supports first-class functions would come in really handy here.</li> <li>Check out <a href="http://www.harmony-central.com/Computer/Programming" rel="nofollow noreferrer">http://www.harmony-central.com/Computer/Programming</a> and <a href="http://www.developer.com/java/other/article.php/3071021" rel="nofollow noreferrer">http://www.developer.com/java/other/article.php/3071021</a> for some Java-related info.</li> <li>If you don't know the basic concepts of encoding sound data, then read <a href="http://en.wikipedia.org/wiki/Sampling_rate" rel="nofollow noreferrer">http://en.wikipedia.org/wiki/Sampling_rate</a></li> <li>The canonical WAVE format is very simple, see <a href="http://www.lightlink.com/tjweber/StripWav/Canon.html" rel="nofollow noreferrer">http://www.lightlink.com/tjweber/StripWav/Canon.html</a>. A header (first 44 bytes) + the wave-data. You don't need any library to implement that.</li> </ol> In C/C++, the corresponding data structure would look something like this: <pre class="lang-cpp prettyprint-override"><code>typedef struct _WAVstruct { char headertag[4]; unsigned int remnantlength; char fileid[4]; char fmtchunktag[4]; unsigned int fmtlength; unsigned short fmttag; unsigned short channels; unsigned int samplerate; unsigned int bypse; unsigned short ba; unsigned short bipsa; char datatag[4]; unsigned int datalength; void* data; //<--- that's where the raw sound-data goes }* WAVstruct; </code></pre> I'm not sure about Java. I guess you'll have to substitute "struct" with "class" and "void* data" with "char[] data" or "short[] data" or "int[] data", corresponding to the number of bits per sample, as defined in the field bipsa. To fill it with data, you would use something like that in C/C++: <pre class="lang-cpp prettyprint-override"><code>int data2WAVstruct(unsigned short channels, unsigned short bipsa, unsigned int samplerate, unsigned int datalength, void* data, WAVstruct result) { result->headertag[0] = 'R'; result->headertag[1] = 'I'; result->headertag[2] = 'F'; result->headertag[3] = 'F'; result->remnantlength = 44 + datalength - 8; result->fileid[0] = 'W'; result->fileid[1] = 'A'; result->fileid[2] = 'V'; result->fileid[3] = 'E'; result->fmtchunktag[0] = 'f'; result->fmtchunktag[1] = 'm'; result->fmtchunktag[2] = 't'; result->fmtchunktag[3] = ' '; result->fmtlength = 0x00000010; result->fmttag = 1; result->channels = channels; result->samplerate = samplerate; result->bipsa = bipsa; result->ba = channels*bipsa / 8; result->bypse = samplerate*result->ba; result->datatag[0] = 'd'; result->datatag[1] = 'a'; result->datatag[2] = 't'; result->datatag[3] = 'a'; result->datalength = datalength; result->data = data; // <--- that's were the data comes in return 0; // an error code, not implemented, yet ...; in Java: return result } </code></pre> Again, I'm not sure about Java but the conversion should be straightforward if you convert the void-pointer to an array corresponding to the bitrate. Then simply write the entire structure to a file to get a playable wave file.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POBeginner Digital Synth
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USJosh Lee
UserOwnerUserId
1. USsecr
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POBeginner Digital Synth
 singulars
 PostTypePostTypeId
 PTQuestion
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. 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.