#PostgreSQL

A 100M-event CDM in production behaves nothing like the Eunomia sample. This article covers schema design, indexing, partitioning by person_id, vacuum, backup, security under Vietnam's Personal Data Protection Law 2025 (effective Jan 1, 2026), audit logging, and vocabulary upgrades.

Duy TranMay 7, 202614 min

A deep dive into the seven most important tables in OMOP CDM 5.4 — schema, foreign keys, ETL conventions, common pitfalls (Measurement vs. Observation, Drug_Exposure vs. Drug_Era), and 10 popular RWE SQL patterns.

Duy TranMay 7, 202618 min

Detailed instructions for building a complete AI Agent Platform with xClaw — TypeScript monorepo supporting Multi-LLM, RAG Pipeline, Workflow Engine, 13 Domain Packs, Multi-tenant RBAC, MCP Protocol and 8 Chat Channels. From Dual-Database architecture to deploying Docker production.

Duy TranMarch 30, 202645 min

Detailed instructions for upgrading PostgreSQL 17.6 to 18.1 for production environments with minimal downtime. Includes pg_upgrade, logical replication, rollback plan, and updated best practices for PostgreSQL 18 with Async I/O, Statistics Preservation, and new pg_upgrade --swap mode.

Duy TranDecember 23, 202515 min

How to search on encrypted data? This article presents 3 practical approaches and implementations with Spring Boot + PostgreSQL to protect 100,000+ patient records.

Duy TranDecember 15, 202515 min

This article will help you master PostgreSQL backup and restore methods from basic to advanced, along with practical best practices.

Duy TranDecember 8, 202513 min

Share experience in deploying and open-source fully automated PostgreSQL HA cluster solution

Duy TranNovember 25, 202514 min

The most comprehensive series for beginners to learn OMOP Common Data Model version 5.4. From the basic concept of medical data standardization, Person-centric architecture, 37 data tables (Clinical Data, Health System, Health Economics, Standardized Vocabularies, Derived Elements, Metadata), to Concept/Vocabulary systems, ETL processes, and OHDSI ecosystem tools. Each lesson has real-life examples from Vietnamese hospitals, intuitive diagrams, and hands-on SQL exercises.

A hands-on series on building a complete Microservices system with Quarkus 3.x — the "Supersonic Subatomic" Java framework designed specifically for Cloud Native and Kubernetes. Using PostgreSQL as main database, Keycloak for Authentication & Authorization (OIDC), Apache Kafka for Event-Driven Communication, gRPC for high-performance inter-service. From creating your first project with Dev Services, building a REST API with Panache, to deploying production on Kubernetes with GraalVM Native Image. Includes Fault Tolerance, OpenTelemetry Observability, Contract Testing, CI/CD Pipeline and Production Readiness Checklist. Actual project: E-Commerce Platform system includes 5 microservices.

Step-by-step instructions for building a medical information system (HIS/EMR/LIS) with Microservices architecture using Quarkus, PostgreSQL and Keycloak. Compliant with HIPAA, HL7 FHIR, Zero Trust security standards. From architectural design, building services, decentralization, data encryption, audit logging to production deployment on Kubernetes. Each article has practical code, ready to be applied to hospitals and medical facilities.

Comprehensive practical course on deploying Microservices on-premises systems using Kubernetes HA (High Availability), PostgreSQL HA with Patroni, Ceph/Rook storage, Istio Service Mesh, ArgoCD GitOps, Prometheus Observability Stack, HashiCorp Vault, RabbitMQ HA, Redis Cluster and many other production-grade technologies. From infrastructure design, cluster installation, microservices deployment to operations, DR and enterprise standard security. 50 lessons + practice labs on bare-metal/VM.

Comprehensive series on the OHDSI (Observational Health Data Sciences and Informatics) ecosystem and OMOP Common Data Model — from platform overview, Standardized Vocabularies (Athena), medical data ETL (WhiteRabbit, Rabbit-in-a-Hat, Usagi), OMOP CDM implementation on PostgreSQL, WebAPI and ATLAS installation, to clinical data analysis (Cohort Definitions, Characterization, Incidence Rates, Population-Level Estimation, Patient-Level Prediction), data quality assessment (ACHILLES, Data Quality Dashboard), HADES R packages for observational studies, and OHDSI stack deployment on Docker/Kubernetes for multicenter Network Studies.

Comprehensive Django course from basic to advanced, helping you master the most powerful full-stack Python framework. Includes Django ORM, Django REST Framework, Class-Based Views, Authentication, Celery, Channels (WebSockets), Testing, Docker and Production deployment. Updated to Django 5.2+ and Python 3.12+ with the latest 2026 best practices.

Comprehensive Golang course from basic to advanced, helping you master the Go language and build high-performance backends. Includes Go fundamentals, Goroutines, Channels, Gin/Fiber framework, GORM, gRPC, Microservices, Testing, Docker and Production deployment. Updated to Go 1.23+ with generics, iterators and the latest 2026 best practices.

The Laravel course is comprehensive from basic to advanced, helping you master the world's most popular PHP framework. Includes Eloquent ORM, Blade Templates, Laravel API (Sanctum/Passport), Queues, Events, Broadcasting, Livewire, Testing, Docker and Production deployment. Updated to Laravel 12+ and PHP 8.4+ with the latest 2026 best practices.

The Python FastAPI course is comprehensive from basic to advanced, helping you master the most modern Python framework for Backend API. Includes Python fundamentals, Pydantic, async/await, SQLAlchemy, Alembic, Authentication, Authorization, OAuth2, WebSockets, Background Tasks, Testing, Docker and Production deployment. Updated to FastAPI 0.115+ and Python 3.12+ with the latest 2026 best practices.

Comprehensive Rust course from basics to advanced, helping you master the safest and most performant programming language. Includes Ownership, Borrowing, Lifetimes, Traits, Async/Await, Actix-web/Axum, SQLx, gRPC, WebAssembly, Testing and Production deployment. Updated to Rust 2024 edition with the latest 2026 best practices.

A hands-on series on building a complete AI Agent Platform using TypeScript — from monorepo design, LLM Router, Tool Registry, RAG Pipeline, Workflow Engine, Multi-tenant RBAC to deploying Docker production. Learn through the actual source code of xClaw — an open-source platform running in production.

Learn how to deploy PostgreSQL High Availability cluster with Patroni and etcd. Practical course from A-Z: installation, configuration, automatic failover, monitoring and production operations. 29 lessons + detailed labs.