#webdev #sql #database #db

Understanding Data Normalization and Database Design Principles

In the world of database management, data normalization and database design principles are crucial for creating efficient and scalable databases. This post will guide you through the basics of these concepts, their importance, and provide practical examples to help you understand how to apply them.

👉 Read article

@webdev_trends

#webdev #sql #database #db

Concept of Backup and Recovery

In today's digital age, data is one of the most valuable assets for any organization. Ensuring the safety and availability of this data is crucial. This is where the concepts of backup and recovery come into play. In this post, we will explore what backup and recovery are, why they are important, and how to implement them effectively, with a specific focus on SQL Server.

👉 Read article

@webdev_trends

#webdev #javascript #nodejs #backend

Implementing WebAuthn for passwordless logins

Remembering and storing passwords can be such a hassle for our users — imagine if logging in was overall easier for everyone. That’s where WebAuthn, or Web Authentication API, comes in. WebAuthn aims to offer a future without passwords.

👉 Read article

@webdev_trends

#webdev #javascript #beginners #tutorial

Understanding JavaScript Objects: The Building Blocks of Your Code

JavaScript is a versatile language, and at the heart of its flexibility lies the concept of objects. If you're diving into JavaScript or brushing up on your skills, mastering objects is essential. Let's explore what JavaScript objects are, why they are so powerful, and how you can use them effectively in your projects.

👉 Read article

@webdev_trends

#webdev #javascript #regex

Regexes Got Good: The History And Future Of Regular Expressions In JavaScript

Although JavaScript regexes used to be underpowered compared to other modern flavors, numerous improvements in recent years mean that’s no longer true. Steven Levithan evaluates the history and present state of regular expressions in JavaScript with tips to make your regexes more readable, maintainable, and resilient.

👉 Read article

@webdev_trends

#webdev #javascript #regex

Count(*) or Count(1) - Which Should You Use?

When working with databases, one common task is counting the number of rows in a table. Two popular methods to achieve this are using COUNT(*) and COUNT(1). However, there’s a lot of debate among developers and database administrators about which one is better. In this article, we'll dive deep into the differences between COUNT(*) and COUNT(1), exploring their performance implications, use cases, and the myths surrounding them. By the end, you'll have a clear understanding of when to use each method.

👉 Read article

@webdev_trends

#webdev #css #svg #javascript #frontend

Line Numbers for `<textarea>` using SVG

The other day I was working on a JSON Schema Generator, and wanted to display line numbers in a`<textarea>`. Nothing fancy, and not considering soft line-breaks or anything remotely complicated.

👉 Read article

@webdev_trends

#webdev #laravel #php #html

How to Convert HTML to Excel using table2excel

Hello, web developers! In this article, we'll see how to convert HTML to Excel using table2excel, Here, we'll export the HTML table to Excel in jQuery. Here, we'll use the table2excel jQuery plugin to export or download Excel files from the HTML table.

Also, you can install it in multiple ways, like Bower, CDN file, etc.

👉 Read article

@webdev_trends

#webdev #laravel #php #json

Laravel Translations: Keys as JSON String or PHP Array?

It's easy to use text translations in Laravel. However, there are two ways to identify a key: as a string (('My profile')) or as an array key (`('users.my_profile'`). Let me tell my opinion on which one is a better choice.

Using translation as a string can be tempting, as it's easier for non-technical people to translate those phrases from JSON than from PHP array.

However, for bigger projects, having one huge en.json may be a pain to maintain. It can also lead to errors or unexpected behavior. Let's examine two problems.

👉 Read article

@webdev_trends

#webdev #php

Extend or implement

I'm probably part of a small group that actually cares about this: the difference between extending an abstract class and implementing an interface (ideally with a trait to provide part of the default implementation). I don't expect many people to follow my reasoning, but hey, it's my blog, I can write whatever thoughts are coming to my mind 😅

👉 Read article

@webdev_trends

#webdev #php #laravel

How to Pass Data From Route to Controller and View in Laravel 11

