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]
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.
MySQL: Check Database and Table Size
This process will work in all cases, whether you are accessing your database through the command line or using any GUI tool (like MySQL Workbench or HeidiSQL). Because the size-related information is already saved in a specific MySQL table. Check the table named “TABLES” from the database “information_schema”, you will find all the information related to the sizes of the tables.
Design Pattern: Factory Pattern
Factory pattern is one of the most popular and commonly used patterns. When we don’t know what is the type of object that is going to be generated then we use the Factory pattern to create objects based on some criteria.
Design Pattern: Singleton Pattern
Singleton pattern is used to ensure that only one instance of a class is created in any case, and whenever you want to get an instance of that class, then the same object instance is returned.
Configure Microsoft SQL Server using Docker and Azure data studio
Here is the easiest config and process that you can use for SQL Server on Docker and Azure Data Studio.
Laravel: Run Queue in the Background using PM2
In production you have to run this command using some process manager that will keep the command running. 2 most simple ways to do that is using Supervisor or PM2.I use pm2 in such cases, as this seems simpler to me. Let’s see how to use PM2 for running Laravel workers in the background.
Laravel: env() getting null value when used with config:cache
To avoid this situation, never use env(“ANY_VAR”) directly in your code. Instead, use it like config(“config_file_name.var_name”).
JavaScript: this – [full explanation]
This ‘this’ keyword is very confusing when you are writing code, especially when you read others’ code.This article’s goal is to eradicate those confusions. You have to remember a few things about ‘this’ and consider where you are using it and how you are using it.