Tagged articles
UPSERT
40 articles · Page 1 of 1
This article details SQLite's SQL enhancements from versions 3.22.0 to 3.26.0 in 2018, covering boolean literals with IS [NOT] TRUE/FALSE, window functions with OVER clause limitations, FILTER clause for aggregates, UPSERT via INSERT ON CONFLICT, and column renaming via ALTER TABLE RENAME COLUMN.
FILTER clauseSQLSQL standards
0 likes · 12 min read

Alibaba Mama evolved its advertising real-time data warehouse from a message queue-based architecture to a Flink + Paimon streaming lakehouse, solving structural defects like lack of deduplication, aggregation layer support, and schema enforcement by leveraging Paimon's primary key upsert and changelog capabilities, while sharing production optimization practices and comparing storage choices for advertising vs. risk control scenarios.
Alibaba MamaClickHouseFlink
0 likes · 22 min read

The article explains how the traditional find‑by‑id‑then‑save pattern causes two database round‑trips and concurrency bugs, and shows that Spring Data 4.1’s single‑statement Upsert (JdbcAggregateTemplate.upsert) lets the database decide INSERT or UPDATE in one SQL, reducing latency and race conditions while outlining its limitations and ideal use cases.
ConcurrencyJDBCSpring Boot
0 likes · 13 min read

This article details how to build a production-ready real-time data warehouse using Flink, covering CDC ingestion, event-time processing, dimension joins, upsert aggregation, state TTL, checkpoint tuning, exactly-once verification, and a pre-launch checklist for reliability.
CDCDimension JoinEvent Time
0 likes · 22 min read

The article demonstrates how to use Spring Boot and MyBatis-Plus to record user-product visit logs via an atomic INSERT ON DUPLICATE KEY UPDATE upsert, while isolating any remote-call failures through layered try-catch blocks so that logging never disrupts the main product-detail response.
Exception IsolationFeignMyBatis Plus
0 likes · 11 min read

This article explains the merge‑insert operation in Lance, detailing its SQL‑like semantics, typical use‑cases such as bulk upserts and conditional deletes, the underlying DataFusion planning and execution flow, the generation of the __action column, and the handling of source‑side duplicate rows.
DataFusionLanceRust
0 likes · 7 min read

This article reviews SQLite's 2018 enhancements, covering boolean literals, window functions, the FILTER clause, upsert syntax, column‑renaming support, and related API changes, while also noting the remaining limitations compared with other major database systems.
Boolean LiteralsSQLSQLite
0 likes · 10 min read

SQLite, often dismissed as a toy, proves its robustness by adding powerful SQL capabilities in 2018—including boolean literals, window functions, FILTER clauses, upsert syntax, and column renaming—making it a viable choice for production workloads despite lacking a network layer.
New FeaturesSQLSQLite
0 likes · 10 min read

This article explores SQLite's 2018 enhancements—including boolean literals, window functions, FILTER clauses, upsert syntax, and column renaming—detailing how each feature works, its syntax, and practical code examples, while also clarifying limitations compared to other major database systems.
Boolean LiteralsFILTER clauseSQL
0 likes · 10 min read

This article reviews SQLite's 2018 enhancements, covering Boolean literals, window functions, the FILTER clause, upsert syntax, column renaming, and related API changes, with code examples and comparisons to other databases, highlighting its reliability and suitability for production use.
Boolean LiteralsSQLSQLite
0 likes · 11 min read

This article explores the latest SQLite SQL enhancements introduced between versions 3.22.0 and 3.26.0 in 2018, covering boolean literals, window functions, FILTER clauses, upsert syntax, column renaming, and related API changes, with code examples and practical usage notes.
SQLSQLiteUPSERT
0 likes · 10 min read


ITPUBMar 21, 2025 · Databases
This article reviews the SQL enhancements introduced in SQLite from version 3.22.0 through 3.26.0, covering boolean literals, window functions, the FILTER clause, upsert syntax, and column‑renaming support, while comparing SQLite's capabilities to other major database engines.
Boolean LiteralsFILTER clauseRename Column
0 likes · 11 min read

This article reviews the SQL enhancements added to SQLite between versions 3.22.0 and 3.26.0, covering boolean literals, window functions, the FILTER clause, INSERT … ON CONFLICT (upsert), column renaming, and related API updates.
Boolean LiteralsFILTER clauseSQL
0 likes · 10 min read