Since the 2020 leading up to 2024, the development in Laravel has been a blessing for the devs across the globe. In this small code example we would walk you the path of passing data from a route to a controller and then to a view is a fundamental aspect of Laravel development in general and we see that much often. Laravel 11, as with its previous versions, provides an elegant and efficient way to manage this process. Understanding how to effectively pass data between these components is crucial for building dynamic and responsive web applications.

👉 Read article

@webdev_trends

#webdev #php

Product-focused team vs Body leasing. What’s the Difference?

Product-focused teams and body leasing are popular software development models in the IT sector; however, their operational dynamics are as different as day and night.

The former prioritizes permanent staffing, while the latter relies on temporary staffing.

Now, when you hire staff on a temporary basis, which means they could be gone anytime soon, tell us what sort of commitment levels they’d bring to the table. Think about it! Won’t it be half-hearted? Or maybe one-fourth-hearted?

👉 Read article

@webdev_trends

#webdev #php

The PHP Foundation - future of PHP is in a good hands!

PHP began as a personal project by Rasmus Lerdorf in 1994, initially named Personal Home Page, and has gained popularity since then thanks to its simplicity and availability in most web hosting environments. PHP was originally designed as a set of Common Gateway Interface (CGI) binaries written in C, but over the last two decades, has evolved into a powerful server-side scripting language.

As PHP has grown, so has its need for support and development. Today, this is provided by the PHP Foundation and the PHP development team itself. The foundation plays a key role in PHP’s development, security updates, and engaging with the community. It is a non-profit organization supported purely by sponsors.

👉 Read article

@webdev_trends

#webdev #javascript #react #tutorial

How to use the `useTransition` hook the improve performance in React

React is a popular JavaScript library for building user interfaces. It’s known for efficiency and focus on creating reusable UI components. one of key features in React is the introduction of hooks which are function that hooks into React state. on of those hooks is the useTransition hook. This hook allows the state change to happen without blocking the interface which result in smooth experience.

👉 Read article

@webdev_trends

#webdev #css #anchor #ScrollDivenAnimation

Custom Range Slider Using Anchor Positioning & Scroll-Driven Animations

Anchor positioning and scroll-driven animations are among of the most popular and exciting CSS features of 2024. They unlock a lot of possibilities, and will continue to do so as browser support improves and developers get to know them.

👉 Read article

@webdev_trends

#webdev #podcast

ConTejas Code Podcast

I’ve been a fan of Tejas’ podcast since he started it. He is an extremely gracious host that asks interesting questions and brings out the best in the people he has on. I was thrilled when he asked me to record an episode with him.

👉 Read article

@webdev_trends

#webdev #docker #devops

Why Docker is a Game-Changer for Development, Not Just Production

In today’s fast-paced software development landscape, Docker is not just a tool for deployment but a transformative force in development workflows. While its role in streamlining production environments is well-known, Docker's impact on development is equally significant and often overlooked.

👉 Read article

@webdev_trends

#webdev #laravel #helper

When everything fails, you can always trust the Laravel rescue helper

Your application probably has a number of minor and more significant bugs. Some bugs will destroy your application, making it impossible to use, while others can be ignored.

👉 Read article

@webdev_trends

#webdev #programming #CleanCode

Benefits of writing clean, maintainable code

I have been writing code now for close to 20 years, but for the vast majority of that, I never really paid much attention to how my code looked, how maintainable it was long term, I was only really interested in if it worked and did what it was supposed to, but it was full of bad practices and I had a lot of bad habits.

👉 Read article

@webdev_trends

#webdev #laravel #tips #php

Laravel Model Tips

Laravel provides a huge amount of cool features that help improve our development experience (DX). But with the regular releases, stresses of day-to-day work, and the vast amount of features available, it's easy to miss some of the lesser-known features that can help improve our code.

In this article, I'm going to cover some of my favourite tips for working with Laravel models. Hopefully, these tips will help you write cleaner, more efficient code and help you avoid common pitfalls.

👉 Read article

@webdev_trends

#webdev #laravel #vite #php #JavaScript

Asset Prefetching Strategies with Vite in Laravel 11.21

The Laravel team released v11.21 this week, which includes asset prefetching strategies for Vite, a convenience method to force-destroy models with soft deletes, testing helper updates, and more.

👉 Read article

@webdev_trends