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 …