Shuffled Records in Phoenix
Posted on: 2017-12-12 I've written previously about a way to query for records in a shuffled order that works for pagination. The TL;DR was: use a shuffled (not random) ordering, based on a prime integer parameter. SELECT whatever FROM table ORDER BY large_integer_field % prime_integer_parameter -- modulo to shuffle LIMIT 10 OFFSET 0; Reuse the prime_integer_parameter with OFFSET 10 for subsequent
Protect Your Data with PostgreSQL Constraints
Posted on: 2016-01-08 What should validate your data - your application code, or your database? If you said "both", your answer is correct and you are entitled to feel smug for 1.5 seconds. And... stop. While application code can generally produce friendlier user errors, only the database knows what data it has right now - even if the application code ran a SELECT a few milliseconds ago, there may
1
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
処理を実行中です
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
