All about indexes by Louise Grandjonc & What the heck is SCRAM by Jonathan Katz


Louise Grandjonc will present "Postgres Index types and where to find them"

As developers we use indexes a lot, some by explicitly asking our ORM, some because of primary keys, unique constraint… But indexes go further than the default btree. And by the way, what is a btree? Louise is sharing a great talk about index types that postgreSQL has:
btree, gin, gist, sp-gist, brin, hash. What is the difference between them? What data type are they most fit for? How can they help with the performance of your application? How can you create a new index with a different type than the btree in python? All of these questions will be answered during this talk!

Louise is a software developer currently working at Microsoft in the Citus Data team. Before that I worked as a lead python developer at Ulule ( a crowdfunding company) for three years. I love writing SQL, python, data modeling and performance.

Additionally Jonathan Katz will present "Get Your Insecure PostgreSQL Passwords to SCRAM!"
Passwords: they just seem to work. You connect to your PostgreSQL database and you are prompted for your password. You type in the correct character combination, and presto! you're in, safe and sound.

But what if I told you that all was not as it seemed, and there was a better way to authenticate with passwords in PostgreSQL?

PostgreSQL 10 introduced SCRAM (Salted Challenge Response Authentication Mechanism), introduced in RFC 5802, as a way to securely authenticate passwords. In this talk, we will look at the history of password storage, the issues with the current methods, how SCRAM works and solves these issues, and how to upgrade!

At the end of this talk, you will understand how SCRAM works, how to ensure your PostgreSQL drivers supports it, how to upgrade your passwords to using SCRAM-SHA-256, and why you want to tell other PostgreSQL password mechanisms to SCRAM!

Jonathan S. Katz is the Director of Cloud Engineering & Growth at Crunchy Data, the leading provider of trusted open source PostgreSQL technology, support, and training. Jonathan is also responsible for advocacy efforts of the PostgreSQL Global Development Group and is a board member of the nonprofit United States PostgreSQL Association.

Prior to Crunchy Data, Jonathan was CTO at VenueBook, and before that, VP of Technology at Paperless Post. At both companies Jonathan developed robust platforms using PostgreSQL, taking advantage of its many features, from complex data types to its ability to stream logical changes. Jonathan graduated from Tufts University with a B.S. in Computer Science and a B.A. in Mathematics.


The agenda for the day will be:

6:00pm Networking and food
6:30pm Louise Grandjonc will present "Postgres Index types and where to find them"
7:00pm break and networking
7:30pm Jonathan Katz will present "Get Your Insecure PostgreSQL Passwords to SCRAM!"
8:00pm Networking and wrapup

Afterwards we will leave as a group and there is at least one organizer walking so anybody who prefers to walk in a group to the bus or metro will not have to walk alone.