Bobby Iliev

@bobbyiliev

11839 Points 175 Followers

175 Posts

691 Answers

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.

Bobby Iliev · 2 weeks ago

How to show all tables in PostgreSQL?

Introduction PostgreSQL is a powerful, open-source database system. It is a relational database management system (RDBMS) based on the SQL language. PostgreSQL is one of the most popular dat...
8

Bobby Iliev · 1 month ago

How to flatten JSON array in SQL using jsonb_array_elements?

Introduction The jsonb_array_elements function returns a set of rows, one for each element of the input array. The input array can be a top-level array or a nested array. In this tutorial, w...
3

Bobby Iliev · 1 month ago

9 Open Source Projects to Contribute to - Hacktoberfest 2022

Introduction Hacktoberfest is a month-long event where people are awarded for contributing to open source projects 🙌. In order to participate you need to sign up here and then Submit four p...
4

Bobby Iliev · 3 months ago

How to find the version of an installed npm package?

Introduction npm is a package manager for Node.js. It is used to install and manage packages for your JavaScript projects. npm is open source and was initially released in 2009. The npm repo...
5

Bobby Iliev · 4 months ago

How to pass command line arguments to a Node.js app?

Introduction Similar to a Bash script where you can pass arguments to a script using the $1 syntax, you can also pass arguments to a Node.js app. In this quick tutorial, you will learn how t...
7

Bobby Iliev · 4 months ago

Quick introduction to WebSockets with Node.js

Introduction WebSockets allow you to send and receive data over a network without having to use a traditional HTTP protocol. Using WebSockets, you can build a real-time application. For exam...
6

Bobby Iliev · 5 months ago

Building a live chart with Deno, WebSockets, Chart.js and Materialize

Introduction This is a self-contained example of a real-time chart powered by Deno, Web Sockets, Chart.js, and Materialize. Deno is a simple and secure runtime for JavaScript and TypeScript...
6

Bobby Iliev · 5 months ago

How to use Materialize with DigitalOcean Serverless Functions

Introduction Materialize is a streaming database for real-time analytics. It was launched in 2019 to address the growing need for the ability to build real-time applications easily and effic...
4

Bobby Iliev · 5 months ago

Python Script to Copy The Content of a Materialized View to S3

Introduction Materialize is a streaming database for real-time analytics. It was launched in 2019 to address the growing need for the ability to build real-time applications easily and effic...
6

Bobby Iliev · 6 months ago

Using Deno and Materialize to send notifications in real-time

Introduction This is a self-contained example of a real-time notification app with Deno, Materialize and Discord. Deno is a simple and secure runtime for JavaScript and TypeScript that uses...
7

Bobby Iliev · 6 months ago

Scaling Laravel with Serverless Redis

Introduction Laravel is a popular PHP framework for building scalable, high-performance web applications. In this article, we will learn how to use serverless Redis to scale Laravel applicat...
7

Bobby Iliev · 6 months ago

Using LogicLoop and Materialize with dbt and Redpanda/Kafka

Introduction LogicLoop allows you to write rules in SQL and then run them against your data and trigger different actions based on the results. LogicLoop also allows you to create and share...
5

Bobby Iliev · 6 months ago

Building an Order Tracking Demo App using AdonisJS Materialize and Redpanda

Introduction This is a self-contained demo using Materialize to process orders and display the delivery status and coordinates in real-time. Prerequisites Before you get started, you need to...
5

Bobby Iliev · 7 months ago

Serverless Node.js URL Shortener App powered by Upstash Kafka and Materialize

This is a simple Node.js URL shortener app that uses Cloudflare Workers. The app is powered by Cloudflare Workers and Upstash Redis for storing data and Kafka for storing the click events al...
8

Bobby Iliev · 7 months ago

Using Materialize and Airbyte with MySQL and Redpanda/Kafka

Introduction This is a self-contained demo using Materialize. This demo would show you how to use Materialize with Airbyte to create a live dashboard. For this demo, we are going to monitor...
5

Bobby Iliev · 8 months ago

How to manage your Materialize migrations with Laravel Zero?

Introduction Managing your schema migrations is essential for any application. In this tutorial, we will show you how to manage your Materialize schema migrations with Laravel Zero. Material...
4

Bobby Iliev · 8 months ago

Blue-green deployments with Materialize

Introduction Minimizing downtime during any deployment is a key part of any successful deployment strategy. There are many ways to achieve this, and blue-green deployments are one of them. U...
3

Bobby Iliev · 8 months ago

How to use 'IF' in 'SELECT' SQL statements?

Introduction In some cases, you might want to choose the output value based on column values directly in your SQL statement. In this article, we will explain how to use the CASE expression i...
11

Bobby Iliev · 8 months ago

How to use Laravel WebSockets 🛰

Introduction In this guide, we will walk you through how to use Laravel WebSockets. We will be using the Laravel WebSockets package which is a great replacement for Pusher. The Laravel WebSo...
13

Bobby Iliev · 9 months ago

How to use server-sent events (SSE) with FastAPI?

Introduction Server-sent events (SSE) is a way to send data to the browser without reloading the page. This allows you to use streaming data and build real-time applications that can be used...
4

Bobby Iliev · 9 months ago

How to use FastAPI with Materialize for real-time data processing

Introduction This is a self-contained demo of FastAPI and Materialize. This demo project contains the following components: FastAPI: A fast, modern, and feature-rich framework for building...
3

Bobby Iliev · 9 months ago

How to produce records to a topic in Redpanda from a shell script?

Introduction Redpanda is a Kafka-compatible event stream platform written in C++. It comes with a simple command-line interface called rpk that lets you interact with the platform. In this t...
4

Bobby Iliev · 9 months ago

What is new in Laravel 9

Introduction Laravel is a PHP framework for web development. It was created by Taylor Otwell and was initially released as an open-source project in June 2011. Since its initial release, Lar...
4

Bobby Iliev · 9 months ago

10 simple tips for optimizing your Laravel application

Introduction Laravel was created by Taylor Otwell and was initially released in June 2011. It is an open-source PHP framework that is used to build web applications. It is without a doubt th...
5

Bobby Iliev · 9 months ago

Decoupled Microservices Architecture with Materialize

Introduction There are several ways to handle data in a microservice architecture, in this article we will cover the approach of having a separate database for each microservice. Prerequisit...
5

Bobby Iliev · 10 months ago

How to connect Laravel to Materialize and build a live dashboard?

Introduction Materialize is a streaming database that takes data coming from different sources like Kafka, PostgreSQL, S3 buckets, and more and allows users to write views that aggregate/mat...
2

Bobby Iliev · 10 months ago

How to create a simple event streaming in Laravel?

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 chan...
6

Bobby Iliev · 10 months ago

Using Materialize and Redpanda to Analyze Raspberry Pi Temperature Data

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...
3

Bobby Iliev · 10 months ago

How to use dbt with Materialize and Redpanda

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 o...
5

Bobby Iliev · 11 months ago

How to build AdonisJS API to store your Raspberry Pi Temperature

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 data...
5

Loading More Content