← back to projects

cat typesense-entity-search/README.md

Typesense Entity Search

DSP Investment Managers · 2025

Fast, typo-tolerant search over companies, portfolios, and metrics

TypesenseDockerKubernetesPythonPostgreSQL

Problem

Internal tools needed fast, forgiving search across a large, fast-moving set of entities — companies (comps), portfolios, and financial metrics — that a plain SQL LIKE query couldn't serve well.

Approach

  • ▸Designed the Typesense collection schemas for comps, portfolios, and metrics from scratch.
  • ▸Built the indexing pipeline to keep search data in sync with the source-of-truth PostgreSQL tables.
  • ▸Containerized the service with Docker and deployed it as pods in the production Kubernetes cluster.

Impact

  • ✓Sub-second, typo-tolerant search across companies, portfolios, and metrics for internal analyst tools.
  • ✓Runs as a self-contained, independently scalable service in the production cluster.