PostgreSQL Landscape of Bol.com & Real-time Analytics at Any Scale

Hi all,

Proud to introduce you the last "PostgreSQL User Group NL" meeting of 2018.

Once again, we have found a number of interesting topics to increase your PostgreSQL knowledge while enjoying a drink. Do not miss this!

Because of the success we had the previous time, we will continue our “lightning talks”. A lightning talk is a very short presentation lasting only a few minutes. Everybody has the opportunity to take the stage for a few minutes and talk about a particular subject that he/she wants to share or even want some input on from the group. You can reserve your slot for a lightning talk by sending us a mail or write your name down on the day of the Meetup itself.

This Meetup will be held at the office of Bol.com. Food and drinks are for free. Thanks to Bol.com for their hospitality.

Let’s meet and shake hands!

Coen Hamers ( Splendid Data)
Gerard Zuidweg (OptimaData)
Feike Steenbergen (Adyen)

*************

Our Agenda:

17:30 - 18:30 Arrive, food and drinks

18:30 - 18:35 Welcome Gerard & Coen

18:35 - 19:20
HOSTING POSTGRESQL DATABASE IN THE CLOUD
By: Jing Rao - Database Engineer Bol.com

At Bol.com the whole IT landscape is moving towards cloud. To be able to provide PostgreSQL database for applications running in the cloud, and at the same time customize the database setup according to IT security and business requirements that we have at Bol.com, we started a project to create our home-made solution of hosting PostgreSQL database in the cloud. This solution is build based on Google Kubernetes Engine. We have combined 2 open source project "Crunchydata" and "Pghoard" with our own automation to provide PostgreSQL database as service for the development teams. In this talk I would like to share information and our experience on this project.”

19:30 – 20:15
REAL-TIME ANALITYCS ON POSTGRESQL AT ANY SCALE
By: Marco Slot - Software Imagineer Citus Data

Building a dashboard that provides real-time insights into a large data stream is a challenging problem. The database needs to support high ingest rates, handle low latency (subsecond) analytical queries from many concurrent users, and reflect new data as soon as possible, while keeping data over long periods. This talk will discuss how you can build a scalable real-time analytics pipeline using PostgreSQL with extensions such as HLL and pg_partman, and how you can scale out across many servers using Citus.

20:15 – 20:30
Lightning Talks

20.30– 21.00
Wrap up and get together with refreshments