DEV LOG: It's all Fauna and Games Until Someone Wants to Paginate
Fauna is a database solution for a serverless first, Cloudflare Worker world.
Unfortunately, this entails new challenges that traditional databases stored on a single disk in Mom’s basement don’t suffer from.
Pulling all monthly active users from a Fauna Collection:
Create an index on top of the correct collection
Filter out only the relevant fields and leave search terms empty or the entire index will only return `n = 1` items
When referencing that index, `Match()` on every item (SELECT *, sorta)
Wrap that in a `Paginate()` (??)
Paginate has a hard cap at 10,000
The filtered fields lose their key and are stored in a flattened array. Remember the order in which keys were added to the Index, no take backsies!
I got roasted and toasted on HN for yesterday’s dev log. I could jump to my own defense, but as Ira Glass said, kill your darlings (or perhaps it was Mark Twain?). They can’t all be winners. Don’t get attached to stranger’s opinions on the internet, as a general rule.
What matters isn’t what a person has or doesn’t have; it is what he or she is afraid of losing…
Because, to repeat, life is sacrifice and risk taking, and nothing that doesn’t entail some moderate amount of the former, under the constraint of satisfying the latter, is close to what we can call life.
If you do not undertake a risk of real harm, reparable or even potentially irreparable, from an adventure, it is not an adventure.
There are twelve pairs of ribs, all of which articulate with the vertebral column, while only the first seven ribs directly articulate with the sternum.
The 1st rib is the shortest, widest and has the sharpest curve of all the ribs.
ars longa, vita brevis