Latest by topics

Trending Articles

Development

SQL Functions and Techniques Every Data Person Should Know

Writing SQL queries that don’t utilize database features can cost developers a lot. The cost varies from spending more time writing tedious long queries or having a tech debt later on to debug the performance issue coming from the database server. PostgreSQL has features that help you select data efficiently. These features can also help minimize the lines you write SQL queries. In a previous tutorial, we discussed why and how to use window functions in PostgreSQL to aggregate data. However, this tutorial will show you what’s beyond aggregate functions, especially with the HAVING clause. You will also learn about subqueries and different types of JOINs.

Development

How to Use Indexes to Increase MySQL Database Performance

What are Indexes? Have you ever tried finding a chapter in a huge book, and you head over to the “Table of Contents” or Index page and seek the page number for the chapter? That’s a similar way DBMS use indexes to speed up data retrieval. Indexes are made up of keys from one or more columns in a table and they contain pointers that tell MySQL where a particular row of data is stored in the database. This enables the MySQL server to skip searching long rows of a table to find that piece of data thus boosting query speed. Additionally, indexes enable data to be better organized on disk . The MySQL Join Optimizer also uses indexes to speed up queries that involve joins.

Development

How to Implement Infinite Scroll in React.js by Building a TikTok Clone

In 2006, Aza Raskin introduced the infinite scroll concept, a functionality that would later transform our digital lives. Facebook, TikTok, AliExpress, and Pinterest, to name a few, have all implemented the infinite scroll feature in their stories or feeds. Infinite scrolling essentially brings endless information and entertainment to your screen. You keep scrolling and scrolling but never get to the end. Through the years, it has gathered a lot of criticism, even from its creator , due to its addictive nature. Regardless, this technology is fascinating from both a behavioral and implementation perspective.

Development

The Environmental Impact of Digital Technology and How Software Eco-Design Can Help

We often have the impression that digital technology does not pollute. This is usually because software pollution is mainly invisible to the general public thanks to dematerialization (the use of the cloud or online word processing services, for example), which is ultimately only the decentralized materialization of digital services. However, when we use these digital services, we utilize the 3-tier hardware architecture composed of:

Development

4 Ways to Use JavaScript .slice() Method and How to Do Each

The JavaScript .slice() method is a common method that’s often used in code but not often understood by novice developers. To help you understand this helpful method, we will discuss exactly what it is and four ways you can use it. ℹ️ Before getting started, we assume that you understand how functions work in JavaScript. If not, check out the JavaScript functions guide to learn more. What is the .slice() method? Put simply, .slice() returns a portion of an array. It’s implementation looks something like this:

Development

Rules of React Hooks

Over the years, React has become one of the most used and loved JavaScript frameworks in the world. React is a component-based library with two standard ways of defining its components: You can use these two methods to achieve the same outcome but with different syntax. The class components are ES6 classes that return JSX and necessitate a React class extension, while the functional components are ES6 functions that return a React element as JSX. It is essential to know that they both return JSX (JavaScript XML), allowing us to write HTML elements in JavaScript. React then takes this JSX and places the elements in the DOM.

Development

Redux vs Recoil – Comparing Two React State Libraries

State management is indispensable when building medium to large-scale React projects due to the large number of components that must be able to communicate with each other efficiently. Also, these large projects may have logic implemented on the front end that requires a global application state. Luckily, in addition to the state management solutions and features shipped with React, there are specialized libraries built for managing state in React applications.

Development

An Introduction to Global State Management in React without a Library

Scalable React projects tend to contain code bases with numerous components making up the primary application. Good data management and communication between these individual components is pivotal for cleaner code, and improved data sharing between components. Global state management was created as a means to centralize and manage data in an application, making it easily mutable and available to all components in the application. Finding and implementing a suitable means to handle global state management is an integral part of an application.

Development

How to Create Interactive Animated Backgrounds in React with tsParticles

Adding animations to a site is a great way to make it stand out on the web, even better when it’s interactive. However, depending on the complexity, achieving these effects can require a lot of time and experience. Unless, of course, you utilize tsParticles . This lightweight library helps you build stunning interactive animations with a few lines of code. It includes customization features that help you achieve animations far more advanced than just floating particles on the screen:

Hire with confidence.

See why engineering teams trust CoderPad to evaluate developers with realistic, AI-ready hiring workflows.

Request a demo