Querying Clinical Data: AQL vs. FHIR Search vs. SQL on FHIR

Five ordinary clinical questions put to three query languages: FHIR search, openEHR AQL and SQL on FHIR. The comparison shows what each was built for, where approximate cohort queries go wrong, and how view definitions turn FHIR resources into tables. Includes a tested SQL on FHIR pipeline in Python and C# clients for FHIR search and AQL.

.NET15 min read

Amazon S3 Vectors vs. OpenSearch Serverless vs. pgvector for RAG: Cost Floors, Query Bills and Tenant Isolation

All three AWS vector stores can now cost close to nothing at rest, but they bill and isolate tenants in very different ways. This comparison models Amazon S3 Vectors, OpenSearch Serverless (classic and next generation) and Aurora PostgreSQL with pgvector across three workload shapes, checks the S3 Vectors model against the worked examples on the AWS pricing page, and shows where the tenant boundary belongs in each.

Declarative Stream Processing: EventBridge Pipes vs. Custom Lambda Glue

EventBridge Pipes is usually sold as cheaper and lighter on concurrency than a Lambda stream consumer. Checked against the AWS documentation, both claims mostly disappear once the consumer filters on its event source mapping. This article compares the two for a DynamoDB Streams to EventBridge integration, with tested code, a reproducible cost model and a decision framework.

Zero-ETL from Aurora to Amazon Redshift: What You Set Up, What It Replaces and What It Does Not

For decades, bridging transactional PostgreSQL logs against heavily optimized columnar Data Warehouses necessitated configuring deeply expensive, brittle Apache Spark pipelines effectively mapping nightly batches. Discover fundamentally how AWS Aurora Zero-ETL flawlessly synchronizes precise transactional topologies entirely distinctly effectively inside Amazon Redshift practically under 15 seconds.

Amazon S3 Tables & Apache Iceberg: Native Lakehouse in S3 — 14 Months Later

Amazon S3 Tables promised to eliminate the operational scaffolding of Apache Iceberg on S3 — automatic compaction, native REST catalog, managed snapshot lifecycle. Fourteen months after the re:Invent 2024 announcement, this is the enterprise practitioner assessment: what teams migrated from traditional S3 + Glue Catalog setups, the Lake Formation column masking gap that affects regulated workloads, and the migration decision framework for data engineering teams evaluating the switch.