3 ms·

Hey HN, yesterday we shared a post[0] about how you can store OpenAI embeddings in Postgres with pgvector. This is a follow up demonstration, adding a "ChatGPT

Hey HN, yesterday we shared a post[0] about how you can store OpenAI embeddings in Postgres with pgvector. This is a follow up demonstration, adding a "ChatGPT" interface to our own docs. To use it, you can go to https://supabase.com/docs https://supabase.com/docs and then type "cmd + /". This will pull up a "Clippy" interface, where you can ask it questions about supabase (sorry in advance to mobile users) In "Show HN" spirit, it's very hacky/MVP, so I expect it will break. We'd value any feedback. [0] Storing OpenAI embeddings in Postgres: https://news.ycombinator.com/item?id=34684593 https://news.ycombinator.com/item?id=34684593

kiwicopple 4y ago
If you want to build something like this yourself, we sponsored Greg to create a video detailing all the steps: https://www.youtube.com/watch?v=Yhtjd7yGGGA https://www.youtube.com/watch?v=Yhtjd7yGGGA Also special shoutout to pgvector (https://github.com/pgvector/pgvector https://github.com/pgvector/pgvector), which is used to store all of the embeddings.
- Yenrabbit 4y ago
  This is so great! Thank you, and Greg if you read this well done on an excellent video and project
  - gregnr 4y ago
    Thanks! I've a had a blast working with Supabase on this, glad to hear that you find it interesting!
- btown 4y ago
  Note that pgvector isn't supported on any of the large cloud providers' hosted Postgres offerings, other than Supabase. https://github.com/pgvector/pgvector#hosted-postgres https://github.com/pgvector/pgvector#hosted-postgres has instructions on how to add your voice to request it to be added! (It does seem that the ancient https://github.com/eulerto/pg_similarity https://github.com/eulerto/pg_similarity is supported by RDS and Google Cloud - but it's hard to tell whether attention was paid to its performance characteristics with nearly the rigor that pgvector seems to have been designed.)
moooo99 4y ago
Feedback: Please add a button. This seems super useful, but unfortunately I can't test it. I'm on a non US Layout and can't use the shortcut "cmd + /". On my keyboard a "/" is opt + 7 and using "opt + cmd + 7" unsurprisingly does nothing.
- kiwicopple 4y ago
  thanks for the feedback - we'll add a button as soon as OpenAI approves our increased spend-cap request
- saltcod 4y ago
  Thanks for this. Added a button to the navbar. Sorry about the delay there.

kiwicopple 4y ago

If you want to build something like this yourself, we sponsored Greg to create a video detailing all the steps: https://www.youtube.com/watch?v=Yhtjd7yGGGA https://www.youtube.com/watch?v=Yhtjd7yGGGA Also special shoutout to pgvector (https://github.com/pgvector/pgvector https://github.com/pgvector/pgvector), which is used to store all of the embeddings.

Yenrabbit 4y ago
This is so great! Thank you, and Greg if you read this well done on an excellent video and project
- gregnr 4y ago
  Thanks! I've a had a blast working with Supabase on this, glad to hear that you find it interesting!
btown 4y ago
Note that pgvector isn't supported on any of the large cloud providers' hosted Postgres offerings, other than Supabase. https://github.com/pgvector/pgvector#hosted-postgres https://github.com/pgvector/pgvector#hosted-postgres has instructions on how to add your voice to request it to be added! (It does seem that the ancient https://github.com/eulerto/pg_similarity https://github.com/eulerto/pg_similarity is supported by RDS and Google Cloud - but it's hard to tell whether attention was paid to its performance characteristics with nearly the rigor that pgvector seems to have been designed.)

moooo99 4y ago

Feedback: Please add a button. This seems super useful, but unfortunately I can't test it. I'm on a non US Layout and can't use the shortcut "cmd + /". On my keyboard a "/" is opt + 7 and using "opt + cmd + 7" unsurprisingly does nothing.

kiwicopple 4y ago
thanks for the feedback - we'll add a button as soon as OpenAI approves our increased spend-cap request
saltcod 4y ago
Thanks for this. Added a button to the navbar. Sorry about the delay there.