PyCon Pune 2018

PyCon Pune

Best of friends : Python & Postgres

Submitted by Priya Ranjan (@ranjanprj) on Friday, 15 September 2017

Technical level: Intermediate

Abstract

There are lot of synergies between Python and Postgres, that they feel like they are long time friends and not just acquaintance. For example Python’s framework such as Django has first class support for Postgres on the flip side, You can build Postgres extensions in Python. This enables you to have Python both front and at the back of a powerful database, Postgresql. Understanding these synergies, in these two formidable open source project would help developers leverage some of the awesome powers of these two platforms. My intent is to showcase these synergies and spark new ideas of building software and API with Python and Postgres

Outline

  1. Showcase various synergies between Python and Postgres in terms of integration, opensource, community etc.
  2. How to leverage front end frameworks such as Django support for Postgresql.
  3. How to extend Postgresql using Python to query Twitter, Web etc as database table.
  4. How to build real time apps leveraging Postgresql Listen/Notify and Python ayncio to develop websocket notification on database update.
  5. Talk about other possiblity like doing DataScience using Python embedded inside Postgresql.

Requirements

A Postgresql 9.6 Database and Python 3.x installed on linux.

Speaker bio

My name is Priya Ranjan, I live in Pune. I have 10+ years of experience working in enterprise of various sizes. I have been using Python and Postgres independently but 2 years back started to discover how both projects can leverage each other to do awesome things that could take a long time in any other environment.

Links

Slides

https://docs.google.com/presentation/d/1rOkJ_xHBxEC6_46OXpVusy0txzvGio0XGcCNqvGcoT4/edit?usp=sharing

Comments

  • Kushal Das (@kushaldas) Reviewer 2 years ago

    Thank you for submitting the talk to PyCon Pune. The talk selection team will contact you here in case of any queries. Meanwhile, please make sure that you provide a link to the presentation slides.

  • Parag Nemade (@paragan) a year ago

    Can you please provide updated slides as per given outline of this talk? Are you going to show some examples for the topics given in the outline of this talk?

Login with Twitter or Google to leave a comment