pagination of the blog posts

[amrutadotorg]

Hi, thank you for the outstanding project. Unfortunately, my SQL skills are very limited right now, which is why I need help.

I'm trying to figure out how to use the steps component to paginate the posts (using the example modeling a many-to-many relationship with a form), but I can't figure it out. Any help would be greatly appreciated.
In my case post.id is not in order.

SELECT * FROM sqlpage_shell LIMIT 1;

SELECT 'list' AS component,
    COALESCE(
        (SELECT name FROM topic WHERE id = CAST($topic AS INTEGER)),
        'Recent blog posts'
    ) AS title;


SELECT 
    post.title AS title,
    'post.sql?id=' || post.id AS link,
    'Published on ' || created_at AS description,
    CASE
        WHEN created_at > (current_timestamp - interval '2 days') THEN 'red'
        ELSE NULL
    END AS color,
    topic.icon AS icon,
    created_at > (current_timestamp - interval '2 days') AS active
FROM post
    LEFT JOIN topic ON topic.id = post.main_topic_id
WHERE $topic IS NULL
    OR topic.id = CAST($topic AS INTEGER)
    OR EXISTS (
        SELECT 1
        FROM topic_post
        WHERE topic_post.topic_id = CAST($topic AS INTEGER)
            AND topic_post.post_id = post.id
    )
ORDER BY created_at DESC;

SELECT 'text' AS component;
SELECT 'No blog post yet. ' AS contents WHERE NOT EXISTS (SELECT 1 FROM post);
SELECT 'Write a post !' AS contents, 'write.sql' AS link;

[lovasoa]

Hello ! You should have a look at this forum entry: #39 and this open issue: #84, with examples. Don't hesitate to ask there if there is something that is not clear.