--- title: "Development | CoderPad" description: "CoderPad articles filed under Development." canonical: "https://coderpad.io/blog/development/page/6/" --- Insights & Resources # Build better engineering teams Explore insights on technical hiring, AI readiness, developer skills, and product updates from the team behind CoderPad. Latest by topics - [All](https://coderpad.io/blog/) - [Announcements](https://coderpad.io/blog/announcements/) - [Coding Challenges](https://coderpad.io/blog/coding-challenges/) - [Community](https://coderpad.io/blog/community/) - [Data Science](https://coderpad.io/blog/data-science/) - [Development](https://coderpad.io/blog/development/) - [Engineering Management](https://coderpad.io/blog/engineering-management/) - [Events](https://coderpad.io/blog/events/) - [Getting Hired](https://coderpad.io/blog/getting-hired/) - [Hiring Developers](https://coderpad.io/blog/hiring-developers/) - [Interviewing](https://coderpad.io/blog/interviewing/) - [Product Updates](https://coderpad.io/blog/product-updates/) ## Development Articles Search articles Search articles [](https://coderpad.io/blog/development/understanding-transactions-in-sqlalchemy/) [Development](https://coderpad.io/blog/development/) ### [Understanding Transactions in SQLAlchemy](https://coderpad.io/blog/development/understanding-transactions-in-sqlalchemy/) Database transaction in SQLAlchemy follows the rule of ACID in relational databases. This tutorial shows how to understand transactions in a practical application. You’re going to learn why SQLAlchemy transactions matter in building applications like getting orders from an inventory. You can use your own IDE and dependencies to try things out, and as always, this tutorial will use the already prepared environment, CoderPad sandbox , which has all that you need from the dependencies in this application. [](https://coderpad.io/blog/development/how-to-animate-a-react-application-with-framer-motion/) [Development](https://coderpad.io/blog/development/) ### [How to Animate A React Application With Framer Motion](https://coderpad.io/blog/development/how-to-animate-a-react-application-with-framer-motion/) Animations on web pages involve moving elements on the screen to improve the visual experience of users. These animations are visually appealing and tend to draw users’ attention to buttons, images, and other important information. Overall, it contributes to establishing a solid connection between users and the content on the screen. In the past, web pages were very plain and lacked interactivity because they were only intended to display information, and there was no capability to create appealing visual experiences. Things have changed dramatically in recent years, thanks to the availability of libraries and packages that make it easier to animate and add visual experiences to your web pages. [](https://coderpad.io/blog/development/sql-functions-and-techniques-every-data-person-should-know/) [Development](https://coderpad.io/blog/development/) ### [SQL Functions and Techniques Every Data Person Should Know](https://coderpad.io/blog/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. [](https://coderpad.io/blog/development/how-to-use-indexes-to-increase-mysql-database-performance/) [Development](https://coderpad.io/blog/development/) ### [How to Use Indexes to Increase MySQL Database Performance](https://coderpad.io/blog/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. [](https://coderpad.io/blog/development/how-to-implement-infinite-scroll-in-react-js/) [Development](https://coderpad.io/blog/development/) ### [How to Implement Infinite Scroll in React.js by Building a TikTok Clone](https://coderpad.io/blog/development/how-to-implement-infinite-scroll-in-react-js/) 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. [](https://coderpad.io/blog/engineering-management/the-environmental-impact-of-digital-technology-and-how-software-eco-design-can-help/) [Development](https://coderpad.io/blog/development/) ### [The Environmental Impact of Digital Technology and How Software Eco-Design Can Help](https://coderpad.io/blog/engineering-management/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: [](https://coderpad.io/blog/development/4-ways-to-use-javascript-slice-method/) [Development](https://coderpad.io/blog/development/) ### [4 Ways to Use JavaScript .slice() Method and How to Do Each](https://coderpad.io/blog/development/4-ways-to-use-javascript-slice-method/) 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.![ℹ️](https://coderpad.io/assets/emoji/2139.svg) 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: [](https://coderpad.io/blog/development/rules-of-react-hooks/) [Development](https://coderpad.io/blog/development/) ### [Rules of React Hooks](https://coderpad.io/blog/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. [](https://coderpad.io/blog/development/redux-vs-recoil/) [Development](https://coderpad.io/blog/development/) ### [Redux vs Recoil – Comparing Two React State Libraries](https://coderpad.io/blog/development/redux-vs-recoil/) 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. Currently on page 6 of / 12 [Next Page](https://coderpad.io/blog/development/page/7/) [Previous Page](https://coderpad.io/blog/development/page/5/) ## Hire with confidence. See why engineering teams trust CoderPad to evaluate developers with realistic, AI-ready hiring workflows. [Request a demo](https://coderpad.io/sales/)