This Streamlit app facilitates exploration and querying of an e-commerce catalog ingested from a JSON file into an SQL database. Users can search products by title, category, or unique ID, with efficient handling of hierarchical categories.
- Ingestion: Ingests catalog data from a JSON file into an SQL database.
- Querying: Allows users to search for products based on title, category, or unique ID.
- Hierarchical Categories: Handles category fields efficiently, enabling navigation through hierarchical categories.
- Requirements: This project requires Python and the dependencies listed in
requirements.txt.
- Clone this repository.
- Set up a Python environment using virtualenv or conda.
python3 -m venv .venvthensource .venv/bin/activate. - Install dependencies using
pip install -r requirements.txt. - Run the Streamlit app:
streamlit run app/main.py.
- run
docker compose upto spin up the postgres image
- Upload your JSON catalog file.
- Use the provided search functionality to explore the catalog.
- Enjoy seamless querying and navigation through product categories.
- [Eshaan Sudan]
- [Vedang Bohra]