Ryan is a Solutions Engineer at pganalyze focusing on PostgreSQL. Ryan has been working as a PostgreSQL advocate, developer, DBA and product manager for more than 20 years, primarily working with time-series data on PostgreSQL and the Microsoft Data Platform.

Ryan is a long-time DBA, starting with MySQL and Postgres in the late 90s. He spent more than 15 years working with SQL Server before returning to PostgreSQL full-time in 2018. He’s at the top of his game when he's learning something new about the data platform or teaching others about the technology he loves.

Presentations

23x

PostgreSQL Hands-On Training Day

A full PostgreSQL training day adjacent to the SCaLE LA event. 6 hours total, running for a full day as a single track (with 90 minute lunch break). Attendees can attend some or all of the event. Aimed both at new Postgres users and those migrating from other db systems. 

See Presentation
21x

Transforming Data with the Power of PostgreSQL and SQL

PostgreSQL has a plethora of features to help developers slice and dice massive amounts of data. In most cases, knowing how to use CTEs, recursive CTEs, and CROSS JOINs can significantly improve your data transformation tasks.

By the end of this session, you will understand how to approach data challenges differently, using the power of PostgreSQL and SQL to work more effectively.

See Presentation
20x

For Your Eyes Only: Roles, Privileges, and Security in PostgreSQL

Security is an essential, yet often misunderstood, part of effectively managing a PostgreSQL cluster. As the popularity and adoption of PostgreSQL continues to grow, the interaction of roles, privileges, and object ownership is a recurring theme of confusion in forums and mailing lists.

In this session we’ll demystify how ownership and permissions work in PostgreSQL so that you can more effectively manage your database landscape.

See Presentation
20x

We All Deserve Arrays: The Undervalued PostgreSQL Superpower

Arrays are an essential part of software development. Among modern databases, however, only PostgreSQL has dedicated datatypes, functions, and indexes built to efficiently work with arrays. In fact, I think arrays are a hidden superpower of PostgreSQL, fully utilized as a data type, usable in pl/pgSQL, and essential for a myriad of built-in functions to process data more efficiently.

Come learn about how powerful and useful arrays can be in your daily PostgreSQL development.

See Presentation