---
title: "Database"
description: "4 posts about Database, summarised, each linking to the original."
---

# Database
> 4 posts about Database, summarised, each linking to the original.

## Articles

### [OLTP vs. OLAP: Choosing Between Transactional and Analytical Databases](https://yomu.fyi/post/oltp-vs-olap-choosing-between-transactional-and-analytical-databases.md)
- Company: [Databricks](https://yomu.fyi/company/databricks.md)
- Author: Databricks Staff
- Published: Oct 14, 2026
- Type: Explainer

OLTP handles high-volume, low-latency transactions on current operational data for online banking, e-commerce, and inventory, while OLAP handles complex analytical queries on large historical datasets for financial analysis and business intelligence. OLTP databases ensure data integrity through ACID compliance and use normalized row-oriented tables; OLAP systems use denormalized dimensional models and columnar storage for efficient scans and aggregations. Data pipelines such as ETL or CDC tools like Debezium connect OLTP and OLAP systems, but latency and pipeline complexity rise with analytical freshness requirements. For mixed workloads, HTAP or lakehouse architectures can reduce synchronization overhead and analytical lag. The choice between OLTP and OLAP depends on the workload’s read-write pattern, latency needs, and data volume, with TPC-C and TPC-H as reference benchmarks.


### [Building A Culture Of Growth: MongoDB's Massive Opportunity In APAC](https://yomu.fyi/post/building-a-culture-of-growth-mongodb-s-massive-opportunity-in-apac.md)
- Company: [MongoDB](https://yomu.fyi/company/mongodb.md)
- Published: Oct 12, 2026
- Type: Explainer

MongoDB’s go-to-market organization in APAC has nearly tripled in size over the past three years, driven by the region’s massive database opportunity. IDC forecasts the global database market will grow to $137 billion by 2027, and MongoDB has reached $1 billion in annual recurring revenue, with APAC containing five of the world’s top 13 economies by GDP. To serve diverse markets like India, Australia, and Singapore, MongoDB deploys regionalized business leaders who tailor go-to-market strategies while collaborating on shared best practices at the leadership level. The company’s culture, shaped by six core values including “Embrace the Power of Differences,” emphasizes psychological safety and accountability, encouraging teams to learn from setbacks. MongoDB’s APAC teams prioritize three goals: ensuring customer success, building technical champions, and driving new workloads, as exemplified by Cathay Pacific’s Flight Folder application powered by MongoDB.


### [Lakebase and Agentic SDLC: Branching Databases for Coding Agents](https://yomu.fyi/post/lakebase-and-agentic-sdlc-branching-databases-for-coding-agents.md)
- Company: [Databricks](https://yomu.fyi/company/databricks.md)
- Author: Thibaut Gourdel
- Published: Oct 9, 2026
- Type: Problem & solution

Coding agents working in parallel on shared databases create schema conflicts, test interference, and data exposure risks. Lakebase Postgres solves this with database branching, which creates an isolated copy of an entire database in under a second using copy-on-write. Each agent gets its own database branch via a post-checkout Git hook tied to a worktree, and each pull request gets an ephemeral branch through CI tooling. Schema changes are tracked in code with migration tools such as Drizzle or Alembic and promoted to the parent branch during deployment, not by merging database branches. Idle branches scale to zero, so running many concurrent agents incurs no compute cost for unused branches.


### [MongoDB Queryable Encryption: Prefix, Suffix, and Substring Queries Are Now GA](https://yomu.fyi/post/mongodb-queryable-encryption-prefix-suffix-and-substring-queries-are-n.md)
- Company: [MongoDB](https://yomu.fyi/company/mongodb.md)
- Published: Oct 5, 2026
- Type: Announcement

MongoDB announced general availability of prefix, suffix, and substring query support in Queryable Encryption, extending beyond equality and range queries to production workloads at no additional cost in Atlas, Enterprise Advanced, and Community Edition. These capabilities enable expressive text searches on encrypted data without decryption, with the database server never seeing plaintext during query processing. The open-source encryption scheme is independently verifiable, works without specialized hardware, and protects data at rest, in transit, and in use. The new query types enable partial-name lookups, autocomplete, and partial-word filtering on encrypted fields via the native query engine, requiring no external indexes or middleware. This helps meet HIPAA, PCI-DSS, and GDPR compliance by protecting data in use — a stage other encryption methods cannot cover — reducing audit gaps and eliminating workarounds.