Web development

A wise man said: “If you want to go to the backend, the database is a part that cannot be ignored.” Well, Let’s talk about optimizing database performance on my blog, connection pooling should be the suitable first candidate. So what is connection pooling? How to use the connection pool? Just take a cup of…

ID is important! ID is so important! I have to mention it twice, as the word, IDs play a crucial role in uniquely identifying records in a database. An ID must be unique in the system, and there are many strategies to generate a unique ID, but not all of them are good for the…

In this tutorial, you will learn about PostgreSQL recursive queries that use recursive common table expressions (CTEs) to generate the depth of a hierarchy. Introduction to the PostgreSQL Recursive Query PostgreSQL includes the WITH statement, which allows you to create auxiliary statements for use in queries. These statements are frequently referred to as common table…

JWT (JSON Web Token) and OAuth are two forms of authentication that are used to verify a user’s identity in different ways. Both have key advantages and limitations, and knowing the differences between them is important when making a decision about which authentication method to use for your application. Short answer TL;DR If you have very…

When creating a SQL database, one of the most important elements to consider is its acid properties. Acid stands for Atomicity, Consistency, Isolation, and Durability. These four properties help ensure that any data stored in the database is safe and will remain consistent no matter what changes occur.

Google – the biggest search engine, has over 99,000 searches every single second (Internet Live Stats, 2022). Then we can calculate the number of searches is over 8 billion a day. It’s incredible. Therefore, bringing your website to appear on search engines is an extremely important step in marketing. This is called SEO – Search Engine Optimization.…

In the previous post, we finished counting post views for WordPress by PHP and checking the view state by using a PHP session. For low-traffic websites, this approach works well. But PHP session memory grows as the volume of traffic does. Remember that web hosting often has quite limited memory. Therefore, this technique is unsafe…

The most widely used CMS for building websites is WordPress, which has a large user base and is relatively simple to use. In the store, we have many plugins for counting the post view of WordPress, but sometimes we want to control our data and the plugin may be too cloggy. I have a simple…

CSS – Cascading Style Sheets is a very important language to decorate the presentation of any website. In addition, CSS is also used in the development of user interfaces for mobile applications and even for desktop UI. Is CSS important to learn? The answer is yes. A website’s vital role is to commercialize a business’s…

I often have to do this thing again: Cover one element with another. The key CSS technique is the same every time: The first element is positioned relative, and the second will be marked as absolute. Often it’s a heading or caption that needs to cover an image, sometimes with a translucent background color or…

Though you may be familiar with TCP and UDP as a developer, do you understand what they are, how they differ, and how they impact software systems architecture? Overview of computer networks Before introducing TCP and UDP, we must first describe how computers and the internet communicate. When you use your computer or smartphone to…

This time I just returned to code some frontend projects and Tailwindcss was chosen to develop the UI instead of Boostrap, but I have to read the docs several times to design the column flexbox. What is Tailwindcss Tailwind is a utility-first CSS framework. It provides so many classes that help us create UI with…