it's not about being the best it's about being better than yesterday
PostgreSQL is a popular relational database system, frequently used in applications. While working with PostgreSQL, you may come across the error message, “ERROR: prepared statement ‘S_1’ already exists.” This error occurs when you attempt to prepare a statement with the same name as an existing prepared statement in the current session. One effective solution to…
gRPC is a powerful framework for defining and using services that run over HTTP/2. It’s particularly efficient for low-latency, high-throughput applications. Over time, as you develop gRPC-based systems, you might encounter the need to deprecate certain parts of your API, such as services, methods, fields, or even entire messages. Deprecation is crucial when you need…
In the world of containerization, Docker has become the industry standard for packaging applications and their dependencies. One critical aspect of configuring your Dockerized application is managing environment variables. In this blog, we will explore different methods to pass environment variables to Docker containers. Different Ways to Pass Environment Variables 1. Dockerfile ENV Instruction In…
Docker has become an essential tool for packaging and distributing applications. It provides a consistent environment for your applications to run in, ensuring they work the same way on your development machine, testing servers, and production servers. Micronaut, a lightweight Java framework, pairs beautifully with Docker to create portable and efficient microservices. In this blog,…
Distributed Denial of Service (DDoS) attacks can wreak havoc on web applications, causing server overload and unavailability. As a Ruby on Rails developer, you can bolster your application’s defenses against such attacks using the Rack::Attack gem. In this blog, we’ll explore what DDoS attacks are, why Rack::Attack is a vital tool, and how to implement…
One of the most common performance bottlenecks in Ruby on Rails applications is the N+1 query problem. This issue occurs when your application makes multiple unnecessary database queries when a more efficient approach could be used. Bullet is a gem that helps identify and address N+1 query problems in your Rails application. What is the…
If you are using Rails, chances are you must be using ActiveRecord extensively. Let’s explore how Active record internally creates queries. How SQL query is created in Active Record? In Active Record, the sql statement generation is handled by Arel, All the commands written in active record is passed to Arel, Arel constructs the query…
When designing a database in Postgres, one of the crucial decisions to make is choosing the primary key for your tables. Traditionally, many developers use serial (auto-incrementing integers) as primary keys. However, there’s an increasing trend in using universally unique identifiers (UUIDs) as primary keys. Each approach has its pros and cons, and in this…
When it comes to building robust and scalable applications, developers have a multitude of choices in the world of Java-based frameworks. Two popular options that often come up in this discussion are Micronaut and Spring Boot. Both of these frameworks are designed to simplify the development process and provide a range of features for building…
When it comes to handling data in MySQL, the SUBSTRING_INDEX function is a powerful tool you should have in your toolkit. It allows you to extract parts of a string based on a delimiter, a task often encountered when working with text data. In this brief blog, we’ll explore the wonders of SUBSTRING_INDEX and how…