Ryan Coughlan
← products

personal project · private · product, design & engineering — solo

Shelfwatch

It watches the price of the books on my Goodreads shelf and pings me when one reaches the number I set.

Shelfwatch's Today screen: two books at their target price, with their price lines

What it is

Shelfwatch watches book prices for my family and myself. Currently it’s not an efficient implementation and would be costly to open up to many users - and while it’s very valuable to us, it’s not something I have an appetite to open up to public use and to invest in making it scalable. It replaces eReaderIQ. It's private, so there's no link, but here's how it works.

I started by importing my Goodreads Want to Read shelf, which was 163 books. Nobody is going to add that many by hand, and I didn't want to.

how it works · sample data, not my real list
  1. Shelfwatch: a Goodreads export loaded, seven books on one shelf

    01Export your Goodreads library and drop the CSV in. Only titles, authors, ISBNs and shelf names are read.

  2. Shelfwatch: a list of books to import, all ticked, with covers

    02Untick anything you don't want. Books with no ISBN are looked up by title and author, and it tells you which.

  3. Shelfwatch: a price history chart with a line per format and a dashed target line

    03Each book gets a price history per shop and format, with your target drawn on it.

  4. Shelfwatch: books still waiting on their target, with how far away each is

    04Today shows what has hit target, then what's still waiting, closest first.

  5. Shelfwatch: the alerts screen with a target alert and a phone push switched on

    05Alerts go to my phone through ntfy, and only when a price is at or under target.

Targets

Each book has a target. Either "ping me at £3" or "ping me when it drops by 30%". You also say whether you want the ebook, the physical copy or either, and it watches the shops that match.

The rule I cared about most was not being nagged. Nothing above target ever sends a push. When a price first gets to target I get one, then another only if it goes lower, or a reminder after 30 days if it's still there. If it climbs back above target it re-arms, so the next dip alerts again. There's no email at all, just the push.

Where it runs

The price checker doesn't run in the cloud. Amazon throws a captcha at cloud servers, so it runs twice a day on a Mac at home and writes to the same database as the website. The cost is that it depends on that Mac being awake. This is what would make it expensive to provide for many users, and I have no incentive to write for scalability

Shop coverage is honest rather than good. Amazon works. When I probed Hive and Waterstones in November, Cloudflare blocked 19 of 22 Hive pages and 14 of 17 Waterstones ones. I don't try to get round that.

I also tried showing a live price when you add a book. It worked, but it was too slow, so I took it out. Now Add only shows a price if the checker already has one from the last day.

Who can use it

I have to approve the account, and I only do this for relatives. Each account only ever sees its own books, and there are tests that try to prove otherwise.

There's no password reset. It's a handful of people, so if someone forgets theirs I delete the account and they sign up again. Not elegant, but it's the right amount of work for now.

built with

  • Next.js
  • TypeScript
  • Neon Postgres
  • Neon Auth
  • Drizzle
  • Tailwind
  • Vercel
  • ntfy
  • Playwright