This article explains the complete Apache Hudi write pipeline, detailing each step from client creation to commit, and describes the various write operations such as Upsert, Insert, Bulk Insert, Delete, Delete Partition, and Insert‑Overwrite, providing a comprehensive overview for data‑lake practitioners.
Apache HudiSparkUPSERT
0 likes · 12 min read

This article explores SQLite’s 2018 SQL feature updates—from boolean literals and truth testing to window functions, FILTER clauses, upsert syntax, column renaming, and related API changes—highlighting syntax details, limitations, and practical examples for developers seeking to leverage these modern capabilities in production.
SQLSQLiteUPSERT
0 likes · 10 min read

This article reviews SQLite’s 2018 SQL enhancements—including Boolean literals, window functions, the FILTER clause, upsert syntax, and column‑renaming—explaining each feature, showing concrete code examples, comparing behavior with other databases, and noting remaining limitations.
Column RenamingFILTER clauseSQL
0 likes · 10 min read

This article reviews the SQLite SQL enhancements introduced between versions 3.22.0 and 3.26.0, covering boolean literals, window functions, the FILTER clause, upsert syntax, column renaming, and related API changes, while comparing SQLite’s support to other major database systems.
FILTER clauseSQLSQLite
0 likes · 10 min read

SQLite’s 2018 updates bring powerful new SQL capabilities—including true/false literals, IS TRUE/FALSE predicates, window functions, FILTER clauses, UPSERT syntax, and column‑renaming—demonstrating that this lightweight, serverless database can handle modern workloads while remaining reliable and widely deployable.
FILTER clauseSQLSQLite
0 likes · 9 min read

This article explains how ByteHouse extends ClickHouse by introducing the UniqueMergeTree engine, which adds full upsert and delete support, improves query performance, and enables real‑time audience selection scenarios while preserving scalability and reliability.
ByteHouseClickHouseDatabase Engine
0 likes · 9 min read

This article examines ClickHouse’s lack of native upsert and delete operations, explains how ByteHouse’s UniqueMergeTree engine introduces a Mark‑Delete + Insert approach to provide real‑time upsert/delete capabilities, and presents benchmark results showing dramatically faster queries with only modest write overhead.
ByteHouseClickHouseColumnar Database
0 likes · 10 min read

This article reviews SQLite's 2018 enhancements, covering Boolean literals, window functions, the FILTER clause, UPSERT syntax, column‑renaming support, and other API changes, while comparing SQLite's capabilities to other major database systems.
Boolean LiteralsFILTER clauseSQL
0 likes · 11 min read

ByteHouse, built on ClickHouse, addresses key limitations such as missing upsert/delete, weak multi‑table joins, scalability issues, and lack of resource isolation by introducing a modular, stage‑based execution engine, advanced join strategies, runtime filters, and a custom optimizer, delivering dramatically faster query performance.
ByteHouseClickHouseMulti-table join
0 likes · 11 min read

This article explores the challenges of real‑time data ingestion at massive scale, explains Hologres' innovative upsert model, performance optimizations, and compares its capabilities with other data‑warehouse solutions, demonstrating how it delivers low‑latency, high‑throughput writes for big‑data analytics.
HologresUPSERThigh-throughput
0 likes · 24 min read

This article reviews SQLite's 2018 enhancements, covering Boolean literals, window functions, the FILTER clause, upsert support, column renaming, and related API changes, while highlighting limitations and compatibility notes compared with other major databases.
Boolean LiteralsSQLSQL features
0 likes · 12 min read

The article explains SQLite’s 2018 enhancements—including boolean literals, window functions, FILTER clause, UPSERT syntax, and column‑renaming—detailing how these features work, their syntax, limitations, and providing code examples for developers seeking to use SQLite in production environments.
FILTER clauseSQLSQLite
0 likes · 10 min read

SQLite, often underestimated, introduced several powerful SQL enhancements in 2018—including boolean literals, window functions, FILTER clauses, UPSERT syntax, and column renaming—bringing its capabilities closer to major RDBMSes while retaining its lightweight, file‑based design.
Boolean LiteralsSQLSQLite
0 likes · 11 min read

The article reviews SQLite's 2018 enhancements—including boolean literals, window functions, FILTER clause, UPSERT syntax, and column‑renaming—explaining their syntax, behavior with NULLs, and practical examples, while also noting SQLite's reliability and deployment advantages despite lacking a network layer.
Boolean LiteralsFILTER clauseSQL
0 likes · 10 min read

