traderjoes's Introduction

Trader Joe's Price Tracking

Updated daily at traderjoesprices.com. Download full price history (.csv).

All product prices are sourced from the Chicago South Loop location, store code 701.

$ nix shell github:cmoog/traderjoes
$ traderjoes fetch
running...
requesting page 1
requesting page 2
...

$ sqlite3 traderjoes.db -csv -header
sqlite> SELECT * FROM items ORDER BY inserted_at DESC LIMIT 4;
sku,retail_price,item_title,inserted_at,store_code,availability
055691,3.49,"Scandinavian Swimmers","2024-02-15 14:31:29",701,1
063192,3.99,"Cauliflower Pancakes","2024-02-15 14:31:29",701,1
063486,2.99,"Organic Kansas City Style BBQ Sauce","2024-02-15 14:31:29",701,1
063277,1.49,"Red Chili Scalloped Crackers","2024-02-15 14:31:29",701,0

$ traderjoes gen
# generates site in ./site

Dedication

This project is dedicated to Trader Joe's Hyde Park in Chicago. Store code 706.

traderjoes's People

Contributors

Stargazers

Watchers

traderjoes's Issues

Consider opening up access to dataset

I'm not much of a data whiz myself, but there's a lot of really smart people who can do really interesting things when they get access to an open set of data. There's a lot of ways you could approach it if you wanted to do it, with varying complexity. Some ideas:

Occasionally when it's convenient, add a snapshot of the DB to this repo
Push a version to a static hosting site when your cron job finishes
This seems like more effort to set up, but is kinda neat https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages/
There was a tool posted on HN at one point that let you share SQLite DBs in the browser, but can't remember the name of it.
... a million other ways i'm sure you're aware of

Definitely not required, so do what makes the most sense for you with this project. It's great, thanks for sharing it!