Skip to content

Latest commit

 

History

History
32 lines (20 loc) · 984 Bytes

README.md

File metadata and controls

32 lines (20 loc) · 984 Bytes
Raw

SQL Music Synthesiser

Using PostgreSQL to synthesise Twinkle Twinkle Little Star.

Getting Started

Clone the repository or download synthesiser.sql. Run the SQL code to recreate the table and views. Feel free to tweak the table music_sheet to play any other melody.

To generate the WAV file, run the bash command below.

psql -U postgres -qAt -c "select encode(file,'base64') from v_wav limit 1" | base64 -d > /tmp/twinkletwinkle.wav

If you don't have a PostgreSQL environment set up, you can spin one up via Docker using the official image "postgres" as shown below. Note that this server won't be secured.

docker run -e POSTGRES_HOST_AUTH_METHOD=trust  -p 5432:5432 postgres

Once you've created the file, you can copy the file out of Docker with the following command.

docker cp container_name:/tmp/twinkletwinkle.wav twinkletwinkle.wav

Authors

  • Ramiro Medina

License

This project is licensed under the MIT License.