Sublime

Emergent Systems

R

Ross Vandenhoeck

@rossvandenhoeck-d97a

Collections,

Margaret Saponaro • Collection Management Basics (Library and Information Science Text Series)

Optimizing Further

Creating so many indices and aggregating so many tables is sub-optimal. To optimize this, we employ materialized views, which create a separate disk-based entity and hence support indexing. The only downside is that we have to keep it updated.

CREATE MATERIALIZED VIEW search_view AS

ᅠᅠSELECT c.name FROM company c UNION

ᅠᅠSELECT... See more

How Levels.fyi Built Scalable Search with PostgreSQL

Thumbnail of www-x-com-tom-doerr-status-1866625389667422688-79d94aa8da274c0e

Typesense is an open-source search engine using an Adaptive Radix Tree for fast fuzzy searches, storing JSON documents with RocksDB, and offering features like faceting, filtering, geo search, and semantic search through a RESTful API https://t.co/cFpTAvjRZu

Tom Dörr

x.com

Organization

Kaitlyn Carroll • 1 card

Building a search panel for all my Markdown notes: - Chrome file system API to sync from a directory - remark to break files into blocks (heading, paragraph, etc) - mxbai-embed-large model for vector search - SQLocal to persist Zero API calls. It's all local 😄... See more

Ben Holmes x.com

Abundant Systems

Leo Guinan • 40 cards

Finds

Jennifer Velazquez • 1 card