Optimize Your Database Operations with Asynchronous Processing
Channel: PyCon South Africa
Date: 2021-10-23

By: Radical Rakhman Wahid

Event: PyConZA 2021
URL: https://2021.za.pycon.org/talks/35-optimize-your-database-operations-with-asynchronous-processing/

The bottleneck of a program can be caused by many reasons like bad data structure/logic/algorithm implementation, network connection, I/O bound operations, processor, etc. Database operations is kind of I/O bound operation which means, when it comes to the DB query program will waiting the result from another separate process. If the bottleneck is from the DB operations then you should try asynchronous processing :)

In Python, asynchronous support first introduced in version 3.4. Now the asynchronous Python is getting better by increasing third party packages. In this talk I'll cover the explanation about asynchronous DB operations in Python and then hands-off to show the results of using the asynchronous code compare with the synchronous one.

Postscript : Since I work day to day using the ORM (like SQLAlchemy) and PostgreSQL is our main DBMS (for product development), so the async in DB ops will be covered with SQLAlchemy and PsycoPG/AsyncPG as well.

Audience:

Anyone who work with database operations (data scientists, back-end engineers, students/researchers, etc.)

What will they get out of it:

- Clear concept and application of asynchronous DB operations that can be applied in production environment, as well.
- A modern way to optimize query DB time with a minimum resource.

Room: Video Room 1
Scheduled start: 2021-10-08 14:30:00
Sponsors:

  Gold:
    SPAN Digital: https://spandigital.com/
    Takealot: http://takealot.com/
    Andela: https://www.andela.com/

  Silver:
    Python Software Foundation: https://www.python.org/psf/membership
    OfferZen: https://www.offerzen.com/

  Patron:
    Thinkst Canary: https://canary.tools/
    Afrolabs: http://www.afrolabs.co.za/