In the second edition of ProLinks you can lear about PostgreSQL optimisation, A/B testing, discussion about death and much more. Enjoy!
IT
10 Cool SQL Optimisations That do not Depend on the Cost Model – Today, we don’t want to talk about cost based optimisation, i.e. optimisations that depend on a database’s cost model. We’ll look into much simpler optimisations that can be implemented purely based on meta data (e.g. constraints) and the query itself.
What Comes after Microservices?
A tour of Postgres Index Types – Postgres has a number of index types, and with each new release seems to come with another new index type. Each of these indexes can be useful, but which one to use depends on 1. the data type and then sometimes 2.
Why are most A/B test results a lie? – In a report on A/B testing Martin Goodson at Qubit suggests that “most A/B winning test results are illusory”. Andre Morys at Web Arts goes even further and argues that “90% of test results are a lie.”
The Art of the User Interview – Everything you need to know about conducting useful user interviews.
What Is a Product Manager, Actually? – In many ways, the role of a Product Manager remains an enigma. Many companies have only begun inserting the role into their organizations in recent years, and very few companies incorporate the role correctly.
SSH escape sequences – Did you know that when you’re using OpenSSH from the command line you have a variety of escape sequences available to you?
WTF is a Thread
Dynamic Programming: First Principles – Dynamic Programming is a mathematical tool for finding the optimal algorithm of a problem, often employed in the realms of computer science.
Kotlin programmer dictionary: Function vs Method vs Procedure – Function and method are two commonly confused words. While every method is a function, not every function is a method. There is also another word that is erroneously used interchangeably: a procedure. Let’s discuss differences between all of this terms.
Politics
Is the World Returning to the Dark Ages? | Salman Rushdie
Lifestyle
Men, you want to treat women better? Here’s a list to start with – Hey men, what are you planning to do better? Because you need to do better. Here are ideas on how you should treat women better.
How I Socially Engineer Myself Into High Security Facilities – A pentester shares a story that shows how social engineering can get you anywhere.
Serialized Television Has Become a Disease – Instantly, something in me rebelled. “But ‘City on the Edge of Forever’ is perfect the way it is!” I thought. “City of the Edge of Forever” is rightly considered a classic: an episode where an out of his mind McCoy travels back in time and saves a woman’s life.
Science
Simpson’s Paradox
Miscellaneous
New Rule: ShitStarters | Real Time with Bill Maher (HBO)
Why Die?