Interesting Stuff - Week 45, 2020

Posted by nielsb on Sunday, November 8, 2020

Throughout the week, I read a lot of blog-posts, articles, and so forth, that has to do with things that interest me:

  • data science
  • data in general
  • distributed computing
  • SQL Server
  • transactions (both db as well as non db)
  • and other “stuff”

This blog-post is the “roundup” of the things that have been most interesting to me, for the week just ending.

Big Data

Distributed Computing

  • Microservices — architecture nihilism in minimalism’s clothes. This post looks at microservices and argues that there is no such thing as a microservice architecture, but software architecture. The author also looks at the size of a microservice and argues that there is no prescribed size of a microservice. I found the post very interesting!

Streaming

  • Change Data Capture with Azure, PostgreSQL, and Kafka. In this blog post, the author looks at how one can use Change Data Capture to stream database modifications from PostgreSQL to Azure Data Explorer, (Kusto), using Apache Kafka. It is an interesting post! As a side note, I must say that Azure Data Explorer looks really interesting!
  • Announcing Pull Queries in Preview in Confluent Cloud ksqlDB. ksqlDB has two types of queries: push and pull. Push queries allow you subscribe to a query’s result as it changes in real-time, whereas with a pull query you fetch the current state of a materialized view. Both types of queries have been in Confluent Platform for a while, but Confluent Cloud has up until now only supported push queries. That changes now, and the post I linked to here discusses more in detail about the support for pull queries in Confluent Cloud.

WIND (What Is Niels Doing)

Well, it is not so much about what I am doing, as it is of what I have been doing the last couple of days. You who read my blog are probably aware that:

Figure 1: SQL Server & Kafka

Yes, I am speaking at the conference! My topic is about, as you can see in Figure 1, the various ways we can stream data from SQL Server to Apache Kafka. In a previous roundup, I wrote how I was prepping for the talk. That is all good and well, but a while ago a “curve-ball” was thrown: the conference is obviously virtual, but: we are not presenting live! Which means that the last few days, I have been recording, and editing the recording. Geez, recording and editing is hard work, compared to “just” deliver. Well, it is done now, and if you register you have the chance to see other speakers and me in a recorded fashion.

~ Finally

That’s all for this week. I hope you enjoy what I did put together. If you have ideas for what to cover, please comment on this post or ping me.


comments powered by Disqus