Vector Database Selection: Comparing Azure AI Search, Cosmos DB, and PostgreSQL
Azure AI Search, Cosmos DB with vector indexing, and Azure Database for PostgreSQL with pgvector each provide vector search capabilities with different…
33 articles
Azure AI Search, Cosmos DB with vector indexing, and Azure Database for PostgreSQL with pgvector each provide vector search capabilities with different…
Configure your Cosmos account with write regions near your users and read replicas globally. Vector searches automatically route to the nearest replica…
Cosmos DB vector search brings global scale and multi-model capabilities to AI applications.
Unlike SQL mirroring which uses change tracking, Cosmos DB mirroring leverages the built in analytical store: 1. Go to your Cosmos DB account 2. Navigate to…
The partition key decision is crucial and difficult to change later: New in 2022 partition up to 3 levels: Optimize indexing for your query patterns: Write…
Exploring the local neighborhood of a vertex is one of the most common operations in graph databases.
Graph databases excel at representing relationships between entities. Unlike relational databases where joins can become expensive, graph databases traverse…
Azure Cosmos DB for Apache Cassandra bridges the gap between familiar Cassandra development and cloud-native scalability.
Azure Cosmos DB's MongoDB API provides a powerful option for teams wanting MongoDB compatibility with Azure's enterprise-grade platform.
PITR works with the continuous backup feature to provide granular recovery options. You can restore entire accounts, specific databases, or individual…
Unlike periodic backup mode, continuous backup captures every change as it happens, allowing granular point-in-time recovery down to the second.
When your Cosmos DB container isn't fully utilizing its provisioned throughput, the unused capacity accumulates as burst credits. These credits can be used…
Traditional single partition keys can lead to hot partitions in scenarios where data is naturally hierarchical. Hierarchical partition keys solve this by…
The latest updates bring significant performance enhancements to Cosmos DB, including optimized query execution and improved throughput management.
Azure Cosmos DB for PostgreSQL is a managed database service that extends PostgreSQL with distributed capabilities. It uses the Citus extension to transform…
Elastic tables are ideal for: IoT sensor data Application telemetry Audit logs High frequency transactions Time series data Define an elastic table schema:…
TTL is a powerful feature for automatic data lifecycle management, reducing storage costs and ensuring compliance with data retention policies without…
Proper conflict resolution is essential for multi-region write scenarios. Choose the right strategy based on your data semantics and ensure thorough testing…
Multi-region writes enable true active-active architectures, but require careful design to handle the inevitable conflicts that arise from concurrent…
Global distribution in Cosmos DB provides the foundation for building truly global, resilient applications that serve users with consistent low latency…
Consistency levels in Cosmos DB give you fine-grained control over the CAP theorem tradeoffs, enabling you to optimize for your specific application…
Proper partition key design is fundamental to Cosmos DB success. Take time to analyze your access patterns and data distribution before finalizing your…
Event Sourcing with Azure Cosmos DB provides a robust foundation for building systems that require complete audit trails, temporal queries, and event driven…
The Cosmos DB integrated cache is the feature I've been waiting for since the first time I watched a read-heavy application burn through its RU budget…
The question that sparked this post came from a data engineer on a client project: "can we run Power BI reports against Cosmos DB without destroying the…
We had a Cosmos DB Serverless conversation at the end of 2020 and I'm returning to it because the experience of using it in actual development over two…
Cosmos DB Serverless: scale-to-zero for your NoSQL workloads.
Cosmos DB Serverless: NoSQL without the commitment.
Of every Cosmos DB design conversation I've had, partition key choice is the one that has the biggest cost-and-performance consequence and the smallest…
Synapse Link: analytics without the pipeline complexity.
Strong and Bounded Staleness cost double because reads wait for quorum. Start with Session - it provides intuitive consistency for users while maintaining…
Change Feed transforms Cosmos DB from a database into a real-time event platform.
SDK v3 has been out for about a year now and I've finally migrated all the Cosmos work I had on v2. The migration was less painful than I expected — the API…