SoundzGd | Devpost

Sample
Schema
Sample
Sample
Sample

Inspiration

Spurred on by several university reddit posts asking if anyone wanted to form a band- we decided to create a forum for musicians seeking a band to play with. "Linkedin for bands" was the initial idea pitched for the project. 36 hours later, and the final product truly- SoundzGd

What it does

Connects Bands seeking talented musicians, and musicians seeking bands to join.

How we built it

We used Flask in the front-end. Python in the back-end. CockroachDB and AWS postgresql RDS for the database.

Challenges we ran into

CockroachDB had a widespread certificate failure- issues with the cluster affected not only us, but other hackers as well. We had spent upwards of 20+ hours building the core of our site on CockroachDB, and the failure of it left us reeling and with a completely unusable site. We had to re-code almost everything, and managed in the last hour to restructure parts of our site with AWS RDS.

Accomplishments that we're proud of

After we identified the issue, we spent hours trying to find workarounds. We originally opted to bypass the ssl certificate entirely to interact with the cockroach cluster, but we had other issues the popped up in the implementation of that route. Despite the numerous setbacks, hang-ups, and bugs, we never gave up the momentum- and we managed to make a submission in time.

What we learned

We gained working experience with Flask, AWS, postgresql, and learned how to pivot databases given a service failure.

What's next for SoundzGd

We aim to try and upscale SoundzGd's presence to a global level, dynamically scale our database (with cockroach's serverless option ideally), and launch it as a webapp in the future (hopefully)