Google Summer of Code

Hey, welcome back! I hope you are enjoying the journey that's climbing the ladder of learning. I'm also excited to learn new things and share them with you. After setting up the coding environment and Supabase account, I started working on the demo project, which gave me a basic idea for the actual implementation. So I created a dummy JSON file to store the values like package name, description, and many more like this:

The demo project always gives ideas and overviews that help to improve the main implementation.

Then I created the Deno script that fetches packages from JSON and stores them in Supabase. I created the sample database schema and sql queries. 

I successfully stored the data in the created table and that gave me confidence!

How it looks:

I presented a demo to the mentors and asked them how I could make it more suitable for the larger data sets that we’re going to be dealing with. We also discussed the database schema. We discussed the two approaches, for a single table and for two tables, but they have their pros and cons.

The single table has the advantage of simplicity, and we can easily understand the table. It is limited by scalability, but as discussed, we don't have large data, so we can use a single table.
If we use the two tables, then it’s scalable, but it has the complexity of querying joins. So when we want to add new tables or columns in the future, we have to manage all those joins, and it’s very complex.

So finally, I decided to go with the single table! that efficiently stores the database according to our needs in the main project.


Challenges you are facing :

 The demo script was not working properly, which caused me to face some challenges. It may be an installation issue or may be the version issue, so my mentors help me to solve those errors. My migration script also makes some errors, but after taking some time it's solved.

 For next week :

In the next week with the knowledge of tools and basic idea of the main project we will see how it's going on, stay tuned ...... 

Anything you want to ask related to my project comment below! 

Thanks for your valuable time!