languageCode

searchTerm

blogQuery

blogSettings

BlogPostListPage_blogSettings

blogTags

BlogPostTagList_blogTags

BlogPostList_publishedBlogPosts

title

metaTitle

metaDescription

edges

first

publishedBlogPosts

pageInfo

query blogQuery(
  $languageCode: String!
  $searchTerm: String
) {
  blogSettings(languageCode: $languageCode) {
    ...BlogPostListPage_blogSettings
    id
  }
  blogTags(languageCode: $languageCode) {
    ...BlogPostTagList_blogTags
  }
  ...BlogPostList_publishedBlogPosts_38vwR
}

fragment BlogPostListItem_blogPost on BlogPost {
  id
  title
  summary
  urlSlug
  cover
}

fragment BlogPostListPage_blogSettings on BlogSettingsPayload {
  title
  metaTitle
  metaDescription
}

fragment BlogPostList_publishedBlogPosts_38vwR on Query {
  publishedBlogPosts(languageCode: $languageCode, searchTerm: $searchTerm, first: 60) {
    edges {
      node {
        id
        ...BlogPostListItem_blogPost
        __typename
      }
      cursor
    }
    pageInfo {
      endCursor
      hasNextPage
    }
  }
}

fragment BlogPostTagList_blogTags on BlogTagConnection {
  edges {
    node {
      id
      linkTitle
      urlSlug
    }
  }
}


PostgreSQL

In this blog, I tell you what problems I face and how I solve them in the process of developing web services and mobile applications for iOS and Android.

Blog about the development of web services and applications 👨‍💻

Unknown blog 👨‍💻

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

Comparing indexes for text search in PostgreSQL (part 2)

In this article, we will find out why LIMIT and OFFSET cannot be used to implement pagination and how to replace them.

Fast pagination in SQL

In this article, we will look at: what is soft deletion, why it is needed and how best to implement it.

Soft deletion

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

How best to store date ranges in PostgreSQL

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.

How to randomly select rows in SQL

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.

I will never use an ORM again

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

Migrations and declarative schema management

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?

How to get N rows per group in SQL

I this article, I'll describe how I've set up my own mail server using Postfix and Dovecot, added anti-spam protection using Rspamd, and set up SPF/DKIM/DMARC so that outgoing emails get into the inbox, not spam. As a result, you'll have your own mail

How to set up your own mail server (part 1)

Let's imagine, John has decided to write an email to Kate and tell her about his trip to the mountains. John goes to the computer and opens his favourite email client (Mail User Agent, MUA). The email client can be either a program installed on a

How does email work

In spite of Redis supports multiple databases, it's more convenient to run a separate instance of Redis for each database, so a database would have its own dump file and config. To archive that, you can run Redis either in different docker containers or

How to run multiple Redis instances

In the first part of this article we talked about the theory, how Postfix and Dovecot work. If you've missed it, I strongly recommend you to read it to understand the basics. Otherwise, if something won't work, you'll don't know how to fix it.

How to set up your own mail server (part 2)

When I saw an error returned by the Apollo GraphQL server for the first time I remember I thought: "What... is that?". Instead of a simple error object with a message and code, I saw something like this.

How to deal with GraphQL errors

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