PyWeb-IL #109: September 2024 at Tenable in Tel Aviv

The PyWeb meeting of September will take place in the offices of Tenable in Tel Aviv. 94 Yigal Alon St., Alon Tower 2, floor 17

Agenda

• 18:00 Meeting and mingling
• 18:30 Daniel Balosh: From Sluggish to Speedy: A Developer's Guide to Taming MySQL Performance (40 min)

Based on internal presentation that can be seen here
Django, Flask, and other Python applications accessing MySQL need to prioritize performance to meet business and customer needs. When your MySQL database starts to drag, your users feel the pain. This talk will equip you with the essential tools and strategies to diagnose and tackle common MySQL performance bottlenecks.
We'll go beyond basic query optimization and explore how to analyze live data using powerful techniques like percentile metrics, slow query logs, and pattern matching. Discover common pitfalls like N+1 queries and excessive data retrieval, and learn practical solutions for optimizing your application's interaction with the database.
This session is packed with real-world examples and actionable advice tailored for Django, Flask, and other Python ORM users, empowering you to transform your MySQL database from a sluggish bottleneck to a performance powerhouse.
About Daniel:
I'm a software engineer with over 10 years of experience building reliable systems. I'm currently a Principal Engineer at the CISO office of Eleos Health, where I focus on using technology to improve security and risk management. I care about putting code into production and making a business impact. I believe in a pragmatic approach, starting with the business need, validating it with testing, and then developing a practical solution. You can find my professional background and experience on LinkedIn

• Break
• Lightning talks
• Alon Levy: Marimo - a new python notebook - Marimo is an open-source reactive notebook for Python — reproducible, git-friendly, executable as a script, and shareable as an app. I'll introduce Marimo from my own usage of it this last 3 months, and show how it can be used for data exploration. I'll show it's unique features resulting from its DAG nature. (10 min)
• Gal Goldner: DICOM (Digital Imaging and Communications in Medicine) standard, focusing on Python packages that are useful for working with the format and protocol, along with some examples. (10 min)
• Naum Raviz: A pagination that scales with your data (25 min)
• What is pagination and why?
• Offset-based Pagination.
• Cursor-based Pagination.
• The ideal solution for pagination

Naum Raviz is a Senior Software engineer at Tenable Attack Path Analysis.

• Going to a near-by pub to continue the conversation

##

If you'd like to give a presentation on this or a future meeting please open and issue.

For more details about the Python community in Israel.