Retake – Open-Source Hybrid Search for Postgres

Hacker News

Hey HN! We're Phil and Ming, co-founders of Retake ( https://github.com/getretake/retake ). Retake is an open source tool that adds keyword and semantic (i.e hybrid) search to databases. We’ve started by extending the capabilities of Postgres with an SDK for lightning-fast queries. We built Retake to fix two issues: keeping vectors in sync with Postgres in real time is difficult, and most vector databases aren’t built for hybrid search. A quick refresher: “keyword search” refers to a technique where results are scored based on the appearance of exact words or terms. “Semantic search” uses vector embeddings to understand the meaning behind those words. Hybrid search combines these two approaches to enhance the precision and relevance of results. To implement semantic or hybrid search today, most organizations run batch jobs that update their search engine or vector database using ETL tools or custom data pipelines. We’ve seen from firsthand experience how time-consuming and costly this can be, as moving vectors often requires re-embedding the entire data source. We’ve also seen how many vector databases lack crucial features of “traditional” search: keyword-based (BM25) search, faceting/aggregations, highlighting, efficient filtering, etc. Here’s how Retake works - our core is built on top of OpenSearch, which acts as a search engine and vector database. We leverage logical-replication-based Change Data Capture (CDC) to stay in sync with Postgres, so documents and vectors are updated incrementally and in real time. Finally, Python and Typescript SDKs make it easy to integrate Retake into your application. There’s no need to manage separate vector databases and search engines, upload and embed documents, or run expensive reindexing jobs. All you need to think about is writing search queries. The easiest way to get started with Retake is by running our Docker Compose stack: git clone https://github.com/getretake/retake.git cd retake/docker && docker compose up Retake is Apache licensed and our repo is here: https://github.com/getretake/retake . For next steps, see our quick start guide: https://docs.getretake.com/quickstart We’d love your feedback on our solution to hybrid search. Our focus right now is on nailing the basics, but we’d also love to hear what you think we should focus on next.

Visit product View on Hacker NewsAug 10, 2023

Share card

Actual performance

88points

23comments

Made the leaderboard

Launch Intel predictions

Analyze your own launch →

Indie HackersFits the IH revenue-focused audience · Strong signals: started, para, organizations · Missing: supports, reddit linkedin, podcasting

92%92% predicted probability of success on Indie Hackers, based on ML models trained on real launch data.

best fitHighest predicted score across all platforms for this description.

Product HuntOn track for Day 1 leaderboard · Strong signals: dock, using, open · Missing: mac, agents, macos

91%91% predicted probability of success on Product Hunt, based on ML models trained on real launch data.

Hacker NewsStrong engagement from HN community · Strong signals: open source, ide, pipe · Missing: https docs, excited, just released

60%60% predicted probability of success on Hacker News, based on ML models trained on real launch data.

nativeThis product was originally launched on this platform.

AppSumoMay struggle as an AppSumo deal · Strong signals: efficient · Missing: plus, platform, intuitive

40%40% predicted probability of success on AppSumo, based on ML models trained on real launch data.

TrustMRRLess likely to generate early MRR · Strong signals: way, para · Missing: mobile apps, ios, personal

31%31% predicted probability of success on TrustMRR, based on ML models trained on real launch data.

Acquire.comPre-revenue stage for this audience · Missing: arr, mrr, revenue

11%11% predicted probability of success on Acquire.com, based on ML models trained on real launch data.

BetaListMay not resonate with beta-testers · Strong signals: real time · Missing: web3, chat, crypto

0%0% predicted probability of success on BetaList, based on ML models trained on real launch data.

Correct prediction on native model

Similar products

Hydra - Open-Source Columnar Postgres64%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Hydra - Open-Source Columnar Postgres

Hacker News122

Metarank – open-source hybrid search with LLMs56%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Metarank – open-source hybrid search with LLMs

Hacker News7

Neosync – Open-Source Data Anonymization for Postgres and MySQL67%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Neosync – Open-Source Data Anonymization for Postgres and MySQL

Hacker News246

Venice – open-source Plaid to Postgres in minutes without code79%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Venice – open-source Plaid to Postgres in minutes without code

Hacker News53

An open-source starter for developing with Postgres and ClickHouse77%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

An open-source starter for developing with Postgres and ClickHouse

Hacker News2

OneSparse – Open Source Accelerated Sparse Linear Algebra for Postgres70%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

OneSparse – Open Source Accelerated Sparse Linear Algebra for Postgres

Hacker News13

Searchlight – Open-source Postgres client for macOS75%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Searchlight – Open-source Postgres client for macOS

Hacker News9

Scaledger, an Open Source Ledger API in GraphQL and Postgres79%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Scaledger, an Open Source Ledger API in GraphQL and Postgres

Hacker News3

Open-Source Postgres API Generator (REST > GraphQL)80%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Open-Source Postgres API Generator (REST > GraphQL)

Hacker News1

Typesense – typo tolerant, delightfully simple, open source search67%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Typesense – typo tolerant, delightfully simple, open source search

Hacker News23

Browse all products Analyze your launch