Artwork

Content provided by Open Source Archives - Software Engineering Daily. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Open Source Archives - Software Engineering Daily or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.
Player FM - Podcast App
Go offline with the Player FM app!

Postgres Data Warehouse with Josh Drake and Thomas Richter

51:47
 
Share
 

Manage episode 286353713 series 1433319
Content provided by Open Source Archives - Software Engineering Daily. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Open Source Archives - Software Engineering Daily or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

A data warehouse is a centralized repository that an enterprise may use to store selected data from production systems. Data is transformed into a structured form that makes it easily accessible for business intelligence or other operational users. SQL-compliant databases are frequently used for data warehouses due to the popularity of SQL as a tool in business data analytics.

PostgreSQL is a free and open-source relational database management system. Postgres-based databases are widespread and are used by a variety of organizations, from Reddit to the International Space Station, and Postgres databases are a common offering from cloud providers such as AWS, Alibaba Cloud, and Heroku.

Josh Drake and Thomas Richter are experts on Postgres data warehousing. They join the show today to talk about the staying power of Postgres, why Postgres is a good choice for data warehousing, and how cloud technology is changing relational database management systems.

Sponsorship inquiries: sponsor@softwareengineeringdaily.com

The post Postgres Data Warehouse with Josh Drake and Thomas Richter appeared first on Software Engineering Daily.

  continue reading

143 episodes

Artwork
iconShare
 
Manage episode 286353713 series 1433319
Content provided by Open Source Archives - Software Engineering Daily. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Open Source Archives - Software Engineering Daily or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

A data warehouse is a centralized repository that an enterprise may use to store selected data from production systems. Data is transformed into a structured form that makes it easily accessible for business intelligence or other operational users. SQL-compliant databases are frequently used for data warehouses due to the popularity of SQL as a tool in business data analytics.

PostgreSQL is a free and open-source relational database management system. Postgres-based databases are widespread and are used by a variety of organizations, from Reddit to the International Space Station, and Postgres databases are a common offering from cloud providers such as AWS, Alibaba Cloud, and Heroku.

Josh Drake and Thomas Richter are experts on Postgres data warehousing. They join the show today to talk about the staying power of Postgres, why Postgres is a good choice for data warehousing, and how cloud technology is changing relational database management systems.

Sponsorship inquiries: sponsor@softwareengineeringdaily.com

The post Postgres Data Warehouse with Josh Drake and Thomas Richter appeared first on Software Engineering Daily.

  continue reading

143 episodes

All episodes

×
 
Loading …

Welcome to Player FM!

Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.

 

Quick Reference Guide