Episode Details

Ryan Booz- Modern Databases - Episode 245

Episode 245 Published 2 years, 10 months ago

Description

Ryan is an Advocate at Redgate 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.

Topics of Discussion:

[1:23] Ryan's background and his love of helping people with their data.

[6:06] What are some features of Postgres that really intrigued Ryan?

[6:12] What are some of the choices in the database world that people should be well versed in?

[11:00] Is there a marketplace for these extensions?

[15:00] Google, Amazon, Microsoft, and many others have been very interested over the last 3‒4 years in the open-source code base.

[15:50] Is there any environment or platform where Postgres can't run?

[17:24] Can we use a downsized database engine?

[19:19] Ryan discusses Amazon Redshift.

[23:58] What's the state of the modern Redgate tools?

[26:42] What are the top three tools developers should reach for?

[27:00] What are the features of Flyway?