Top all-time · #3623
PostgresML
Company blog · postgresml.org/blogdataaiprogramming
PostgresML is the company blog at postgresml.org, writing about data, ai and programming. Since 2022, 21 different Hacker News readers have linked it 79 times, most often “Show HN: PostgresML, now with analytics and project management”. No feed was found, so read it on the site itself.
Too few sampled comments (12) to say how often HN recommends it.?
Why HN links it
HN readers link PostgresML's blog and docs on running ML and RAG inside Postgres, including hybrid search, the Korvus library and the pgml extension. Comments mostly point to these pages as references.
Summarised by Claude from a sample of 12 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Run embeddings, vectors, and open-source LLMs on GPU-backed Postgres. Build RAG and ML apps with SQL or the Python and JavaScript SDKs.
Most-linked posts?
- Show HN: PostgresML, now with analytics and project management3 people · 5 mentions · first linked 2022-05-02
- PostgresML is 8-40x faster than Python HTTP microservices2 people · 4 mentions · first linked 2022-10-19
- Tuning vector recall while generating query embeddings in the database2 people · 4 mentions · first linked 2023-04-28
- Generating LLM embeddings with open source models in PostgresML2 people · 4 mentions · first linked 2023-04-21
- Personalize embedding results with application data in your database2 people · 3 mentions · first linked 2023-05-11
- Build AI Apps in Postgres2 people · 3 mentions · first linked 2022-12-10
- PostgresML raises $4.7M to launch serverless AI app databases based on Postgres2 people · 2 mentions · first linked 2023-05-10
- What's Hacker News' problem with open source AI?2 people · 2 mentions · first linked 2024-07-25
- How-to improve search results with machine learning2 people · 2 mentions · first linked 2023-09-04
- OpenAI Switch Kit: Swap OpenAI with any open-source model2 people · 2 mentions · first linked 2023-12-01
What Hacker News says?
Great idea and powered by Postgres on top of it, love it! If you're interested in integrated ML, check us out at https://postgresml.org Cheers!
Comment linking /
on “Show HN: I'm building an open-source Amazon”Submitted Show HN: PostgresML, now with analytics and project management as a story · 444 points
HN discussionThat's outside the database, though. This is closer to what I had in mind: https://postgresml.org/blog/how-to-improve-search-results-wi...
Comment linking /blog/how-to-improve-search-results-with-machine-learning
on “Better RAG Results with Reciprocal Rank Fusion and Hybrid Search”Submitted Scaling PostgresML to 1M Requests per Second as a story · 177 points
HN discussionIf you want to see all the SQL functions and tables Korvus depends on, check out the pgml extension. https://postgresml.org/docs/open-source/pgml/
Comment linking /docs/open-source/pgml/
on “Korvus: Single-Query RAG with Postgres”Submitted PostgresML is 8-40x faster than Python HTTP microservices as a story · 116 points
HN discussionThis section of the docs may be confusing. What you described will actually almost work. See: https://postgresml.org/docs/open-source/korvus/guides/rag#ra...
Comment linking /docs/open-source/korvus/guides/rag
on “Korvus: Single-Query RAG with Postgres”Submitted We migrated from AWS to GCP with minimal downtime as a story · 51 points
HN discussionI find it misleading to use an f-string containing encoded `{CONTEXT}` < https://github.com/postgresml/korvus/blob/bce269a20a1dbea933... >, and after digging into TFM < https://postgresml.org/docs/open-source/korvus/guides/rag#si... > it seems it is not, in fact, an f-string artifact but rather the literal characters "{"+"CONTEXT"+"}" and are the same in all the language bindings? IMHO it would be much clearer if yo…
Comment linking /docs/open-source/korvus/api/collections
on “Korvus: Single-Query RAG with Postgres”Submitted PostgresML is Moving to Rust for our 2.0 Release as a story · 37 points
HN discussionIn this case, they are talking about xgboost inference, which can verge on the hungry side of things, but this is no match for deep learning, although word embeddings and transformers are supported[1] by PostgresML regardless. GPUs are supported[2] for Transformers as well as xgboost, so this approach is also kind of future-proof in the sense that you're not going to ever be limited by your compute, as well as the s…
Comment linking /user_guides/setup/gpu_support/
on “Scaling PostgresML to 1M Requests per Second”Submitted PostgresML launches free/hosted SQL tutorials for Machine Learning as a story · 15 points
HN discussionPostgresML v1.0 was doing exactly that. When we rewrote in Rust for v2.0, we improved 35x: https://postgresml.org/blog/postgresml-is-moving-to-rust-for...
Comment linking /blog/postgresml-is-moving-to-rust-for-our-2.0-release/
on “PostgresML is 8-40x faster than Python HTTP microservices”Submitted Show HN: PostgresML integrates Hugging Face to bring SOTA models into the db as a story · 14 points
HN discussionHe forgot one, you can also use Postgres for ML tasks too: https://postgresml.org/
Comment linking /
on “Just Use Postgres for Everything”Submitted PostgresML raises $4.7M to launch serverless AI app databases based on Postgres as a story · 9 points
HN discussionLink: https://postgresml.org/blog/postgresml-is-8x-faster-than-pyt...
Comment linking /blog/postgresml-is-8x-faster-than-python-http-microservices/
on “Machine learning in the database is 40 times faster than in a microservice”Submitted What's Hacker News' problem with open source AI? as a story · 7 points
HN discussionMy bad. Here it is: https://postgresml.org/blog/postgresml-is-8x-faster-than-pyt...
Comment linking /blog/postgresml-is-8x-faster-than-python-http-microservices/
on “Machine learning in the database is 40 times faster than in a microservice”Submitted OpenAI Switch Kit: Swap OpenAI with any open-source model as a story · 5 points
HN discussionHonestly just look at their homepage: https://postgresml.org . I'm usually the first to criticize products for using buzzwords and making it very unclear what they do, but of all the AI products I've seen their homepage has to be one the clearest pages I've encounter in the space. The example there makes it immediately obvious what it does and I won't repeat it here. If it's not clear to you probably you are not the…
Comment linking /
on “PostgresML raises $4.7M to launch serverless AI app databases based on Postgres”Submitted Build AI Apps in Postgres as a story · 4 points
HN discussionThanks for checking it out! Sorry you had some issues I'll look into it. We are still actively building out our documentation. You can find the current docs here: https://postgresml.org/docs/introduction/machine-learning/sd...
Comment linking /docs/introduction/machine-learning/sdks/opensourceai
on “OpenAI Switch Kit: Swap OpenAI with any open-source model”Submitted OpenSource-AI: Drop-in replacement for OpenAI using open-source models as a story · 3 points
HN discussionHow about the one that works directly in your database: https://postgresml.org
Comment linking /
on “Rag is more than just embedding search”Submitted Making Postgres 30 Percent Faster in Production as a story · 3 points
HN discussionLinks: [1]: https://huggingface.co/spaces/mteb/leaderboard [2]: https://postgresml.org/blog/generating-llm-embeddings-with-o... [3]: https://postgresml.org/blog/tuning-vector-recall-while-gener... [4]: https://postgresml.org/blog/personalize-embedding-vector-sea... Github: https://github.com/postgresml/postgresml
Comment linking /blog/personalize-embedding-vector-search-results-with-huggingface-and-pgvector
on “Show HN: We unified LLMs, vector memory, ranking, pruning models in one process”Submitted PostgresML raises $4.7M to launch AI application databases based on Postgres as a story · 3 points
HN discussionHey HN, We’ve been working on a demo that showcases RAG (Retrieval-Augmented Generation) using open-source models directly within Postgres. It's a Wikipedia chatbot built with PostgresML. If you haven’t seen us here before, PostgresML is an open-source extension for Postgres that lets you perform ML/AI inside PostgreSQL. There are a number of performance benefits that come with doing machine learning in-database. It…
Comment linking /chatbot
on “Postgres Learns to RAG: Wikipedia Q&A using Llama 3.1 inside the database”Submitted Scaling PostgresML to 1 Million Requests per Second as a story · 3 points
HN discussion
