Latest by topics

Trending Articles

Development

Advanced Stored Procedures In MySQL

In our previous article , we learned the basics of stored procedures and how they can help you manage your MySQL database efficiently. In this guide, we’ll dive deeper and discuss more advanced stored procedures concepts and techniques. By the end of this article, you’d have learned some skills that will make you more proficient in working with stored procedures in MySQL. Stored procedures share many similarities with functions in procedural languages such as JavaScript, Python, etc. They are used to group and execute many tasks in one call. They can be called and executed repeatedly using loops. They can also be nested in one another and executed in parent-stored procedures. You can also nest MySQL functions in stored procedures and more!

Announcements

The 2022 CoderPad Year in Review

As 2022 comes to a close, we’re reflecting on the feature updates and major releases that have helped our users improve their interview process. Here at CoderPad, we were busy! 2022 saw the release of major features (have you seen our multi-file environments yet?) and product updates. Here are the top 10 features we were most excited about this year: 1. Multi-file environments In CoderPad’s new multi-file environments, users now have the ability to spin up full applications and get more creative with interview questions.

Coding Challenges

Code Challenge: Brainfuck Interpreter

Brainfuck is a very simple programming language with only eight instructions. Despite its simplicity, it’s actually Turing-complete! This language doesn’t use any variables: it works with a large array of bytes as its memory, initialized with all zeros. The interpreter also has a pointer that indicates the current memory location. The pointer can be moved left and right, and all operations on memory are performed on the currently pointed cell.

Development

A Guide To Using React’s useMemo Hook

React is one of the most used JavaScript libraries, and it is used for building fast and interactive user interfaces. But at times, implementing certain functions, fetching massive data from external sources, and lots more make it difficult for your React applications to run fast, thereby reducing performance. In this guide, you will learn what the useMemo hook means, how you can use it to optimize your React applications, and when you should use it. You will also get to know other options you can use in other situations, so you don’t use the useMemo hook when you should not.

Development

MySQL JOIN Clause: A Detailed Guide

MySQL joins undoubtedly belongs to the list of database techniques everyone should know. After all, a common need when using a relational database is to combine data from more than one table, creating a cohesive result. In today’s post, we’ll cover the JOIN clause in MySQL. Requirements We’ll start the post by covering what joins are in MySQL, and then we’ll quickly move on to the practical part. To follow along with that second part, you’ll need the following:

Development

How To Write Integration Tests With Jest And React Testing Library

When you build applications or websites as a developer, your primary goal is to ensure it works. To ensure it works, you test your application by checking if it works as expected, but we often perform this testing manually, which is referred to as manual testing. In this article, you will learn what testing means, the various types of testing, why you need to test, how testing works in React, what integration testing means, and how to write an integration test with the React testing library.

Development

Svelte Vs. React: Which Is Better?

As a front-end developer, you might ask yourself what framework would be the best to use in a project. Should you go with React? Is Svelte a more beginner-friendly choice? Last year, React was recognized as the most popular front-end framework. However, React had some limitations, so an equally good alternative, Svelte, is also broadly popular in the developer community. In this post, we’ll compare React and Svelte according to some key factors. By the end of this post, you should be able to make a clear decision as to which library is best for your project.

Development

An Introduction To Stored Procedures In MySQL

Many relational database management systems today can use stored procedures to execute tasks on the database. Stored procedures can be extremely useful in improving the efficiency of your database, saving you time, money, and lots of work-related headaches. So let’s dive into exactly how they can help you. What is a stored procedure? A stored procedure is a precompiled set of one or more SQL statements stored in a relational database management system that can be reused and shared by multiple programs for the purpose of executing tasks on the database.

Development

How to Configure Different Load Balancing Algorithms on Nginx

Low latency, high uptime, and good performance are required in today’s world of keeping users engaged with your application. During times of high traffic, the overall performance of most web applications drops, the latency rises, and sometimes the request times out. This often happens when the server computing power is not enough to process the workload during this period of high traffic. As a prerequisite, you only need a good understanding of basic web terminology like HTTP, servers, requests etc. We’ll start with learning about NGINX as a load balancer and the different load-balancing algorithms. From there, you will learn how to configure the different algorithms to best fit your particular use case, and the pros and cons of load balancing.

Hire with confidence.

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

Request a demo