sqlite-utils 4.1 release: new CLI features like --code for inserts, --type for column types, drop-index command, strict mode support, and more.
Learn how to perform bulk upserts (insert-or-update) in EF Core without performance issues, covering manual patterns, T-SQL MERGE, and third-party tools.
Explores hidden PostgreSQL features like upsert row counts, column grants, and pivot tables to improve database workflows.
How to configure the Kafka Connect JDBC Sink connector's pk.fields setting to use a Kafka message's primitive key for UPSERT operations into a PostgreSQL table.
A detailed overview of key new features in PostgreSQL 9.5, including Upsert, grouping sets, and pg_rewind.
A first look at the new UPSERT feature in PostgreSQL 9.5, explaining its syntax and practical use cases for developers.
A developer's wishlist for upcoming features in PostgreSQL 9.5, including upsert, foreign data wrapper improvements, and better replication.
A developer's perspective on missing features in PostgreSQL 9.4, focusing on upsert, JSON performance, and extension management.
