Retrieving results from PostgreSQL database using pagination technique

Question

Retrieving results from PostgreSQL database using pagination technique

When I'm pagination querying my data from a PostgreSQL database, each request involves fetching the data in this manner:

let lastNArticles: Article[] = await Article.findAll({
                limit: +req.body.count * +req.body.page,
                order: [["created_at", "DESC"]],
                include: [
                    User,
                    {
                        model: ArticleOwnTags,
                        include: [ArticleTag],
                    },
                ],
            });

However, I am only interested in retrieving the last "req.body.count" fetched rows instead of all rows (count * page). Is there a way to configure PostgreSQL to fetch only the desired number of rows (+req.body.count - page size)?

javascript typescript postgresql express sequelize-typescript

Answer 1

Answer №1

If you encounter a limit offset issue while using PostgreSQL, you can address it with Sequelize by implementing the following code snippet:

let lastNArticles: Article[] = await Article.findAll({
                limit: +req.body.count,
                offset: +req.body.count * +req.body.page
                order: [["created_at", "DESC"]],
                include: [
                    User,
                    {
                        model: ArticleOwnTags,
                        include: [ArticleTag],
                    },
                ],
            });

Answer 2

If you encounter a limit offset issue while using PostgreSQL, you can address it with Sequelize by implementing the following code snippet:

let lastNArticles: Article[] = await Article.findAll({
                limit: +req.body.count,
                offset: +req.body.count * +req.body.page
                order: [["created_at", "DESC"]],
                include: [
                    User,
                    {
                        model: ArticleOwnTags,
                        include: [ArticleTag],
                    },
                ],
            });

Retrieving results from PostgreSQL database using pagination technique

Answer №1

Similar questions

Scrolling to an id element in Vue.js can be achieved by passing the ID in the URL using the "?" parameter. This

Troubleshooting: Why Won't My Basic JQuery POST Request Work?

Using jQuery to attach events and trigger them

Pause and be patient while in the function that delivers an observable

Ui-router experiencing issues with nested view loading due to changes in URL

With Ionic, you can use one single codebase for both iPad and iPhone

Modifying element size using jQuery causes issues with maintaining a 100% height

What could be the reason behind the undefined axios cookie issue?

The amazingly efficient Chrome quick find feature, accessible by pressing the powerful combination of Ctrl + F, ingeniously

There was an issue with Sails.js where it was unable to retrieve a recently created user using a date

Creating specialized paths for API - URL handlers to manage nested resources

Ways to collect particular tokens for delivering targeted push notifications to designated devices

Using ReactJS to insert an array of objects into an object nested within another array object

The value 'var(--header-position)' cannot be assigned to type 'Position or undefined'

Why does appending to a TextArea field fail in one scenario but succeed in another when using Javascript?

Troubleshooting Google Charts, AJAX, and PHP: Issue with JSON encoding leading to error message "Data for arrayToDataTable is not

"Having trouble with my Ajax Post - seeking an easy solution

Do I have to include 'document.ready()' for this JavaScript code snippet?

Should I generate an array or pull data directly from the database?

Issue: ENOENT - The requested file or directory cannot be found in the context of an Angular2 and Express.js