InfoBucket

Blazing Easy, cross platform Data management System.

Comment

Inspiration

  1. A lot of people can't find dashboard that suits their needs. If they try paid ones then they cost a lot. So We decided to create a flexible inventory system something that you can adjust as your needs. It is a web-based platform so anyone can use it.
  2. Millions of Trees are cut down each year to create Inventory and other management books in India and across the World. This project can be used by anyone for free and will reduce pollution.

What it does

  1. It helps people to manage inventory.
  2. Business owners can use it for warehouse management.
  3. The inventory can be customized to their needs.
  4. It can be used by anyone, from TODO list management to entire warehouse data storage.
  5. Create models like Products, Invoices, Outvoices and keep track of data.
  6. People can upload their old Excel sheets and it will be converted into Visual Data and forms.
  7. This all comes with a sleek UI and a better User Experience.

How we built it

  1. We started with the idea to create a flexible, available to all inventory system.
  2. Then I designed the Figma wireframes while my teammate converted them into React code. We used create-react-app as the boilerplate and used CSS modules for styling. Created a better architecture based on components and containers.
  3. We stayed up all night designing, changing, updating and looping through the idea. Continuously trying to fix bugs if found.
  4. We Created the Backend for manangement and Authentication giving users functionality to Log in, Signup, other business logic. Used MongoDB for data storage. Took the help of mongoose to work easily with MongoDB and to create Models.
  5. To Store the Excel Files which user uploads we used Google Cloud Storage. Then we hosted the Backend application.
  6. We Hosted the frontend application through Google Firebase for analytics and storage.

Challenges We faced

  1. We spent so much time on making the User Experience elegant that we ran out of time for the Backend.
  2. Converted the uploaded Excel sheet into JSON data which was full of surprises but we overcame with it.
  3. There is an input field where user can write their custom function and we will pass the data to it, The entire code part was hard to design. To take the function, run it securely on the backend and send the results back. But somehow we made it possible.
  4. The hosting providers weren't working so I shortened the Firebase URL( small life hack ).
  5. Connecting to a NoSQL Database was hard. We never did that before and It was really fun to implement that CockroachDB's docs were helpful.

What we learned

  1. I learned about SQL Database. I had always used MongoDB and NoSQL(Scraed of SQL) but for the first time I tried and excelled it.
  2. I learnt how to make designs on Figma. I'm a developer/software person who barely do designing. But this weekend that changed.
  3. I learnt new tricks while building the React Frontend. Creating so much content in so less time, I'm better at writing code now.
  4. Learned how to google & StackOverflow faster.

What's next for InfoBucket

  1. We need to upload the backend into a cloud service. Couldn't do it by now.
  2. Multi-user support, and so much more.
Share this project:

Updates