nowfound

Dev tools · August 21, 2022

PE

Postgres.email – Readable Mailing Lists

This is a small POC that I've been developing to transform the Postgres mailing lists[0] more readable I've linked to a thread "COPY TO (FREEZE)?" in the Show HN link, and the equivalent on the Postgres mailing list site is here: https://www.postgresql.org/message-id/20220802.133046.194197... The idea of postgres.email is to make all responses threaded, like the comments here on HN or Reddit. I created this by using an imap Foreign Data Wrapper to ingest the messages into a Postgres database. I have only ingested 1000 messages for the POC. It also doesn't display…

What it does

In the maker’s words, at launch

This is a small POC that I've been developing to transform the Postgres mailing lists[0] more readable I've linked to a thread "COPY TO (FREEZE)?" in the Show HN link, and the equivalent on the Postgres mailing list site is here: https://www.postgresql.org/message-id/20220802.133046.194197... The idea of postgres.email is to make all responses threaded, like the comments here on HN or Reddit. I created this by using an imap Foreign Data Wrapper to ingest the messages into a Postgres database. I have only ingested 1000 messages for the POC. It also doesn't display attachments. The code can bew found here: https://github.com/kiwicopple/postgres.email The technologies used are: - Gmail to receive the email - Steampipe for the FDW: https://hub.steampipe.io/plugins/turbot/imap - Supabase for the Postgres database / APIs: https://supabase.com - Remix for the frontend: https://remix.run/ 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: - explore alternative architectures - show attachments - add a REST API - add search - the size of the mailing lists might make this difficult - allow readers to toggle on a "markdown" view. Often authors use markdown syntax in their emails - add a light mode [0] Mailing lists: https://www.postgresql.org/list/

Does the same job

all alternatives →
  • Postcards by Designmodo2018 · ▲157

    Create awesome emails with drag & drop simplicity 😻

  • Postcards 22018 · ▲268

    Create, edit and manage awesome email newsletters 😻

  • Listmonk2019 · ▲322

    Self-hosted newsletter and mailing list manager

  • Postcards 32023 · ▲207

    Refresh your email game with an intuitive email builder + AI

  • Postgres Playground2022 · ▲161

    Hands-on tutorials to learn Postgres

  • Polybox Email Templates2020 · ▲120

    Solution for email creating in coded templates and modules

More dev tools this month

the category →
  • Dograh592

    The open source VAPI alternative

    Dev tools · 25d ago · dograh.com

  • Meridian530

    Don't let your work go unnoticed. Get promoted!

    Dev tools · 20d ago · meridiona.com

  • x1516

    Lovable for iPhone apps go from idea to App Store

    Dev tools · 11d ago · x1.new

  • Open-source GTM skills for technical founders

    Dev tools · 29d ago · gtmcofounder.com

  • OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.

    Dev tools · 1d ago · opentrailpaper.com

  • Nuphos380

    The AI-Native DevOps Workspace.

    Dev tools · 24d ago · nuphos.ai

Launched alongside, August 2022

the whole month →
  • Xnapper1,517

    Take beautiful screenshots instantly

    Work · 2022 · xnapper.com

  • Gamma1,169

    Write like a doc, present like a deck

    Work · 2022 · gamma.app

  • Threado923

    The command center for community builders

    Life & fun · 2022

  • Build remote engineering teams in 24 hours

    Dev tools · 2022 · remotebase.com

  • Convert Figma designs into Flutter 3.0 & React code rapidly

    Dev tools · 2022 · dhiwise.com

  • PA

    Hey HN, I've been working on https://pornpen.ai, a site for generating adult images. Please only visit the site if you are 18+ and willing to look at NSFW images. This site is an experiment using newer text-to-image models. I explicitly removed the ability to specify custom text to avoid harmful imagery from being generated. New tags will be added once the prompt-engineering algorithm is fine-tuned further. If the servers are overloaded, take a look at the feed and search pages to look through past results. For comments/suggestions/feedback please visit…

    AI · 2022 · pornpen.ai