Hello, my name is Bobby. Welcome to my Dev Blog

I am a professional DevOps Engineer with a demonstrated history of working in the internet industry. I am an avid Linux lover and supporter of the open-source movement philosophy.

Blog Post illustration

Introduction Event streams provide you with a way to send events to the client without having to reload the page. This is useful for things like updating the user interface in real-time changes are made to the database. Unlike traditional Long-pollin...

bobbyiliev avatar
Bobby Iliev
Blog Post illustration

Introduction This is a self-contained demo using Materialize to process data IoT devices data directly from a PostgreSQL server. The demo builds up on the How to build AdonisJS API to store your Raspberry Pi Temperature tutorial. The data is generate...

bobbyiliev avatar
Bobby Iliev
Blog Post illustration

Introduction This is a self-contained demo using Materialize. This demo shows you how to use dbt together with Materialize. For this demo, we are going to monitor the reviews left by users on a demo website, and use dbt to model our business logic, l...

bobbyiliev avatar
Bobby Iliev
Blog Post illustration

Introduction I have a few Raspberry Pi devices at home and I wanted to be able to collect the data from their temperature sensors on a regular interval and store that data in a Postgres database. Later on, I could use that data for some analytics tog...

bobbyiliev avatar
Bobby Iliev
Blog Post illustration

Introduction This is a self-contained demo using Materialize. This demo would show you how to use Materialize to join MySQL and Postgres in a live materialized view. For this demo, we are going to monitor the orders on our demo website and generate e...

bobbyiliev avatar
Bobby Iliev
Blog Post illustration

Introduction If you have ever worked with MySQL and had to create your table structure, you have probably noticed that the DATETIME and TIMESTAMP data types are quite similar at a first glance as they have a lot of similarities. In this tutorial, we ...

bobbyiliev avatar
Bobby Iliev
Blog Post illustration

Introduction In this tutorial, we are going to build a web application using AdonisJS and integrate it with Materialize to create a real-time dashboard based on streaming data using standard SQL. Materialize lets you define views you want to maintain...

bobbyiliev avatar
Bobby Iliev
Blog Post illustration

Introduction In this quick tutorial, you will learn how to find the duplicate values in a SQL table with a single SQL query. Let's say that we have a table called users with the following data: SELECT username,email FROM users; +----------+----------...

bobbyiliev avatar
Bobby Iliev
Blog Post illustration

Introduction If you've ever used SQL, you probably know that UNIONs can be quite confusing at first. In this quick post we are going to learn what the difference between UNION and UNION ALL is! Difference between UNION and UNION ALL The main thing to...

bobbyiliev avatar
Bobby Iliev
Blog Post illustration

Introduction In this tutorial, I will show you how Materialize works by using it to run SQL queries on continuously produced nginx logs. By the end of the tutorial, you will have a better idea of what Materialize is, how it's different than other SQL...

bobbyiliev avatar
Bobby Iliev
« 1 2 3 4 5 6 7 8 9 10 ... 14 15