This article reviews the SQLite SQL enhancements introduced between versions 3.22.0 and 3.26.0 in 2018, covering boolean literals, window functions, FILTER clauses, UPSERT syntax, column renaming, and related API changes with code examples and practical notes.
SQLSQLiteUPSERT
0 likes · 10 min read

This article reviews the SQLite enhancements introduced between versions 3.22.0 and 3.26.0 in 2018, covering Boolean literals, window functions, the FILTER clause, UPSERT syntax, column renaming, and related API changes, while comparing them to other major database systems.
Boolean LiteralsFILTER clauseSQL
0 likes · 11 min read

SQLite, often underestimated, has added powerful SQL capabilities in 2018—including true/false literals, advanced boolean checks, window functions, FILTER clauses, upsert support via INSERT ON CONFLICT, and column renaming—bringing its feature set closer to major databases while retaining its lightweight, file‑based architecture.
Boolean LiteralsSQLSQLite
0 likes · 12 min read

This article explains the background, design, and practical benefits of Hudi's Bucket Index—a hash‑based indexing mechanism that reduces unnecessary file reads and writes, improves upsert speed on terabyte‑scale datasets, and enables query optimizations such as bucket pruning and bucket join.
Bucket IndexHudiUPSERT
0 likes · 16 min read

This article describes the background, design choices, and practical challenges of using Apache Hudi for data updates on the Tongcheng Elong platform, analyzes three architectural alternatives, details Hudi's core configurations and write strategies, and presents concrete solutions to version compatibility, upsert semantics, insert behavior, partition management, streaming backlog monitoring, and business‑specific requirements, culminating in a productized Hudi service and future roadmap.
HiveHudiUPSERT
0 likes · 18 min read

This article explains the upsert‑kafka connector in Flink, its configuration parameters, step‑by‑step usage with SQL examples, and demonstrates a complete pipeline that reads Kafka streams, aggregates page view metrics, and synchronizes the results to TiDB in real time.
FlinkSQLTiDB
0 likes · 13 min read

This article explains the design of Apache Hudi, its core concepts such as upserts and incremental pulls, how Uber leverages it for large‑scale data‑lake operations, the enhancements made over time, and the project’s future plans within the Apache ecosystem.
Apache HudiIncremental PullUPSERT
0 likes · 17 min read

This article presents a comprehensive overview of Apache Hudi, covering its background, design motivations, architecture, view types, performance trade‑offs, compaction mechanisms, concurrency guarantees, and real‑world usage at Uber for managing petabyte‑scale data lakes.
HudiLambda architectureUPSERT
0 likes · 11 min read

The article explains PostgreSQL materialized views, their evolution, how they differ from regular views, demonstrates creating and refreshing them, and compares them with incremental rollup tables using upsert to help decide which method best fits performance and scalability needs.
Materialized ViewPostgreSQLSQL
0 likes · 6 min read

This guide explores advanced MySQL techniques—including ON DUPLICATE KEY UPDATE for upserts, INSERT IGNORE to bypass errors, replacing subqueries with JOINs, handling LEFT JOIN pitfalls, efficient pagination strategies, multi‑table UPDATE/DELETE via JOIN, and the nuances of COUNT(*) versus COUNT(1).
COUNTMySQLPagination
0 likes · 12 min read

This article explores PostgreSQL’s advanced SQL capabilities—including Common Table Expressions (WITH), batch inserts, the RETURNING clause, UPSERT with ON CONFLICT, TABLESAMPLE methods, aggregation functions like string_agg and array_agg, and a range of window functions—providing practical examples, performance insights, and guidance for real‑world use.
CTEPostgreSQLSQL
0 likes · 17 min read


ITPUBMar 8, 2017 · Databases
This article compares how to create tables and perform upsert (insert‑or‑update) operations in MS SQL and Oracle, presenting five distinct Oracle techniques—including implicit cursor, exception handling, dual table, no_data_found, and MERGE—each with complete PL/SQL code samples.
Database MigrationOraclePL/SQL
0 likes · 8 min read


ITPUBJan 8, 2016 · Databases
PostgreSQL 9.5 brings dramatic performance gains, new OLAP capabilities like GROUPING SETS, CUBE, ROLLUP, convenient pg_rewind for HA, flexible upsert handling, and enhanced JSONB output, all illustrated with practical examples and import techniques.
9.5Grouping SetsJSONB
0 likes · 4 min read
