Currently, the Abstractions II conference, which
starts next week, requires all attendees to wear a wristband with an RFID tag
in it for the duration of the conference, including in bed and in the bathroom.
The conference organizers, Code & Supply, have not
addressed the concerns I raised on their Slack, so I would like to publicly ask
them to reverse the continuous wear policy, and document how the RFID tracking
data will be handled. Please share this and
contact the organizers.
read more
From time to time I need to set up PostgreSQL on a Debian machine. It's fairly
straightforward, but I frequently need to look something up, so this time I am
writing down my notes.
Shortly after I published Benchmarking
UUIDs, Per Wigren emailed me
with a correction. It turns out the approach Jonathan and I used to time how
long PostgreSQL takes to generate a million UUIDs is mostly timing how long it
takes to generate a million queries:
UPDATE: The test methodology is flawed! PostgreSQL can be faster than nodejs.
See the follow-up article.
Jonathan New wrote an interesting article on UUID creation in Postgres vs
Node. In it, he described the
performance tradeoff of generating a
UUID in the
database vs in the application. It's not very …
In order to set a strong password for the PostgreSQL database I provisioned on
Amazon RDS, I looked up the limits. In my case, there are two sources of
constraints:
I am building a web application that delegates authentication to a third party.
Once the third party authenticates the user, the app create a session for the
user - and maybe create the user, too, if they don't already exist!
My first draft of this had all the SQL queries in …