PHP: Server-Sent Events(SSE)
This article will explain, how to implement Server-Sent Events(SSE). Let’s discuss it step-by-step. Let’s create the simplest SSE server in PHP.
Server-Sent Events(SSE)
Server-Sent Events(SSE) are used to implement real-time communication, where the server sends data to the client. In this article, we have discussed all the details of the SSE implementation. All the headers and options are covered in this article.
Design Pattern: Abstract Factory Pattern
Using the Factory pattern we generate objects based on some criteria. In Abstract factory pattern, we use multiple factory pattern implementations and generate objects based on that. Abstract factory pattern is also called Factory of Factory, so before reading about Abstract factory pattern, take a look at the Factory pattern.
MySQL: Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
If data sent to MySQL is larger than “max_allowed_packet” then the request fails. Increase the value of “max_allowed_packet“ to fix this.
MySQL: Pivot Table – Pivot Rows to Columns Dynamically
In this article, we will see how to implement a pivot table in MySQL. We will do that step by step, so that it becomes clear, what we are doing and why we are doing it.
MySQL: Clone/Duplicate Table (with or without data)
This article will show different ways to clone or duplicate a MySQL table. All the available methods are discussed. Choose the process which suits your need.
MySQL: Find and Delete Duplicate Rows (for single/multiple columns)
In this article, I will discuss 2 ways to get rid of duplicate rows from your MySQL database table. The first one will work for any MySQL version, but the second one will work for MySQL 8 or later version.
MySQL: CAST any Data Type as INTEGER
To CAST any data type to Integer in MySQL, you need to CAST it as SIGNED (for getting a signed integer) or UNSIGNED (for getting unsigned integer).
NodeJS: Server-Sent Events(SSE) using ExpressJS
Follow the steps below to implement Server-Sent Events (SSE) in NodeJS. We are using the ExpressJS framework for the implementations here, but the same approach will work for any NodeJS framework.
Design Patterns [classic/core patterns for OOP]
Design Patterns are solutions to common/general problems while designing software. In this article we are discussing what design patterns are, the type and use-cases.