Show HN: View and search Postgres mailing lists(pg.lantern.dev)

2 pointsby diqivor 2 Jahren2 comments

pg.lantern.dev

Show HN: View and search Postgres mailing lists

https://pg.lantern.dev/

I built a site to browse the Postgres mailing list archives. It supports search using full text search from Postgres + vector search with the Lantern Postgres extension.

I've been using it for testing but cleaned it up a bit to share. :) Hopefully it's interesting to someone.

2 comments

skeptrunevor 2 Jahren

Wow! Really cool. Cheers for the scraping portion being open source. I had fun searching for some of my postgres pain points and reading old discussion :).

I'm curious how you're determining the cutoff point for showing results?

Expand and hide for emails in thread is a really nice UI touch.

It would be cool if there were a way to search across all the channels at once.

On a similar note, the search query changing when I click on different threads is also a pain.

Search query in the URL would be cool for sharing functionality.

Noticed that there are sub-sentence highlights in the sidebar selector, but not the larger email thread view. Having them in the larger view would make it a bit easier to grok the results for me.

diqivor 2 Jahren

Thank you!

It’s just naively showing the first 20 results at the moment from FTS or vector search.

Thanks for the feedback! I’ll make some edits.

You can actually search all the channels at once if you “deselect” the channel in the left! But I know that can be improved as well