Name: PyWeb-IL #109: September 2024 at Tenable in Tel Aviv
Start: 2024-09-03T18:00:00+03:00
End: 2024-09-03T20:00:00+03:00
Location: Tenable

The PyWeb meeting of September will take place in the offices of [Tenable](https://www.tenable.com/) in Tel Aviv. 94 Yigal Alon St., Alon Tower 2, floor 17

Agenda

* 18:00 Meeting and mingling
* 18:30 [Daniel Balosh](https://www.linkedin.com/in/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](https://drive.google.com/file/d/1uUkZ6r1QeOkRVjalKs8FHM3Esj1dDsR6/view)
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](https://www.linkedin.com/in/daniel-balosh)

* Break
* Lightning talks
* [Alon Levy](https://gitlab.com/aleflamed): Marimo - a new python notebook - [Marimo](https://marimo.io/) 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](https://www.linkedin.com/in/gal-goldner-761570228/): 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](https://www.linkedin.com/in/naum-ravitz-917b90160/): 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](https://gitlab.com/hamakor/python.org.il/).

For more details about the [Python community in Israel](https://python.org.il/).

Gabor Szabo

PyWeb-IL 🐍

Technology

Python

Django

Web Development

Python Web Development

Linux

Open Source Python

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

Tenable

Share

PyWeb-IL 🐍

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

PyWeb-IL 🐍

Details

Members are also interested in