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.
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!
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.
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
on
SaralRates
