Asynchronous code with PostgreSQL
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.
- 2018 October 9 15:50 SAST
- 40 min
- South Africa 2018