Speaking to investment analysts, he said that while MongoDB had all the elements needed to be the right foundational platform for AI workloads, it was too early to say what might be the platform of choice. However, he said MongoDB had been winning work from AI-native companies, citing a customer that recently "switched from PostgreSQL to MongoDB because PostgreSQL could not just scale."
Asyncpg is the connector for PostgreSQL and asyncio-flavored Python. Here's how to use it without other libraries on FastAPI and Air projects. Recently I've been on a few projects using PostgreSQL where SQLAlchemy and SQLModel felt like overkill. Instead of using those libraries I leaned on writing SQL queries and running those directly in [asyncpg](https://pypi.org/project/asyncpg/) instead of using an ORM powered by asyncpg. Here's how I got it to work
Under the MIT license, developers get maximum freedom in using DocumentDB. They can choose between PostgreSQL interfaces for stronger JSON support or MongoDB compatibility for existing expertise. "We are committed to 100% compatibility with MongoDB drivers," Microsoft emphasizes. This developer-first mentality is also reflected in the simple implementation. It takes less than a minute to get DocumentDB up and running. Contributing to the project takes even less time, which keeps the barrier to entry low.
A key part of the redesign was improving how results are retrieved. Traditional keyword search excels at matching exact product attributes, for example, a query like "pesto pasta sauce 8oz" benefits from precise lexical matching. But broader intent-driven queries, such as "healthy foods", are better handled through semantic retrieval, which understands relationships between terms and concepts. By combining both approaches in Postgres, Instacart can balance precision (returning only relevant results) with recall (capturing as many relevant items as possible), ensuring that customers see both the exact products they're looking for and meaningful options for discovery.
Postgres is becoming the default database of the world, and you still can't do good search over that information, believe it or not. There's just a lot of pain points.
The addition of the managed PostgreSQL database to the Data Intelligence platform will allow developers to quickly build and deploy AI agents without having to concurrently scale compute and storage.
