Useful in a project that uses all of:

• SWR for data fetching
• NextJS
• Ant Design tables
• Kysely with Postgres Sorting, Filtering and Pagination in the database
• s (snak was already claimed on NPM)

• Wraps Ant Design Table
• Gets page, filters and sorting from URL query
• Sets page, filters and sorting on URL query when changed by user
• Updates columns to reflect current filtering and sorting
• Fetches data, passing page, filters and sorting
• Adds pagination options, including total count from data
• Shows Loading state

An SQL snippet to add to a select so we get the total number of results the query would return if not paginated. This does add a performance hit.

database.selectFrom("table").select(totalCount)...

Adds totalCount and applies LIMIT and OFFSET to query

query = database.selectFrom("table")...
return paginate(query)

Iterates over sorter (from AntDesign Table) yielding [column, order]

for (const sort of iterateSorter(sorter)) {
  const [column, direction] = sort
  switch (column) {
    case "date":
      query = query.orderBy("createdAt", direction)
      break
    case "name":
      query = query.orderBy("firstName", direction).orderBy("lastName", direction)
  }
}

TODO

• Move ErrorLoding in here