The Real Python Podcast

The Python Modulo Operator & Managing Data With SQLite and SQLAlchemy


Listen Later

Are you ready to move beyond flat files for your data in Python? Maybe you’re not sure where to start with databases and SQL. This week on the show, David Amos returns with another batch of PyCoder’s Weekly articles and projects. We cover a Real Python article about managing data with SQLite and SQLAlchemy.

David explores the intricacies of using the modulo operator (%). We also cover several other articles and projects from the Python community including, how to shoot yourself in the foot with python, exploring fractals on a cloud computer, the DMCA takedown request for youtube-dl, python for feature film, an online multiplayer text-based game framework, and a sorting algorithms visualizer.

Course Spotlight: Playing and Recording Sound in Python

In this course, you’ll learn about libraries that can be used for playing and recording sound in Python, such as PyAudio and python-sounddevice. You’ll also see code snippets for playing and recording sound files and arrays, as well as for converting between different sound file formats.

Topics:

  • 00:00:00 – Introduction
  • 00:01:35 – How to Shoot Yourself in the Foot With Python, Part 1
  • 00:11:31 – Data Management With Python, SQLite, and SQLAlchemy
  • 00:19:00 – Sponsor: Techmeme Ride Home Podcast
  • 00:19:29 – Exploring Fractals on a Cloud Computer
  • 00:23:28 – The youtube-dl GitHub Repo Has Received a DMCA Takedown Request From the RIAA
  • 00:29:09 – Video Course Spotlight
  • 00:30:12 – Python Modulo in Practice: How to Use the % Operator
  • 00:36:29 – Python For Feature Film
  • 00:44:01 – evennia: Online Multiplayer Text-Based Game Framework
  • 00:47:11 – Sorting-Algorithms-Visualizer: See How Sorting Algorithm Works With Pygame
  • 00:51:55 – Thanks and goodbye
  • Show Links:

    How to Shoot Yourself in the Foot With Python, Part 1 – If you’re new to Python, you might find yourself confused by some of the situations described in this article. Learn about five mistakes you could make, why they happen, and how to fix them.

    Data Management With Python, SQLite, and SQLAlchemy – In this tutorial, you’ll learn how to store and retrieve data using Python, SQLite, and SQLAlchemy as well as with flat files. Using SQLite with Python brings with it the additional benefit of accessing data with SQL. By adding SQLAlchemy, you can work with data in terms of objects and methods.

    Exploring Fractals on a Cloud Computer – Fractals might be some of the most interesting mathematical structures to study and to visualize. Learn what fractals are and how to create beautiful fractal animations with Python.

    The youtube-dl GitHub Repo Has Received a DMCA Takedown Request From the RIAA

    Python Modulo in Practice: How to Use the % Operator – In this tutorial, you’ll learn about the Python modulo operator (%). You’ll look at the mathematical concepts behind the modulo operation and how the modulo operator is used with Python’s numeric types. You’ll also see ways to use the modulo operator in your own code.

    Python For Feature Film – A look into how Python is used to bring your favorite movies to the big screen.

    Projects:

    • evennia: Online Multiplayer Text-Based Game Framework
    • Sorting-Algorithms-Visualizer: See How Sorting Algorithm Works With Pygame
    • Additional Links:

      • Python REST APIs and The Well-Grounded Python Developer: Doug Farrell Ep06:
      • Python REST APIs With Flask, Connexion, and SQLAlchemy: Real Python series
      • Python in Maya: Autodesk
      • Using Python - Maya: Autodesk Knowledge Network
      • Ineffective Sorts - xkcd comic
      • stacksort - StackSort connects to StackOverflow, searches for ‘sort a list’
      • Level up your Python skills with our expert-led courses:

        • Playing and Recording Sound in Python
        • Reading and Writing CSV Files
        • Editing Excel Spreadsheets in Python With openpyxl
        • 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

          136 ratings


          More shows like The Real Python Podcast

          View all
          Software Engineering Radio - the podcast for professional software developers by se-radio@computer.org

          Software Engineering Radio - the podcast for professional software developers

          272 Listeners

          The Changelog: Software Development, Open Source by Changelog Media

          The Changelog: Software Development, Open Source

          283 Listeners

          Thoughtworks Technology Podcast by Thoughtworks

          Thoughtworks Technology Podcast

          41 Listeners

          Talk Python To Me by Michael Kennedy

          Talk Python To Me

          592 Listeners

          Software Engineering Daily by Software Engineering Daily

          Software Engineering Daily

          624 Listeners

          Soft Skills Engineering by Jamison Dance and Dave Smith

          Soft Skills Engineering

          269 Listeners

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

          Super Data Science: ML & AI Podcast with Jon Krohn

          298 Listeners

          Python Bytes by Michael Kennedy and Brian Okken

          Python Bytes

          213 Listeners

          Data Engineering Podcast by Tobias Macey

          Data Engineering Podcast

          142 Listeners

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

          Syntax - Tasty Web Development Treats

          982 Listeners

          DataFramed by DataCamp

          DataFramed

          266 Listeners

          Kubernetes Podcast from Google by Abdel Sghiouar, Kaslin Fields

          Kubernetes Podcast from Google

          181 Listeners

          Practical AI by Practical AI LLC

          Practical AI

          190 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

          52 Listeners