Presented by:

E2abad4afadef2f07c59febe4bc68274

Christo Goosen

OWASP Cape Town

CTO in a insuretech company by day, OWASP CPT Chapter leader at night. Currently studying towards a Msc in Infosec at Rhodes. Loves postgres, python, reactive programming, async programming, systems, security, beer, meetups and conferences.

Postgresql is loved for its performance, features and robustness. A database done right only works right when accessing it in a performant way. In large, distributed cloud systems postgresql can run like a cheetah, but trying to hold onto its tail is your hippo of a application.

Libraries like https://github.com/MagicStack/asyncpg allow connections with via highspeed event loops rather than multiple churning threads.

The following talk will discuss a couple of libraries in different languages, but primarily will focus on python3.5>3.6 and the asyncpg library running on the uvloop event loop.

This talk aims to show how application code can get the most out of a postgresql instance/cluster once the operations team has done their best to make the cheetah run at its best.

Date:
2018 October 9 15:50
Duration:
40 min
Room:
Cedarwood
Conference:
South Africa 2018
Language:
English
Track:
Development
Difficulty:
Medium