Infinum Server-Side Talks #1

Join us at our very first Server-side talks where we will explore and uncover all the mysticism that’s contained within backend systems, servers, databases, advanced API’s and much more.
This month we’ll dive into security issues and advanced database topics. Our first talk will be covered by Stef who will reveal a couple of his secrets that he’s keeping in his vault.
Pero will tell us how he used his advanced SQL skills and dropped a 17-second query to a negligible 170ms.

Hiding Secrets in a Vault
Stjepan Hadjić, Infinum
Most applications use third-party services. Access to those services are possible through some secrets and keys. Let's store those secrets in a Vault instead of hard coding them in our software. Vault is a free product made by HashiCorp that makes it easy to store, read and share your secrets with other members of your team and machines. It stores already encrypted data, it has many different ways to authenticate including GitHub and on top of it all, it logs everything.

Advanced SQL functions explained
Petar Ćurković, Infinum
Getting data from our SQL databases is not always a trivial task - standard aggregate functions, groupings and joins sometimes are not good enough. And not so rarely we struggle with performance issues.
To make our job easier when we do complex calculations and to accomplish better performance of our queries, we will go through some advanced SQL mechanisms like WINDOW and ARRAY functions and operators, as well as materialized VIEWs.