Slide 16
Slide 16 text
Queryによる取得(PartiQL)
SELECT
*
FROM
timeline
WHERE
user_id = 12345
ORDER BY
sort DESC
LIMIT 40;
SELECT
*
FROM
timeline
WHERE
user_id = 12345 AND
sort < “xxxxx_yyyy”
ORDER BY
sort DESC
LIMIT 40;
SELECT
*
FROM
timeline
WHERE
user_id = 12345 AND
BEGINS_WITH(
sort, “20210501”
)
ORDER BY
sort DESC
LIMIT 40;
最新の40件取得
特定のキーより前の
40件取得 (ページング等) 特定の日付の40件取得