Dealing with randomness in PostgreSQL can be tricky. Sometimes we get a little bit unpredictable results. Sometimes the distribution of the random numbers is not what we wanted. Sometimes things are slow.
Here I’m trying to describe common problems I met when using PostgreSQL and how they can be solved.
I started writing a chess engine. The longer I keep on writing it, the longer I see that it’s a never-ending story. There is always something, which should be improved. There is always something to make in a different way, but I’m not sure if it would be better or worse. And most of the good design decisions made at the beginning, don’t look so good later.
During the journey, I learned a lot and I hope to learn much more. This time I’m going to describe what I learned about bitboards.
An insurance company used to send me a paper letter (you know, the ancient way of communication) every year, right before the anniversary. Usually they offer some kind of change, like this:
Hey, we offer that you will pay x% more money from the next month,
in return we offer you x% more for the insurance amount.
And that’s perfectly fine. Really.
This year they sent me an email, with an attached PDF file. In the email they wrote:
We attached you the anniversary documents.
The files is protected with a password, which is the birth date of the insured personed, in the format of DDMMYYY.