You are browsing as a guest. Sign up (or log in) to start making projects!

SaralRates

By @Shish

  • 5 Devlogs
  • 9 Total hours

I DID NOT COMPLETE THIS PROJECT IN 9 HOURS. I WORKED ON IT DURING FLAVORTOWN (see here -> https://flavortown.hackclub.com/projects/3197) WITH 71+ HOURS IN TOTAL. This is an update to the project that I made for Flavortown. Saral Rates is a website for traders and farmers to check prices of different commodities published by the Indian Government daily. Valid for Indian users only. Useful for traders and farmers so that the middleman doesn’t scam you.

Source
Ship #1

@Shish on SaralRates

I have previously worked on this project on Flavortown so don’t misunderstand that i made this project in just 9 hours (it actually took 70+ hours in total)

In this version, I have migrated database from mongoDB to MariaDB and migrated frontend from React to Next and moved hosting from render, now my Raspberry pi handles the data and cron jobs. I set up a private cloudflare tunnel so that my pi can serve the data securely. There is also a new filter added which allows you to see commodities according to state and their districts.

So, the main purpose of this project of mine is to help the farmers so that the middle man can’t exploit them. For now, very less people including some of family members who are into vegetable/fruit business use it :(

I hope you guys like it. So much effort has been put into this project and I will keep working on it as I keep learning new new things.

While updating this project, I learnt a lot about backend like tunnels. I also learnt more about NextJS and MySQL, like making tables and makking joins between different tables.

Hardest thing was the backend as I wasn’t able to visualise properly what is happening so I had to take help of AI.

  • 5 devlogs
  • 9h
Try project → See source code →
Open comments for this post

@Shish on SaralRates

29m 20s logged

v(1.0.0) Completed!

Updates

  • I have decided to complete the project and focus on other projects for now. This project was very fun to work with!
  • in these 25 mins, I wrote the README.md file, changed the version across the site and did pretty much small tasks that do not affect the functionality of the website!
  • Changed the filter button style
0
0
8
Open comments for this post

@Shish on SaralRates

1h 18m logged

v(0.8.2-Beta) Adding new features

Updates

  • Disconnected from render now render doesn’t feed data to my website.
  • fixed a broken image logic on LaunchModal.jsx
  • Removed dead code (from previous version)
  • Added new feature of filtering by states and districts
  • databse has around 14k commodities (last 31 days) but website shows only last 7 days. (in future, I will add trends of larger window)
  • card share feature is glitched (again) so tried to work on it but couldn’t fix it properly. (thinking of removing it completely)
0
0
10
Open comments for this post

@Shish on SaralRates

2h 18m 52s logged

v(0.8.1) Migration

Updates

  • first of all, I was REALLY busy with my school so couldn’t code much. So, I started working on this project since a couple of days.
  • So, we have successfully migrated and now my Raspberry Pi has the data and all
  • made a private cloudflare tunnel so that I don’t expose my Pi. THANKS CLOUDFLARE!
  • also installed pm2 on rpi so that backend can run continuously
  • Had problems while migrating (that’s why you can see multiple similar commits)
  • All this was obviously very new for me so I took help of AI for creating the cloudflare part
  • As of today, we only have 246 commodities :(

What next?

  • I’ll be working on enhancing the cron job
0
0
3
Open comments for this post

@Shish on SaralRates

3h 5m 4s logged

v(0.8.1-beta) Migration

Updates

  • Read and accessed data from the rpi. So, my thinking here is that, I would have my rpi fetch all the data everyday and store it in mysql (which is on rpi). THEN, I will read and access that data and give it to the frontend and display it! (i dokn’t know if it is going to work or not BUT so far, I am able to read and access the data)
  • Deleted mongoose and installed mysql to the project
  • I have been working on dummy data so I don’t know if it is fully functional or not.

What next?

  • I will be setting up a job for rpi to fetch data from govt. api every day.

Change log

  • 9fae860: read and access data from rpi
  • 5b95a47feat: daily fetch
  • 8dcef72docs: add dummy data
  • aefed79docs: delete mongodb files
  • 41f198ddocs: uninstall mongoose and install mysql
  • 6eeda2edocs: update README
  • 1539c69feat(api): daily fetch
0
0
2
Open comments for this post

@Shish on SaralRates

1h 56m 27s logged

v(0.8.0-beta) Migration

Updates

  • Migrated from ReactJS to NextJS (For better SEO)
  • Tackled some bugs while doing so
  • Made sure everything still works
  • As of today we have data of 33k commoditeis!!!

What next?

  • Now I will be doing a tedious job of adding ‘alt’ to all the images and look for more ways to do better SEO
  • Then I need to migrate from MongoDB to MySQL and i’ll be storing all the data of commodities on my Raspberry Pi 5. I chose MySQL because if I use it, it might also help me in my school examinations i.e I’ll get my hand on SQL properly :)
  • I also have tons of new ideas that I can implement using MySQL but i’ll keep them for upcoming devlogs

Changelog

0
0
6

Delete project?

Are you sure you want to permanently delete this project? This action cannot be undone.

All devlogs, followers, and associated data will be removed.

Followers

Loading…