Day 3 of Building a Spotify Clone in 30 days using Flutter

2 min readOct 9, 2019

On the Day 3 article of the series we are going to talk about Database design, and this is actually something we need to be taken care of so as the app fastness and scalability deponds on

In order to make you guys understand of building the database design i decided to create a json file and explain you guys how data is organised.

Repo Link : https://github.com/theflutterdev/Spotify-Clone-using-Flutter

😂😂😂Joke apart now let’s with design stuff

These are what we want to have

Songs
Playlists
Liked music
Artists
Albums
Categories
History
Playlist History

And we need to make the database which will be consistent for both searching and user recommendation stuff and i thought for a while and came up with an bold knowledge of data representation.

So, i decided to divide the entire database in to 5 part’s

Users Data
Artists Data
Categories Data
Songs Data
Albums Data

So, let’s get to each of these parts and check out how the database design is going to be

I hope you guys understand most of the things by watching the code.

Similarly, let’s have a look at the second on tooo..

This is how the artists data is going to represent and now take a look at the Categories

And now the main thing all our songs data

and finally the albums data

As the we had designed the entire database design it’s time to complete the undone works of Firebase Auth like Forgot password and other related to Database design after signup and then we will be getting started with building the admin panel, So stay tuned for the Day4.

My intention

This project is just to help developing the community/educational purpose and i do not encourage my fellow readers to mess up with any kind of commercial and illegal activities related to the Trademarks/Images and Copyrights used in this Project.

Trademarks rights owned by — Spotify Technology S.A ( Stockholm, Sweden )