Bobby Iliev

@bobbyiliev

6327 Points 111 Followers

149 Posts

335 Answers

Joined March 6th, 2019

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.

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

Bobby Iliev

2 days ago

5
Select One:

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

Bobby Iliev

5 days ago

3
Select One:

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

Bobby Iliev

6 days ago

5
Select One:

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

Bobby Iliev

4 weeks ago

5
Select One:

How to join MySQL and Postgres in a live materialized view

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

Bobby Iliev

1 month ago

4
Select One:

What is the difference between DATETIME and TIMESTAMP data type in MySQL?

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

Bobby Iliev

1 month ago

4
Select One:

Building a real-time web application with Materialize and AdonisJS

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

Bobby Iliev

1 month ago

10
Select One:

How to Find Duplicate Values in a SQL Table?

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

Bobby Iliev

1 month ago

7
Select One:

What is the difference between UNION and UNION ALL in SQL?

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

Bobby Iliev

1 month ago

4
Select One:

Learn Materialize by running streaming SQL on your nginx logs

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

Bobby Iliev

2 months ago

7
Select One:

What is the difference between JOIN and INNER JOIN in SQL?

Introduction If you've ever used SQL, you probably know that JOINs can be very confusing. In this quick post we are going to learn what the difference between JOIN and INNER JOIN is! Differe...

Bobby Iliev

2 months ago

8
Select One:

How to import an SQL file using the command line in MySQL?

Introduction In some cases if you have a really large .sql file, it is best to import it via the command line. You might need to do this in case that you are using a tool like PHPmyAdmin, wh...

Bobby Iliev

2 months ago

6
Select One:

How to Add a Default Value to an Existing Column in MySQL

Introduction In this quick tutorial, you will learn how to add a default value to an existing column in MySQL. Prerequisites You always need to be careful, when changing the structure of an...

Bobby Iliev

2 months ago

5
Select One:

The top 10 Linux Commands that Every Data Engineer Should Know

Introduction No matter if you are a data analyst or a system administrator when working with unstructured files in Linux there are a set of commands that would help you a lot in your daily t...

Bobby Iliev

2 months ago

5
Select One:

πŸ’‘ Free Introduction to Docker eBook

πŸ’‘ Introduction to Docker This is an open-source introduction to Docker guide that will help you learn the basics of Docker and how to start using containers for your SysOps, DevOps, and Dev...

Bobby Iliev

2 months ago

9
Select One:

Automatically display your latest posts on your GitHub Profile README

Introduction By creating a repository with the same name as your GitHub username (eg. bobbyiliev/bobbyiliev) you actually create a special repository. Its README.md will appear on your publi...

Bobby Iliev

2 months ago

8
Select One:

The Data Engineer Roadmap πŸ—Ί

Introduction With the ever growing data volumes and demands, the data engineering career has been one of the fastest growing jobs for the past few years. According to the 2021 Stack Overflow...

Bobby Iliev

2 months ago

7
Select One:

The Only Bash Scripting Cheat Sheet That You Will Ever Need

Introduction No matter if you are a DevOps/SysOps engineer, developer, or just a Linux enthusiast, you can use Bash scripts to combine different Linux commands and automate boring and repeti...

Bobby Iliev

2 months ago

7
Select One:

πŸš€ The Missing Docker Crash Course for Developers

Introduction to Docker It is more likely than not that Docker and containers are going to be part of your IT career in one way or another. In this blog post series I'll cover the following:...

Bobby Iliev

3 months ago

7
Select One:

8 Open Source Projects to Contribute to - Hacktoberfest 2021

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

Bobby Iliev

3 months ago

6
Select One:

πŸš€ The Missing SQL Basics Crash Course

Introduction No matter if you are a DevOps/SysOps engineer, developer, or just a Linux enthusiast, you will most likely have to use SQL at some point in your career. The guide is suitable fo...

Bobby Iliev

3 months ago

8
Select One:

How to Automatically Run Your Laravel PestPHP Tests on Each GitHub Pull Request?

Introduction PestPHP was created by Nuno Maduro who is also one of the Laravel core team members. PestPHP is an open-source PHP Testing framework created with simplicity in mind. PestPHP is...

Bobby Iliev

3 months ago

10
Select One:

How to optimize MySQL to speed up your Laravel application with Releem?

Introduction Optimizing your MySQL service is a great way to improve your Laravel application's overall performance. Of course, it is important to follow Laravel Eloquent's best performance...

Bobby Iliev

4 months ago

8
Select One:

How to keep a process running even after closing SSH connection?

Introduction There are many reasons why you would like to keep a process running even if you close your SSH session. Here are a few examples: Your working day is going to be over soon and y...

Bobby Iliev

4 months ago

5
Select One:

πŸ’‘ Free Laravel Tips and Tricks eBook

This is an open-source Laravel Tips and Tricks eBook that is a collection of my own notes that I've put together for myself throughout the years. You would more likely than not need many of...

Bobby Iliev

5 months ago

8
Select One:

How to limit the result with Laravel Eloquent?

Introduction The Eloquent ORM included with Laravel provides you with an easy way of interacting with your database. This simplifies all CRUD (Create, read, update, and delete) operations an...

Bobby Iliev

6 months ago

9
Select One:

How to get the current date and time in Laravel?

Introduction Working with date and time could be pretty challenging. Luckily we have the Carbon package that makes this super easy! Carbon is a simple PHP API extension for DateTime. You can...

Bobby Iliev

6 months ago

11
Select One:

How to Delete All Entries in a Table Using Laravel Eloquent?

Introduction The Eloquent ORM included with Laravel provides you with an easy way of interacting with your database. This simplifies all CRUD (Create, read, update, and delete) operations an...

Bobby Iliev

6 months ago

11
Select One:

How to Get the Base URL in Laravel?

Introduction Hardcoding the domain name in your Blade files or in your controllers is not a good practice. If you ever decided to change your website's domain name, you would have to manuall...

Bobby Iliev

6 months ago

9
Select One:

How to Order the Results of all() in Laravel Eloquent?

Introduction The Eloquent ORM included with Laravel provides you with an easy way of interacting with your database. This simplifies all CRUD (Create, read, update, and delete) operations an...

Bobby Iliev

6 months ago

8
Select One:

Loading More Content