The Real Python Podcast

Type-Safe ORM With Prisma Client & Real Python at PyCon US 2022


Listen Later

Are you using an Object-Relational Mapper (ORM) for your Python projects? What if it could work with SQL or No-SQL databases and be fully type-safe? This week on the show, Robert Craigie talks about Prisma Client Python.

Prisma Client Python is built on top of Prisma, which was created for TypeScript and Node.js. It uses a schema file to declare your application’s data models and relationships in a human-readable form. The schema file allows you to easily switch the database type.

Prisma Client is different from other Python ORMs. It is fully type-safe and can be used with or without async.

We talk about how Robert started the project and what types of challenges he’s faced. He also shares areas of improvement and how to contribute to the project.

We also have a conversation with several Real Python core team members about PyCon US 2022. We will have a booth at the conference where we hope you’ll come and connect with us. The team also shares what to expect from PyCon and what they’re excited about this year.

Course Spotlight: Python REST APIs With FastAPI

In this course, you’ll learn the main concepts of FastAPI and how to use it to quickly create web APIs that implement best practices by default. By the end of it, you will be able to start creating production-ready web APIs.

Topics:

  • 00:00:00 – Introduction
  • 00:02:15 – Have you worked on other open-source projects?
  • 00:02:59 – What is Prisma?
  • 00:05:00 – What are advantages of using an ORM?
  • 00:06:52 – What problem is Prisma Client solving?
  • 00:08:43 – What was involved in porting the project over?
  • 00:09:55 – Creating a Prisma schema
  • 00:12:09 – Other challenges along the way
  • 00:14:57 – Dangers of not having type safety
  • 00:16:27 – Sponsor: Linear B
  • 00:17:06 – How long have you been working on the project?
  • 00:18:57 – How could someone contribute to the project?
  • 00:21:03 – In what situations does Prisma Client excel?
  • 00:24:21 – What other projects do you currently work on?
  • 00:24:57 – What are you excited about in the world of Python?
  • 00:28:01 – What do you want to learn next?
  • 00:29:52 – Thanks and Goodbye
  • 00:30:14 – Introduction of RP team
  • 00:31:09 – What are we doing at PyCon 2022?
  • 00:35:55 – How to Get the Most Out of PyCon US
  • 00:37:42 – Tutorials at PyCon US 2022
  • 00:40:24 – Video Course Spotlight
  • 00:41:49 – Talks at PyCon US 2022
  • 00:50:16 – Sprints at PyCon US 2022
  • 00:54:38 – Final thoughts
  • 00:57:30 – Thanks and goodbyes
  • Show Links:

    • Prisma Client Python
    • Prisma schema (Reference) | Prisma Docs
    • TypeScript: JavaScript With Syntax For Types.
    • pyright: Static type checker for Python
    • pyright-python: Python command line wrapper for pyright, a static type checker
    • Pylance - Visual Studio Marketplace
    • MkDocs
    • Rust Programming Language
    • prisma-client-py: An auto-generated and fully type-safe database client built for autocomplete
    • Prisma Python Discord server
    • PyCon 2022 Welcome to PyCon US 2022
    • How to Get the Most Out of PyCon US – Real Python
    • KiwiPyCon - New Zealand Python User Group
    • EuroSciPy
    • PyColorado 2019
    • Level up your Python skills with our expert-led courses:

      • Python REST APIs With FastAPI
      • Building a Django User Management System
      • Exploring Basic Data Types in Python
      • Support the podcast & join our community of Pythonistas

        ...more
        View all episodesView all episodes
        Download on the App Store

        The Real Python PodcastBy Real Python

        • 4.7
        • 4.7
        • 4.7
        • 4.7
        • 4.7

        4.7

        139 ratings


        More shows like The Real Python Podcast

        View all
        Software Engineering Radio by se-radio@computer.org

        Software Engineering Radio

        271 Listeners

        The Changelog: Software Development, Open Source by Changelog Media

        The Changelog: Software Development, Open Source

        289 Listeners

        Software Engineering Daily by Software Engineering Daily

        Software Engineering Daily

        624 Listeners

        Talk Python To Me by Michael Kennedy

        Talk Python To Me

        585 Listeners

        Soft Skills Engineering by Jamison Dance and Dave Smith

        Soft Skills Engineering

        288 Listeners

        Super Data Science: ML & AI Podcast with Jon Krohn by Jon Krohn

        Super Data Science: ML & AI Podcast with Jon Krohn

        302 Listeners

        Python Bytes by Michael Kennedy and Brian Okken

        Python Bytes

        215 Listeners

        Syntax - Tasty Web Development Treats by Wes Bos & Scott Tolinski - Full Stack JavaScript Web Developers

        Syntax - Tasty Web Development Treats

        987 Listeners

        REWORK by 37signals

        REWORK

        210 Listeners

        CoRecursive: Coding Stories by Adam Gordon Bell - Software Developer

        CoRecursive: Coding Stories

        190 Listeners

        DataFramed by DataCamp

        DataFramed

        269 Listeners

        Practical AI by Practical AI LLC

        Practical AI

        210 Listeners

        AWS Podcast by Amazon Web Services

        AWS Podcast

        203 Listeners

        The Stack Overflow Podcast by The Stack Overflow Podcast

        The Stack Overflow Podcast

        64 Listeners

        The Pragmatic Engineer by Gergely Orosz

        The Pragmatic Engineer

        64 Listeners