Tag: database

All the articles with the tag "database".

• JDBC Streaming Reads and Correct Streaming Processing, with Examples

  9 Mar, 2024

  JDBC streaming reads.

• Kafka (Part 6): Oracle-to-PostgreSQL CDC with Kafka Connect and Debezium, and Cache Consistency

  2 Dec, 2023

  Introduces CDC and synchronizes Oracle data to PostgreSQL through a Kafka Connect and Debezium example. It discusses database synchronization, Elasticsearch imports, and cache consistency, comparing the conditions under which different approaches are suitable.

• PostgreSQL (Part 2): Best Practices for Procedural Language Usage

  26 Nov, 2022

  Database server-side programming with PL/pgSQL.

• MySQL Notes

  22 Sep, 2022

  MySQL study and development notes covering connection methods, data types, primary keys and indexes, storage engines, and transaction isolation levels. Through examples it discusses dirty reads, non-repeatable reads, phantom reads, and locks, and also records execution plan analysis, SQL optimization, and the roles of common logs.