No More Raw SQL: SQLAlchemy, ORMs & asyncio [PyCon DE & PyData Berlin 2024]
🔊 Recorded at PyCon DE & PyData Berlin 2024, 22.04.2024
https://2024.pycon.de/program/EHJRVF/
🎓 Watch as Aya Elsayed and Rhythm Patel guide you through using SQLAlchemy, ORMs, and asyncio to simplify database management and enhance querying performance in Python projects!
Speakers:
Aya Elsayed, Rhythm Patel
Description:
Aya Elsayed and Rhythm Patel, both Software Engineers at Bloomberg, will be leading a workshop on "No More Raw SQL: SQLAlchemy, ORMs & asyncio." The workshop will focus on simplifying database management and data representation synchronization using SQLAlchemy, an SQL toolkit. Participants will learn how to use SQLAlchemy's Object Relational Mapper (ORM) system and asyncio extension to interact with databases asynchronously. The interactive tutorial will cover topics such as setting up SQLAlchemy, utilizing ORMs, improving performance with relationship-loading techniques, and using SQLAlchemy's asyncio extension. The workshop will provide hands-on experience through GitHub Codespaces, enabling participants to work on a repository with all necessary modules and a Dockerized PostgreSQL database. Python developers of all levels who work with databases and want to enhance their database interaction using SQLAlchemy are encouraged to attend. Basic knowledge of databases and SQL is recommended, while prior experience with SQLAlchemy or ORMs is not required. By the end of the workshop, participants will have a strong grasp of using SQLAlchemy for database operations, building ORM classes, optimizing querying performance, and leveraging asyncio for asynchronous database interactions.
⭐️ About PyCon DE & PyData Berlin:
The PyCon DE & PyData conference unite the Python, AI, and data science communities, offering a unique platform for collaboration and innovation. The PyCon DE & PyData Berlin 2024 conference, hosted in partnership with the local Berlin PyData chapter, provided an exceptional experience, fostering deeper connections within the Python community while showcasing advancements in AI and data science. Attendees enjoyed a diverse and engaging program, solidifying the event as a highlight for Python and AI enthusiasts nationwide.
Follow us:
• LinkedIn: / 28908640
• X: https://www.x.com/pyconde
• X: https://www.x.com/pydataberlin
Links:
• Conference website: http://pycon.de
• Related sessions: http://2024.pycon.de/program/categori...
The conference is organized by
• Python Softwareverband e.V.: http://pysv.org
• NumFOCUS Inc.: http://numfocus.org
• Pioneers Hub gemeinnützige GmbH: http://pioneershub.org
If you enjoyed this session, please like, comment, and subscribe to our channel for more insightful talks and discussions.
Share this video with your network to spread the knowledge!
Hashtags:
#Python #PyConDE #PyData #OpenSource #AI #DataScience #MachineLearning #SoftwareDevelopment #LLMs #Community
Acknowledgements:
Special thanks to all the volunteers and sponsors who made this event possible.
About:
Python Softwareverband e.V.:
PySV is a non-profit that promotes the use and development of Python in Germany through events, education, and advocacy, fostering an open Python community.
NumFOCUS Inc.
supports open-source scientific computing by providing financial and logistical support to key projects like NumPy and Jupyter, promoting sustainable development and collaboration.
Pioneers Hub gemeinnützige GmbH:
is a non-profit fostering innovation in AI and tech by connecting experts and promoting knowledge exchange through events and collaborative initiatives.