10th January 2024

Database Schema Design – Complete Guide

Here are the key things to know about database schema design: Not all databases are equal. The design of a database schema influences how efficiently your database runs and how quickly you can retrieve information. However, designing a database schema is easier said than done. This article offers an overview of how database schema design works, as well as examples and best practices to help you optimize database schema design. What Is a Database Schema? Simply put, a database schema is a formal description of the structure or organization of a particular database (DB). The term database schema is most […]
16th September 2023

NestJS vs Go: Performance comparison for JWT verify and MySQL query

Introduction After publishing a record number of articles on comparing performance of various technologies like Node.js, Deno, Bun, Rust, Go, Spring, Python, etc. for a simple hello world case, I consistently got comments that the articles were good, but weren’t applicable directly for real-world use cases. I was asked to do the same for more ‘real-world’ cases. The articles also (and still) attracted a record number of views. However, the point was well taken. Hello world was the best starting point, but definitely not a ‘real-world’ case. Real-world use case This article is a part of the series where I’m […]
3rd January 2022

Tips-to-improve-mysql-query-performance

XpertLab – Mobile Application Development Company in Junagadh Here’s a quick and comprehensive look into how to improve mysql query performance in simple ways MySQL is the most sought-after open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). A poorly-crafted or disorganized SQL query acts as a potent killer of the overall performance of your application. Therefore, it is crucial to optimize your query performance. MySQL comes with tools that help us in the optimization of queries. Let’s dive into the essential and useful tips to improve MySQL Query for speed and performance. XpertLab – Mobile […]
25th May 2021

Object-Relational Mapping (ORM)

As a relative newcomer to the programming world, terms like Object-Relational-Mapper can sound really intimidating. The nice part about ORMs, is that they actually make it easier to write code once you get the hang of them (usually). In this post, I aim to explain what an ORM does, as well as the pros and cons of using them in your projects. Let’s get to it! What is an ORM? Before we talk about what an Object-Relational-Mapper is, it might be better to talk about Object-Relational-Mapping as a concept first. Unless you’ve worked exclusively with NoSQL databases, you’ve likely written your fair […]
31st October 2020

Improve MySQL Query Performance

MySQL is the most popular open-source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). A single poorly-designed SQL query will pose a significant threat to the overall performance of your application. Therefore, optimizing query performance is essential. MySQL comes with tools that help us in the optimization of queries. Let’s have a look at the most important and useful tips to improve MySQL Query for speed and performance. 1. Optimize Your Database You need to know how to design schemas to support efficient queries. Well-designed queries and schema are crucial for your application to work properly. Optimizing […]