I will never use an ORM again
At first, it seemed to me that ORM speeds up the development process by allowing you to work with the database as entities. However, over time, problems begin to arise that you didn't think about it at the beginning.
At first, it seemed to me that ORM speeds up the development process by allowing you to work with the database as entities. However, over time, problems begin to arise that you didn't think about it at the beginning.
When you develop some project alone, usually during development process there are no questions about how to manage the database schema. If you need to add a new column to a table, you can just do it in your local database without any consequnsces. Maybe...
Let's assume that you are developing the home page in an online store. This page should display product categories with 10 products in each. How do you make a query to the database? What indexes do you need to create to speed up query execution?
In some cases, it is necessary to store a range of dates in the database (for example, hotel room reservations, calendar events). Subsequently, it is usually required to find records in the database whose date range intersects with the specified one. For...
There are several ways to get random rows from a table. In this article, we will compare the most popular methods, understand their pros and cons and determine in which cases which method is better to use.
In this article, we will look at: what is soft deletion, why it is needed and how best to implement it.
In this article, we will find out why LIMIT and OFFSET cannot be used to implement pagination and how to replace them.
In the first part of the article, we looked at how text search is performed using trigrams (pg_trgm) and full-text search, and decided that we would compare the following indexes to speed up the...
During the development of my web application, I needed to add the ability to search for different entities (companies, messages, documents, etc.). Each entity has its own string length to be searched for. For example, a company has a short name (20-40...