Quick project. Sale checking occurs every day at 12:00 UTC.
- turso (database) (dev db is just turso dev)
- resend (email)
- cheerio (scraping)
- vercel (hosting)
- upstash (cronjob)
- Add cheerio to check for sale
- Mockup simple UI
- Setup Database (turso)
- Add database calls to api and frontend
- Seems like we can't have tables with _ in drizzle sqlite (was getting a bug with "on_sale")
- Setup email notifications
- Create email template Interface
- Remade the design (somewhat)
- Add a way to unsubscribe from email notifications
- check if schema has email as unique
- tidy up route api code and handle sending emails only when there is a sale
- Add footer
- Deploy to vercel
- Some more visual tinkering (both email and UI)
- Cleanup README
- Setup cronjob to check for sale (upstash?)
- open graph stuff
- toast
- ratelimit by ip (clouflare, upstash or self implemented)
Checking for a "s" (sale) tag in this url using cheerio
If anyone has a better way to check for sale, please let me know! I just went with the first one that came to my mind.
<s class="u-self-start u-text-boulder u-text-gamma u-strikethrough-sale u-lh-1">
US$ 164,99
</s>
<span class="u-assistive-text"> Custava </span>
<span class="u-assistive-text"> Agora </span>