Why?

I want to populate my feed from udisc scorecards.

How?

To Dos

  • Upload to s3 ✅ 2023-09-16
  • download file, turn to json ✅ 2023-09-16
  • delete table ✅ 2023-09-16
  • create table ✅ 2023-09-16
  • load json data ✅ 2023-09-16
  • Populate feed ✅ 2023-09-16
  • Change how nextjs loads data ✅ 2023-09-16

After Thoughts

This was insanely easy after the building blocks were in place:

  • Example kestra flow
  • Example sql to populate the feed
  • Example sql to regenerate its part of the feed
  • Easy way to upload a CSV
  • Next.js already knows its DB connection string, I just changed the sql, changed the Typescript type, and I’m off to the races rendering the data