Featured Image

Debezium: PostgreSQL Change Data Capture (CDC)

Figure 1: Debezium Postgres Connector 1. Goal Set up Debezium to capture row-level changes in the schemas of a PostgreSQL database and publish to Kafka topic(s). The high-level architecture is unquestionably explained in the above diagram 😎. Pikachu, aka Debezium PostgreSQL Connector, detects and carries/publishes row-level change events to Kafka topic(s) for configured Postgres tables. ...

Figure 1: Debezium Postgres Connector 1. Goal Set up Debezium to capture row-level changes in the schemas of a PostgreSQL database and publish to Kafka topic(s). The high-level architecture is unquestionably explained in the above diagram 😎. Pikachu, aka Debezium PostgreSQL Connector, detects ...

Read more
Featured Image

Postgres as a Graph Database

Neo4j vs PostgreSQL Have you ever come across the need to store a graph in a relational database because using/onboarding a graph database for a small use-case is overkill? Before jumping into using a relational database like MySQL or PostgreSQL as a graph database, let’s lay down the fundamentals: What is a Graph? A graph is a set of vertices/nodes interconnected by edges/links. The edges ...

Neo4j vs PostgreSQL Have you ever come across the need to store a graph in a relational database because using/onboarding a graph database for a small use-case is overkill? Before jumping into using a relational database like MySQL or PostgreSQL as a graph database, let’s lay down the fundamen...

Read more
Featured Image

Documentation: Conceptualization of a Cartogram

Explanation 1. What is a cartogram? Simply put, a cartogram is a map. But a cartogram is a unique type of map that combines statistical information such as population with geographic location. Typically, physical or topographical maps show relative area and distance, but they do not provide any data about the inhabitants or the population of a place. For example, a quick and intuitive view...

Explanation 1. What is a cartogram? Simply put, a cartogram is a map. But a cartogram is a unique type of map that combines statistical information such as population with geographic location. Typically, physical or topographical maps show relative area and distance, but they do not provide ...

Read more
Featured Image

Why You Should Reinvent the Wheel

Reinvent the Wheel! As I get slightly older and slightly wiser - to me, it’s more and more apparent that we humans live a life full of contradiction, are rarely self-satisfied, and thrive on learning and discovering new things. It’s as if a duty to contribute with all the might to a better future, not for oneself, but for the future, that’s way beyond imagination and self-existence. On thes...

Reinvent the Wheel! As I get slightly older and slightly wiser - to me, it’s more and more apparent that we humans live a life full of contradiction, are rarely self-satisfied, and thrive on learning and discovering new things. It’s as if a duty to contribute with all the might to a better fut...

Read more

  • #
  • Page 1 of 7
  • Next