Google Summer of Code

After moving around the demo and getting ideas from it let's have a deep dive into the main implementation!

My Deno environment and the Supabase are all set so I started coding for the main implementation!

As discussed earlier with mentors, I just created the database schema and got to understand the structure, how the JSON is stored of package data, and how we are retrieving it so that I can manage the SQL code accordingly. Then I implemented it in Supabase through their SQL editor. We can use the Supabase SQL editor to create the table and make queries or changes on the table from that editor. These changes are reflected in the Supabase table editor; you can also use the table editor for creating the same as you can do with the SQL editor.


THIS IS HOW YOU CAN CREATE ROW AND COLUMN DIRECTLY FROM THE TABLE EDITOR.

After implementing this, I am moving on to the Deno script and trying to code the function that fetches the data from Packagist and stores it in Supabase!

After generating the Deno script, I communicated my progress to my mentors and demonstrated the Deno script's functionality. They helped me to solve my errors and suggested a few things to me about improving the code!

During the next meeting, we talked about the data structure that is needed for the project. We discussed how I can loop through the code to fetch the data.

In this, I made a mistake by not testing all the possible scenarios for how it works with the data. I assumed that all the logic may work properly! But it has some catch which we will see in the next blog post.

Challenges :

 I faced the errors in my code and something went wrong with my environment. I tried hard to solve it but overlooked some errors in this process, my mentors helped me to solve those errors!

I also started to commit my code to the repository.

For Next Week : 

I’m planning to fetch all the plugin data and themes data, I will test this script by tracking the data in the database.

Anything you want to ask related to my project, please do comment below! 

Thanks for your valuable time!