spesaccia

the first site to compare supermarket prices

Why

The reasons why we decided to create this product is the current historical moment (2022) with an ongoing war in europe and a problem related to fuels and gas. The high price is driving the cost of all goods, including food. With this tool we want to help families and allow them to save some money by comparing the same product on different markets.

for the demo visit

                                                   www.spesaccia.com

link github

Link github

Insights into the app 🔎

stack

API

php vanilla
mysql

Frontend

ReactJS
Axios

Data Scrape

n8n
mysql

Setup

Api
- copy api
- change config.php
- import migrate.sql in new database
Frontend
- npm run build for have build in /build list
- copy in your frontend path
Data
- install n8n
- add mysql connection
- import json of flow for automating scraping of price

About

Lorenzo Nunzi We are Passionate technology user, Enthusiast early adopter of Blockchain, Seriuos and steady Fullstack Engineer, Lover of Computer Security.

Built With 🛠

Data
- n8n for data scraping automation
Frontend
- reactjs
- bootstrap
Api
- php
- mysql

Todo for future

[ ] User registration
[ ] Favorite products
[ ] Splitted order list by Market
[ ] Add more market

Package Structure

spesaccia-fe
├── api
│   ├── config.php
│   ├── controllers
│   │   └── products.php
│   ├── dev.config.php
│   ├── index.php
│   ├── libs
│   │   ├── api.php
│   │   ├── cache.php
│   │   ├── db.php
│   │   ├── logs.php
│   │   └── tpl.php
│   └── site.log
├── asset-manifest.json
├── favicon.ico
├── index.html
├── logo192.png
├── logo512.png
├── logo.jpg
├── manifest.json
├── robots.txt
└── static
    ├── css
    │   ├── main.0540677d.chunk.css
    │   ├── main.0540677d.chunk.css.map
    │   ├── main.0d3226c9.chunk.css
    │   └── main.0d3226c9.chunk.css.map
    ├── js
    │   ├── 2.8857d985.chunk.js
    │   ├── 2.8857d985.chunk.js.LICENSE.txt
    │   ├── 2.8857d985.chunk.js.map
    │   ├── 2.d421368b.chunk.js
    │   ├── 2.d421368b.chunk.js.LICENSE.txt
    │   ├── 2.d421368b.chunk.js.map
    │   ├── main.0dc256da.chunk.js
    │   ├── main.0dc256da.chunk.js.map
    │   ├── main.403a2550.chunk.js
    │   ├── main.403a2550.chunk.js.map
    │   ├── main.4bce94e6.chunk.js
    │   ├── main.4bce94e6.chunk.js.map
    │   ├── runtime-main.3eca5ed2.js
    │   └── runtime-main.3eca5ed2.js.map
    └── media
        ├── rsc.4e43a00f.woff
        ├── rsc.a6e421b3.ttf
        └── rsc.b43c5231.svg

Want to discuss? 💬

Have any questions, doubts or want to present your opinions, views? You're always welcome. You can start discussions in telegram.

Contact 📩

Have an project? DM us at 👇

Donation 💰

If this project help you reduce time to develop, you can give me a cup of coffee :)

Made using Linode for the Hashnode X Linode Hackathon

nunzilor