Skip to main content

Subscribe to Newsletter

ProLinks #2



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?


Comments

Subscribe to Newsletter

Popular posts from this blog

ProLinks #57 - Truth, Wayland and Sex Tapes

Tech Let's talk about Wayland ... This is the fundamental principle of every single product (including security products). If you cannot use a thing, because its "safety" or "security" mechanisms prevents the core functionality from being utilized in the intended fashion, the product is useless. For example, a Web browser without an Internet connection is possibly very secure from Internet exploits - but it also doesn't do its main function - let people browse the Internet Speed is the killer feature When you touched a Razr or a Palm phone, there was a delay. It felt sluggish and slow. Apple removed the delay between your finger tapping the screen and something happening. Your finger could finally manipulate the UI in realtime, just like in the real world. It felt magical. If there was even a slight delay, the whole experience fell apart. Everything is broken, and it’s okay Every car you’ve ever ridden in, every elevator you’ve ever taken, every s

Learning sources for IT Consultant

I went into IT consulting. And as with everything that I start anew, I have tried to find some good learning materials and sources to get me started. But it got really difficult really quickly. As I found out, there are not many materials and sources focused specifically on this topic. This got me thinking. How is this possible? There are tons of materials for business consulting, so how come there are almost non for IT? So I thought about it. And than it hit me. There are lots of materials for IT consultant. They are just not named as such.  First of all, IT consultancy is pretty broad topic so it depends on what are you consulting. Is it software development? Is it security? Is it biometrics systems? Based on the topic you are consulting you can find needed domain knowledge. You can be brilliant programmer, but if you have no idea about given domain, you will be no help to your client. Secondly, consultancy is the same when it comes to soft skills regardless if you a

ProLinks #59 - Terrible men, Facebook and SOCOM

Tech You’re Doing It Wrong: Notes on Criticism and Technology Hype What is less obvious is why Shoshana Zuboff, an emerita professor of Harvard Business School, so uncritically repeats the digital industry’s marketing materials, nor why she never points to or assesses evidence that goes against her argument. Yet her writings are full of hyperbole that sounds like she took press releases from Facebook’s and Google’s PR departments and rewrote them to be alarming, How Facebook got addicted to spreading misinformation Zuckerberg’s obsession with getting the whole world to use Facebook had found a powerful new weapon. Teams had previously used design tactics, like experimenting with the content and frequency of notifications, to try to hook users more effectively. Their goal, among other things, was to increase a metric called L6/7, the fraction of people who logged in to Facebook six of the previous seven days. L6/7 is just one of myriad ways in which Facebook has measured “e

ProLinks #58 - Evangelicals, Screen time and BASE Jumping

Tech The technical interview practice gap, and how it keeps underrepresented groups out of software engineering MIT gave me was a big stamp on my forehead that, to this day, makes strangers think I’m smart. But there was another, more relevant gift that gave me a serious advantage over students who did not attend an elite computer science institution: boundless access to technical interview practice. Not only was there a multi-week course during the month-long break between Fall and Spring semesters that was dedicated exclusively to passing technical interviews, but all of my peers were going through exactly the same thing at the same time Clone Wars - Open source clones of popular sites 70+ open-source clones of popular sites like Airbnb, Amazon, Instagram, Netflix, Tiktok, Spotify, Trello, Whatsapp, Youtube, etc. List contains source code, demo links, tech stack, and, GitHub stars count. Great for learning purpose!  “Well, it seems great to me” But if your music, your graphic

ProLinks #65 - North Korea, Cryptocurrencies, Propaganda and more

Tech The Incredible Rise of North Korea’s Hacking Army He was right. As the newspapers soon reported, more than sixteen million dollars was withdrawn from roughly seventeen hundred 7-Eleven A.T.M.s across Japan that morning, using data stolen from South Africa’s Standard Bank. The newspapers surmised that 7-Elevens had been targeted because they were the only convenience stores in Japan whose cash terminals all accepted foreign cards. Soon after the raids, the withdrawal limit for many A.T.M.s in the country was reduced to fifty thousand yen Why Cryptocurrency Is A Giant Fraud ❧ Current Affairs Schweikert is partly right: “selling it as a revolution” is a hugely important part of why cryptocurrency is succeeding. But as is generally the case when someone is trying to sell you something, the whole thing should seem extremely fishy. In fact, much of the cryptocurrency pitch is worse than fishy. It’s downright fraudulent, promising people benefits that they will not get and trying