languageCode

searchTerm

urlSlug

IdTagQuery

blogTag

BlogPostListTagPage_blogTag

blogTags

BlogPostTagList_blogTags

tagUrlSlug

BlogPostList_publishedBlogPosts

title

metaTitle

metaDescription

edges

first

publishedBlogPosts

pageInfo

query IdTagQuery(
  $languageCode: String!
  $urlSlug: String!
  $searchTerm: String
) {
  blogTag(languageCode: $languageCode, urlSlug: $urlSlug) {
    ...BlogPostListTagPage_blogTag
    id
  }
  blogTags(languageCode: $languageCode) {
    ...BlogPostTagList_blogTags
  }
  ...BlogPostList_publishedBlogPosts_4dD70X
}

fragment BlogPostListItem_blogPost on BlogPost {
  id
  title
  summary
  urlSlug
  cover
}

fragment BlogPostListTagPage_blogTag on BlogTag {
  id
  title
  metaTitle
  metaDescription
}

fragment BlogPostList_publishedBlogPosts_4dD70X on Query {
  publishedBlogPosts(languageCode: $languageCode, tagUrlSlug: $urlSlug, 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

What indexes in PostgreSQL can be used for text search? What are trigrams and how to use them? I will answer these and other questions in this series of articles about PostgreSQL.

PostgreSQL articles: comparing indexes for text search, etc.

PostgreSQL articles

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 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

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

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

Comparing indexes for text search in PostgreSQL (part 1)