lmorchard - Pebbling Club 🐧🪨

Implementing Filtered Semantic Search Using Pgvector and JavaScript

www.timescale.com
2024-12-11T20:21:45.041Z
psql postgresql vector ml ai search dev

Notes

Conventional search methods rely on keyword matching, where the system locates exact words or phrases from the query within documents. This technique can be enhanced to better capture the context and intent behind the user's query, leading to more relevant and precise search results. Semantic search focuses on understanding the meaning and intent behind the query. Combining semantic search with filters—or additional parameters to narrow the results based on specific attributes—further improves accuracy. In this article, we explore semantic search with filters and demonstrate how you can implement it using pgvector and JavaScript.

Feed

Unfurl

{ "expires": 1734034896007, "status": 200, "bodyLength": 209932, "author": "Team Timescale", "date": "2024-12-04T16:48:01.000Z", "description": "Explore semantic search with filters and learn how you can implement it with pgvector and JavaScript.", "image": "https://www.timescale.com/blog/content/images/2024/08/Implementing-Filtered-Semantic-Search-Using-Pgvector-and-JavaScript_vector-embeddings-2.png", "logo": "https://www.timescale.com/blog/content/images/size/w256h256/2023/05/image--13--1.png", "publisher": "Timescale Blog", "title": "Implementing Filtered Semantic Search Using Pgvector and JavaScript", "url": "https://www.timescale.com/blog/implementing-filtered-semantic-search-using-pgvector-and-javascript-2/", "feed": "https://www.timescale.com/blog/rss/", "iframe": null, "lang": "en", "video": null, "audio": null, "duration": 4957 }
frectonz/pglite-fusion: Embed an SQLite database in your PostgreSQL table. AKA multitenancy has been solved.

github.com
2024-11-19T22:30:34.104Z
databases postgresql postgres sqlite

Notes

Embed an SQLite database in your PostgreSQL table. AKA multitenancy has been solved.

Unfurl

{ "expires": 1732141828213, "status": 200, "bodyLength": 377993, "author": "frectonz", "date": null, "description": "Embed an SQLite database in your PostgreSQL table. AKA multitenancy has been solved. - frectonz/pglite-fusion", "image": "https://opengraph.githubassets.com/3dac6f14d582782f062e805218ef124bf221b58973e3753e8743cc9d73eb5cdd/frectonz/pglite-fusion", "logo": "https://github.com/fluidicon.png", "publisher": "GitHub", "title": "GitHub - frectonz/pglite-fusion: Embed an SQLite database in your PostgreSQL table. AKA multitenancy has been solved.", "url": "https://github.com/frectonz/pglite-fusion", "feed": null, "iframe": null, "lang": "en", "video": null, "audio": null, "duration": 1533 }
Postgres.app | the easiest way to run PostgreSQL on the Mac

postgresapp.com
2012-05-17T15:19:48.000Z
postgres mac osx databases apps postgresql imported:pinboard

Notes

the easiest way to run PostgreSQL on the Mac

Unfurl

{ "author": "Jakob Egger and Mattt Thompson", "description": "Postgres.app is a full featured PostgreSQL installation packaged as a standard Mac app.", "image": "http://postgresapp.com/img/PostgresAppIconLarge.png", "publisher": "Postgres.app", "title": "Postgres.app – the easiest way to get started with PostgreSQL on the Mac", "url": "http://postgresapp.com/", "lang": "en", "failed": true, "failedAt": 1728194867563, "failedError": "TimeoutError: Promise timed out after 10000 milliseconds", "expires": 1728364749726, "status": 200, "bodyLength": 15069, "duration": 2623 }
PostgreSQL and XML updated

www.throwingbeans.org
2005-07-11T14:33:56.000Z
postgresql databases xml xslt imported:pinboard

Notes

"The XML functions for PostgreSQL (introduced here) have been updated and, as of version 8, ship with the standard distribution of PostgreSQL." XSLT and XPath in the database.

Unfurl

{ "failed": true, "failedAt": 1728195807537, "failedError": "TimeoutError: Promise timed out after 10000 milliseconds" }
PostgreSQL startup items for MacOS X

rollerweblogger.org
2004-09-07T13:29:17.000Z
osx postgresql programming imported:pinboard

Unfurl

{ "failed": true, "failedAt": 1728195877555, "failedError": "TimeoutError: Promise timed out after 10000 milliseconds" }

0 - 50 of 5 items

10 25 50 100 250