diff options
Diffstat (limited to '')
| -rw-r--r-- | media/spectrogramming.mp3 | bin | 0 -> 490509 bytes | |||
| -rw-r--r-- | media/spectrogramming.mp4 | bin | 0 -> 294151 bytes | |||
| -rw-r--r-- | src/spectrogramming.audio.sql | 15 |
3 files changed, 15 insertions, 0 deletions
diff --git a/media/spectrogramming.mp3 b/media/spectrogramming.mp3 Binary files differnew file mode 100644 index 0000000..267401c --- /dev/null +++ b/media/spectrogramming.mp3 diff --git a/media/spectrogramming.mp4 b/media/spectrogramming.mp4 Binary files differnew file mode 100644 index 0000000..1abc5be --- /dev/null +++ b/media/spectrogramming.mp4 diff --git a/src/spectrogramming.audio.sql b/src/spectrogramming.audio.sql new file mode 100644 index 0000000..3add75f --- /dev/null +++ b/src/spectrogramming.audio.sql @@ -0,0 +1,15 @@ +INSERT OR REPLACE INTO audio_tracks (id, sample_rate, format) VALUES ('spectrogramming', 8000, 'u8') RETURNING id; + +WITH RECURSIVE + audio AS + (SELECT *, 160 AS gain FROM audio_tracks WHERE id = 'spectrogramming'), + note_positions(position) AS + (SELECT 0 UNION ALL + SELECT position + 1 FROM note_positions, audio + WHERE position < 100000), + samples(value, position) AS + (SELECT + (100.0*SIN(position * 2.0 / sample_rate) + 1.0) / 2.0 * gain + , position + FROM note_positions, audio) +INSERT INTO audio_track_samples (audio_track_id, value, position) SELECT 'spectrogramming', value, position FROM samples ORDER BY position; |