Latest by topics

Trending Articles

Development

How to Interact with Databases using SQLAlchemy with PostgreSQL

Databases can be accessed in Python through a database connector where you can write SQL queries as you do in a SQL client. Writing these queries can be complex and error-prone–especially when you are using a language like Python where all data you deal with are objects or relations between objects . Writing queries just like you write objects makes connecting to databases really easy. You can do that by using an ORM (Object Relational Mapping) tool like SQLAlchemy ORM. SQLAlchemy is a Python toolkit and ORM that helps you write SQL in a flexible way. One way to do so is to write SQL in an object-oriented paradigm.

Development

A Thorough Guide To JavaScript Array Methods with Examples

The array data type is one of JavaScript’s most important data types because it stores different elements (with different data types) in a single variable. For example, when dealing with large amounts of data such as the JSON fake posts API , you frequently need to include a variety of data types such as objects, strings, integers, and many others. These values are typically stored in an array for manipulation and consumption in your application.

Interviewing

2 Top-Shelf Interview Questions to Ask Your Senior Front-End Engineering Candidates

Senior software engineers don’t come cheap. With the average compensation for this level of developer averaging about $167,000 , making the wrong hire could be terrible news for your hiring budget – not to mention your team’s productivity and morale. The skills needed to become a senior front-end engineer are not trivial. There’s a reason they can command such high salaries, and can be so hard to find these days. That’s why making sure you ask the right questions in a technical interview is so important.

Development

Why & How to Use Window Functions to Aggregate Data in Postgres

A window function is a feature developed in PostgreSQL — available since version 8.4 — to analyze data beyond the current row (hence the term “window”). These windows can aggregate information to each row of your output. Apart from aggregate functions and groupings, window functions provide another way to perform calculations based on the values of several records. Using window functions removes the hassle of using subqueries and JOINS to aggregate neighboring rows that can be related to the current row.

Development

Guide to Classes and Object-Oriented Programming in Python

Object-oriented programming (OOP) is a popular programming paradigm for writing software. Before the development of object-oriented programming, procedural programming was an efficient way of building or writing software. In procedural programming, programs are divided into interdependent functions, which is a straightforward process. However, due to the interdependence of functions, a change in one function can break several other functions.

Development

Guide to Sorting in JavaScript

Like sorting your laundry? Or cleaning up a Lego spill into neat color-coded piles? Yeah, me neither. Because of its repetitive nature, sorting can be a bit of a chore at times. Unfortunately, sorting is as necessary for programming as it is in our daily lives. Fortunately for us, however, it’s much easier to do as a JavaScript developer than it is in other areas of our lives. In this guide, we’ll look at: Organize your data using the JavaScript sort method

Development

How to Use innerHTML in JavaScript, Plus Alternate Methods

If you’re creating any dynamic web page these days, making sure you have relevant and up-to-date information is vital. Whether it’s showing stock quotes, the current time, the user’s name, or any other piece of info that changes with time or user, you’ll want to make sure you’re regularly updating this dynamic content to produce the best experience for your users. Luckily for you, we can associate these dynamic pieces of information with HTML elements and easily display their current state using the innerHTML property.

Announcements

CoderPad Reloaded

We’re thrilled to launch the latest version of our CoderPad Live interviews! Frameworks launches this week with five of the most popular front-end frameworks: This is an important step in the evolution of technical interviews. We see interviewing as an authentic evaluation of the skills someone actually needs to thrive in the job. Frameworks make it even easier to achieve this. We believe technical interviews should be both collaborative and realistic. A good interview experience empowers candidates to show off their day-to-day skills and also to discover what it’s like to work at your company.

Development

How to Optimize MySQL Database Schema for Improved Performance

According to the TIOBE index, MySQL is listed among the top databases used in developing APIs for web and mobile applications. The performance and user experience of your app depend on the performance of your database. That is why database engineers and web developers are often required to know how to tune a database for optimal performance. When tuning a slow database, we usually begin by optimizing the queries we write . But another way you can speed up your database is by optimizing your schema.

Hire with confidence.

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

Request a demo