Kaarel Moppel - Senior Database Consultant at Cybertec Nordic
Speech: PostgreSQL - an Open Source database as a connector for traditional, NoSQL and IoT data steams
PostgreSQL - an Open Source database as a connector for traditional, NoSQL and IoT data streams PostgreSQL is an extremely mature RDBMS, with more than 20 years of global open-source development effort behind it. The question is how can one profit from that stability in today's world of Cloud, IoT and Big Data? How to tie the knots between all those different platforms and data formats with minimal effort? PostgreSQL has an answer for that - Foreign Data Wrappers, based on the SQL/MED standard. And the good news is that with 99% probability your data source X (traditional RDBMS, BigData or NoSQL solution) is already supported and ready for integration. Also software project maturity doesn't have to mean stagnation - PostgreSQL also has all the means for performing modern Data Analytics and Machine Learning there where the data lives - inside the database! This talk will give an overview on some typical data integration and analysis approaches using the PostgreSQL engine.