Repository files navigation

The best way to explore the ProductHunt. Capture every new featured product!

One day, I felt that browsing ProductHunt wasn't very intuitive, so I quickly made a small project using NextJs. It takes screenshots of each new project on ProductHunt, so now I can quickly browse through them every day and easily see if there's anything interesting to me without having to read a lot of text and click around.

• Next.js

• Shadcn UI framework based on Tailwind.

• Supabase Managed postgres database.

• Drizzle Database ORM.

• Logto.io Fully open sourced Auth solution.

• Triggerdev v2.0 Background jobs.

• Resend Email service.

• React Email Write emails without pain.

• ScreenshotOne Screenshot Api.

• Cloudflare R2 Image storage.

• Umami Website Analytics

• Koyeb Paas Service.

Before deployment, make sure you know all the services or tools above clearly. It may take some time.

# setup trigger api key and endpoint url.# https://trigger.dev/TRIGGER_API_KEY=TRIGGER_API_URL=NEXT_PUBLIC_TRIGGER_PUBLIC_API_KEY=# setup Producthunt API access token# https://api.producthunt.com/v2/docsPH_ACCESS_TOKEN=# setup postgres database url.# https://supabase.comDATABASE_URL=# setup screenshot one api.# !remember to setup s3 extension on ScreenshotOne.# https://screenshotone.com/SCREENSHOTONE_ACCESS_KEY=SCREENSHOTONE_SIGNED_KEY=# setup resend email service api# https://resend.comRESEND_KEY=RESEND_AUDIENCE_ID=# cloudflare r2 endpoint url.NEXT_PUBLIC_CLOUDFLARE_R2=# setup Logto user authentication# https://logto.ioLOGTO_APPID=LOGTO_APP_SECRET=LOGTO_BASE_URL=LOGTO_COOKIE_SECRET=LOGTO_ENDPOINT=

After Env vars, generate and migrate the database table:

pnpm db:generatepnpm db:migrate

after migration, run the following sql at supabase or from any postgres client, to create table view:

create view  sortedphsasselect  row_number() over (order by      added_atdesc  )as row_no,*from  producthuntwhere  webp= true;

after that, run the dev server.

pnpm ipnpm run dev

open another terminal, run the trigger service.

pnpm triggerdev

If you want to create email template, open a new terminal, and run:

pnpm email dev

Openhttp://localhost:3000 with your browser to see the result.

• screenshot YC companies

You can view all the dev plan onthis Kanban.

Any idea or bugs?Submit issues orleave a comment on my twitter !