PostgreSQL Email Lists, with a more readable interface
postgres.email
A website to display all Postgres emails.
This is a small POC to transform the Postgres mailing lists more readable.
As a comparison:
The idea of postgres.email is to make all responses threaded, like the comments on HN or Reddit.
This uses an imap Foreign Data Wrapper to ingest the messages into a Postgres database. For the POC, only ingested 1000 messages, and it doesn't display attachments.
The technologies used are:
Given the size of the mailing lists, I doubt the current approach will scale much further than the POC, so I'll need to re-think the architecture. I'll probably keep the emails in gmail and and leverage the FDW for older messages.
Some things I'd like to do next:
To run your Remix app locally, make sure your project's local dependencies are installed:
npm install
Afterwards, start the Remix development server like so:
supabase start
npm run dev
Open up http://localhost:3000 and you should be ready to go!