Constructor vs ParadeDB

Constructor is a cloud platform for ecommerce search and product discovery, founded in 2015. It uses shopper behavior, context and intent to personalize discovery across search, autosuggest, browse, recommendations, collections, quizzes and retail media. The AI Shopping Agent guides shoppers through natural-language product searches, while the Product Insights Agent answers personalized product questions. Merchant Intelligence Agent and Merchandiser Controls provide merchandising insights, dashboards, reports, controls and experiments. B2B capabilities cover account-segmented pricing and availability, personalization and discovery across large catalogs. Search options include hybrid, vector and faceted search, with zero-result reporting, search conversion tracking and result click analytics. Catalogs can be supplied through connectors, scheduled JSON, JSONL or CSV feeds, or REST API updates. APIs and browser or server-side client libraries support retrieving results, sending behavioral events and updating data or configurations; named client libraries include JavaScript, Swift and Kotlin. Constructor says it reduces personal data exposure using anonymous IDs, IP truncation and hashed identifiers. Pricing is not published; prospective customers are directed to book a demo.

ParadeDB adds full-text and vector search, filters, facets, and joins to PostgreSQL through the pg_search extension. It runs inside standard Postgres without a fork or sidecar process. Documented queries include BM25 full-text, vector and hybrid search, fuzzy, phrase, proximity, and regex searches, with filtering, sorting, and highlighting. Indexing covers columnar, vector, JSON, array, and composite data, alongside aggregates, facets, and joins. ParadeDB documents ACID transactions and consistent reads, with index updates applied alongside application-data writes. Deployment options include ParadeDB Cloud, BYOC, Kubernetes with CloudNativePG, self-hosted PostgreSQL, and listed PaaS providers. Local installation is documented through a curl installer, Docker, and Postgres.app, whose steps assume PostgreSQL 18. Community is AGPL-3.0 open source and supports single-node deployments; read replicas and high availability are Enterprise features. Community costs nothing, fully free forever. Cloud is in private preview with pricing not stated, while Enterprise uses custom pricing.