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
Posted on: June 23, 2017 Concurrency. Parallelism. These terms get used a lot in development discussions, and especially in Elixir and Erlang circles. But what do they mean? Let's talk about them using burritos! The Burrito Shop 🌯🌯 Suppose I work at a burrito shop. Two customers come in, and each orders a burrito. How do I get the work done? Burrito Strategy 1: Serial To do the work serially, I'
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
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
処理を実行中です
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く