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


How to implement fast pagination? What is soft pagination and why is it needed? I will answer these and other questions in this series of articles about SQL.

SQL articles: fast pagination, soft deletion, etc.

SQL articles

PostgreSQL

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

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

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