Road sign with a limit of 30, to represent the limit of results in a MySQL subquery when using the eloquent ORM
Limit MySQL subquery results inside a WHERE IN clause, using Laravel’s Eloquent ORM

Limit MySQL subquery results inside a WHERE IN clause, using Laravel’s Eloquent ORM

Comments 0 Comment

MySQL sub querying capability is a great tool that can be used to create very powerful and readable queries. In some cases, it can also provide big performance boosts if used correctly. By default, MySQL doesn’t allow us to add a limit clause in our subqueries, when using specific clauses like WHERE IN. Nevertheless, we can easily override this limitation by wrapping our subquery inside another query. In this tutorial, we are going to explain how to limit subquery results…

Read More Read More

A person looking at signs showing where to go, very confused like if they were using sticky sessions as their routing policy
Why you should never use sticky sessions

Why you should never use sticky sessions

Comments 0 Comment

Sticky sessions grant the ability to route incoming requests to a specific server, based on their session identifier. We usually find them in applications that keep their state in a non-sharable service. An example is keeping state in memory or the server’s hard disk. In this article, we will discuss what sticky sessions are. We will also explain why they are “bad”, and how to design an application so we can fully avoid them.

Better sprint planning article main image
5 tips to improve your sprint planning process

5 tips to improve your sprint planning process

Comments 2 comments

It’s Monday. The meeting room’s screen is already on, showing the backlog of your company. A distinctive smell of coffee pervades the entire office. The scrum master and the product owner are already in place. They call in the tech team so they can finally start the weekly sprint planning.

NodeJS logging tutorial header image
NodeJS logging, from beginner to expert.

NodeJS logging, from beginner to expert.

Comments 3 comments

In this tutorial, we will discuss how to correctly perform logging on NodeJS. We will start from simple console logs, moving to more advanced features, one step at a time. At the end of this read, you will be able to create a custom logger using the Winston npm library and add transports where logs will be streamed. You will also learn how to add some advanced features, like request tracking and how to implement extra safety precautions that will…

Read More Read More

A graphic of an open vault inside a room, with the door vault looking like a window
How to securely store JWT tokens.

How to securely store JWT tokens.

Comments 8 comments

In the last years, JWT tokens are widely used as an authentication and authorization method for web applications. They allow backend developers to authenticate users, without making a single query to the database server or any other type of storage. They are super easy to use and they also use the most common format currently used for data on the Internet, JSON.