proomt

Search

Search posts, papers, and topics

All posts

Google Cloud BlogDavor Jerković4 min readintermediate

How a solo founder runs a five-continent tender platform on AlloyDB and MCP

Read on google.comHN 2·0 comments

Summary

A solo founder runs a global tender platform using Google Cloud's AlloyDB for PostgreSQL and Model Context Protocol (MCP). This setup consolidated relational data, vector embeddings, and audit logs, reducing semantic search latency by 47x with ScaNN indexing and automating database operations.

  • AlloyDB for PostgreSQL consolidated relational data, vector embeddings, and audit logs into a single managed database engine.
  • Migrating semantic search to a ScaNN index in AlloyDB reduced query latency from 1.14 seconds to 24 milliseconds (47x speedup).
  • Model Context Protocol (MCP) enabled an AI agent to automate database operations like analytics, performance optimization, and incident forensics.
  • The MCP agent operates with strict least-privilege permissions, using dedicated PostgreSQL roles and Cloud IAM for secure access.

This case study demonstrates how solo founders or small teams can leverage managed services and AI agents to operate complex, global platforms with minimal overhead and significant performance gains.

7/10
devopsperformanceaidatabasespostgresgoogle cloud

Related reading

  1. Announcing Native BM25 Ranking in AlloyDB and Cloud SQL

    Google Cloud adds native BM25 ranking to AlloyDB and Cloud SQL (PostgreSQL 17+) via the open‑source pg_textsearch extension, letting you run keyword‑based full‑text search inside the database. This removes the need for a separate search backend and, on AlloyDB, speeds up vector queries up to 10×.

    Google Cloud Bloggoogle.com2 min

  2. Introducing TIN: full-text search for Postgres

    PlanetScale’s TIN is a new PostgreSQL extension that implements a full‑text search index supporting Boolean, phrase, span, fuzzy, wildcard, regex, case/accent folding, COUNT(*) and BM25 top‑k queries. In a suite of benchmarks on an i7i.8xlarge EC2 instance (8 vCPU, 32 GB RAM), TIN built in 8 min 10 s (50.7 GB index) and outperformed ParadeDB, pg_textsearch and the built‑in GIN index by large marg…

    PlanetScaleplanetscale.com15 minHN20175

  3. Article: Beyond Relevance: A Governance-First Architecture for Enterprise Personalization

    The article proposes a governance‑first architecture for enterprise personalization, where policy‑driven steps (memory, journey graph, AI routing, scoring, trust checks, outcome simulation) shape the recommendation before it is returned. A reference FastAPI implementation demonstrates the pattern with external YAML policies and optional LLM assistance.

    InfoQinfoq.com19 min

  4. Article: Your Next DSL Author Is a Language Model

    Typed Domain Grounding (TDG) embeds a DSL inside a mainstream language the LLM already knows (e.g., Kotlin) and uses the host compiler as an oracle. The author describes five building blocks—embedding, choosing a host language with high training‑data frequency, compiler‑driven type safety, a generate‑compile‑repair loop, and an on‑demand teaching tool—and shows measured results from kUML, a Kotli…

    InfoQinfoq.com18 min

  5. Running OpenBao on Kubernetes with a CloudNativePG PostgreSQL backend

    Step‑by‑step recipe to run OpenBao (Vault fork) on Kubernetes using CloudNativePG as a password‑less, TLS‑authenticated PostgreSQL storage backend. Shows how to spin up a Kind cluster with the cnpg‑playground, deploy a 3‑node CNPG cluster with synchronous quorum replication, configure DatabaseRole‑based client certificates, set up pg_hba rules, and initialize OpenBao’s schema via a one‑off Job.

    CNCFcncf.io16 minHN2

  6. Elastic announces GA of cross-project search on Serverless, enabling teams to query across all linked projects without moving a byte

    Elastic Cloud Serverless now offers General Availability of Cross‑Project Search (CPS), letting you run a single query across up to 100 linked projects (any region, cloud, or solution type) without moving data. Setup is UI‑driven, permissions are evaluated per‑project, and costs are $0.009 / GB retained plus $0.05 / GB egress. CPS works for Observability, Security, Search, vector DB, and ML jobs,…

    Elasticelastic.co6 minrelease