Virendra's Techtalk @virendrachandak - Tumblr Blog

What is ClickHouse? The open-source columnar OLAP database, explained.what it's for, when to use it, and when not to.

#analytics #ClickHouse #Columnar Database #MySQL #OLAP #OLTP #PostgreSQL

PostgreSQL 18 Docker Upgrade: Dump and Restore Method

PostgreSQL 18 introduces a major change to the official Docker image layout. The internal data directory is now version‑specific, which means you cannot simply switch your image tag from postgres:17 to postgres:18 and expect your existing volume to work. This guide walks you through a clean and reliable upgrade using the dump and restore method. What Changed in PostgreSQL 18? Starting with…

#PostgreSQL

Web Vitals Metrics - What you should know

Web Vitals Metrics – What you should know

What are Web Vitals?

Web Vitals is an initiative by Google to provide unified guidance for quality signals that are essential to delivering a great user experience on the web. These consists of some Core Web Vitals (LCP, FID and CLS) and a few others (TTFB and FCP).

What are Core Web Vitals?

For the first iteration Google has decided to use the three metrics called “Core Web Vitals”. These…

View On WordPress

#Core Web Vitals #Web Vitals

Track Web Vitals in Google Analytics

There are a few different ways to track Web Vitals, however the easiest way is using the web-vitals JavaScript library. In this post we will load the web-vitals directly from CDN and use that to track the Core Web Vitals (LCP, FID, CLS) and other Web Vitals (FCP, TTFB) metrics.

Track Web Vitals in Google Analytics using analytics.js

The following block of code can be used to measure and send…

View On WordPress

How to Check Laravel Version through CLI / command prompt and file

There are 2 easy ways to find out what version of laravel you are using. They are by running php artisian commands on CLI or checking the files.

Method 1: Check Laravel Version using CLI / Command Prompt

$ php artisan --version Laravel Framework 7.12.0

The tells us that the Laravel Framework version we are currently using is 7.11.0 Alternative to the above command is

$ php artisan -V Laravel…

View On WordPress

#laravel

PHP 7.4 - Null Coalesce Assignment Operator

PHP 7.4 – Null Coalesce Assignment Operator

PHP 7.4 added a new Null Coalesce Assignment Operator (??=) which is an enhancement of Null Coalesce Operator (??)introduced in PHP 7. The Null Coalesce Assignment Operator (??=) assigns the value of the right-hand parameter if the left-hand parameter is null. If the left-hand parameter is not null then its value is not changed. The Null Coalesce Assignment Operator is sometimes also called as…

View On WordPress

#PHP 7

Generating bcrypt .htpasswd passwords using PHP

In my previous post we saw how to generate .htpasswd file using crypt and apr1-md5 algorithm in PHP. However, now there is a more secure BCRYPT algorithm that can be used since apache 2.4 for passwords in .htpasswd. In this post we will generate .htpasswd file using the BCRYPT algorithm in PHP. (more…)

View On WordPress

#.htaccess #.htpasswd #Apache #Configuration file

How to remove render blocking JavaScript with defer and async

With HTML5 there are 2 new boolean attributes for <script> tag which indicates to the browser how the script should be evaluated. The 2 attributes are defer and async. Using these attributes can help improve the page load time by downloading the script in parallel when the page is being parsed and then executing it either immediately or at the end of page parsing. (more…)

View On WordPress

#async #defer #JavaScript

What does int(11) means in MySQL?

A very common misconception about what int(11) means in MySQL is that the column can store maximum integer value with 11 digits in length. However, this is not true. int(11) does not determines the maximum value that the column can store in it. 11 is the display width of the integer column, unlike the characters columns where the number means number of character that can be stored. (more…)

View On WordPress

#display width #zerofill

How to add custom nodes to WordPress RSS feed

Recently I was working on a WordPress site and wanted to add a custom node to the WordPress RSS Feeds. In my previous post How to add featured image to WordPress RSS feedwe saw how to add a featured image to the post content in RSS Feed. In this post we will see how we can add any node to the RSS Feed. To add a custom node in the RSS feed we just need to add some code to the theme’s functions.php…

View On WordPress

PHP 7 - Combined Comparison (Spaceship) Operator

PHP 7 – Combined Comparison (Spaceship) Operator

In this post we will take a look and another new operator in PHP 7. This operator is the Combined Comparison or Spaceship operator (<=>). This operator is a three way comparison operator. It will do greater-than, less-than and equal comparisons between two operands.

The spaceship operator (<=>) returns -1 if the left side is smaller, 0 if the values are equal and 1 if the left side is larger. It…

View On WordPress

PHP 7 - Null Coalesce Operator

PHP 7 – Null Coalesce Operator

PHP 7 brings a lot of improvements, features and new operators as compared to the earlier versions on PHP. One of the new operators is the Null Coalesce Operator (??). This operator can be used instead of using isset() along with the ternary operator (?:).

The Null coalesce operator (??) returns the result of its first operand if it exists and is not NULL, or else it will return its second…

View On WordPress

How to create a zip file using PHP

Recently I had to write a script to create a zip file containing different files and folders. PHP has a ZipArchive class which can be used easily to create zip files. In this article we will see how to create zip files in PHP. We will create different zip files from different files and folders.

Create a new zip file

Overwrite an existing zip file

Create a new zip file and add files to be inside…

View On WordPress

How to create CSV file using PHP

CSV (comma-separated values) is one of the most popular methods for transferring tabular data between applications. Lot of applications want to export data in a CSV file. In this article we will see how we can create CSV file using PHP. We will also see how to automatically download the file instead of just showing it in the browser or giving the user a link to download it.

Creating a CSV file…

View On WordPress

How to sort a multi-dimension array by value in PHP

In this article we will see how to sort a multi-dimension array by value of one of the keys of the array. We can use a few different methods to do this. One way to to use usort() function. Another way is to just identify the values and create another array with the values and then use it in the array_multisort()function. Using the multisort method we can easily sort a multi-dimension array based…

View On WordPress

How to add favicon in WordPress using Jetpack

In my earlier post Understanding favicon I explained what is a favicon, how to create and add it to your site. To add the favicon you have to create an icon and upload it to your server and then add some code to your site. However, if you have only WordPress site and you use Jetpack plugin, then you can easily add the favicon to your site using the new Site Icon module introduced in Jetpack 3.2 (m…

View On WordPress

How to enable HTTPS on WordPress using CloudFlare

Recently, Google said it will use HTTPS as a ranking signal. So, if you are a website owner, you might be thinking of switching to HTTPS. However, that meant purchasing an SSL certificate. Last month CloudFlare announced Universal SSLwhich will allow all its customers (including free users) to be able to use SSL on their sites. So now, we can have SSL on our websites without having to pay for an…

View On WordPress

Trending Blogs

Recently Viewed Blogs

Virendra's Techtalk