Real-time Data Update Solutions in TCHouse‑C: Architecture, Schema‑less Design, and Performance Evaluation

This article presents TCHouse‑C, a cloud‑native ClickHouse service, detailing its real‑time data update architecture, schema‑less ingestion, various update strategies such as Delete‑Insert and lightweight‑update/delete, and comprehensive performance tests comparing UniqueMergeTree with standard ClickHouse engines across import, query, and update workloads.

ClickHouseData WarehouseDelete-Insert

0 likes · 32 min read

Real-time Data Update Solutions in TCHouse‑C: Architecture, Schema‑less Design, and Performance Evaluation

Architects Research Society

Jan 20, 2020 · Databases

Goodbye MongoDB, Hello PostgreSQL: Olery’s Journey to a More Reliable Database Architecture

The article recounts Olery’s five‑year evolution from a Ruby‑centric stack using MongoDB and MySQL to a PostgreSQL‑based architecture, detailing schema‑less pitfalls, database requirements, migration strategies, code adaptations, and the measurable performance gains achieved after the transition.

MongoDBPostgreSQLRuby

0 likes · 15 min read

Goodbye MongoDB, Hello PostgreSQL: Olery’s Journey to a More Reliable Database Architecture

ITPUB

Mar 24, 2016 · Databases

How Uber Built Schemaless: A Scalable Schema‑Free MySQL‑Based Store

Uber’s Schemaless is a highly available, horizontally scalable MySQL‑based key‑value store that abandons fixed schemas, supports JSON blobs, triggers, and global secondary indexes, and was created to meet five critical requirements for trip data storage, including linear expansion, write throughput, and reliable operations.

ScalabilityUberdatabases

0 likes · 13 min read

How Uber Built Schemaless: A Scalable Schema‑Free MySQL‑Based Store