Pykonik #71: DB Schemas, multitenancy dead end and more!

Welcome to the next season of our community tech talk meetings!

We're back on Politechnika Krakowska, details how to get here are in the sidebar on the right, or in "Location" section below.

This month we're back with our "regular" formula with 2 longer talks with pizza break in-between and a lightning talks session at the very end.

Agenda:
18:30 – Welcome
18:30 – 🇬🇧 Piotr Piechnik - A dead end of Schema-based Multi-Tenancy DB in Django
19:15 – Networking break with Free Pizza
19:45 – 🇬🇧 Piotr Gnus - UUIDs Unleashed! Weird Adoption Journey & New Standards Promises
20:30 – Lightning talks
??:?? – The End & going to the after party

🇬🇧 A dead end of Schema-based Multi-Tenancy DB in Django - Piotr Piechnik
An exhilarating journey into the world of multi-tenancy databases and back, based on isolated client schemas in Django, where we unravel the intricacies and challenges of creating and managing complex, multi-user applications. This talk is a comprehensive case study that promises to immerse you in the practicalities and innovative strategies for mastering multi-tenant architectures. All of this would be present in a real-world case study where we have tried to squeeze everything we could from PostgreSQL with a separate schema approach, failed, and began a journey full of pitfalls and essential decisions. Suppose You would like to know a little bit more about our dead end aproach, and how to get back from it. Join me in this thrilling journey.

🇬🇧 UUIDs Unleashed! Weird Adoption Journey & New Standards Promises - Piotr Gnus
In this presentation, I'll guide you through all the types of UUIDs, incluiding some new ones an I'll present our journey towards migrating towards (ab)using them.
You will learn the origin of UUIDs, when to use them, which types to use in which situations and for sure how NOT to use them.
Additionally, I'll mention some upcoming changes in Python around them!

Lightning talks
There is no synopsis there, as there is no topic yet! Lightning talks are determined on the spot, during meeting! Each participant can ask for a mic and projector screen to present for 5 minutes any python related or completely unrelated topic! Just raise your hand when the announcer asks who wants to give a Lighning talk or approach one of the organizers during the meeting.

##### Szymon Cader - Jak zjeść ciastko i mieć ciastko – lokalny DevEx na serwerze

Każdy developer ma swój ulubiony zestaw narzędzi, języków, IDE, aliasów, czy pluginów – wszystko to tworzy developer experience (DevEx). Jednak te udogodnienia mają znaczenie głównie w lokalnym środowisku, a na serwerze rzeczywistość staje się znacznie bardziej surowa. W tym krótkim lightning talku postaram się pokazać jak możemy sobie usprawnić pracę z "produkcją" na przykładzie deploymentu z użyciem Docker'a.

Discord
Join our community and chat with us at https://discord.pykonik.org

If you'd like to speak at this or future Pykonik meetups, please send your proposal at https://pykonik.org/zgloszenie/

Location:
Politechnika Krakowska, Budynek Działownia (see the map; detailed instructions are visible when you sign up for the event)

If you have trouble figuring out how to find the correct room check out the video below:

https://www.youtube.com/shorts/XdS85XOlhdE

Sponsors and Partners

1. Splunk – Food & Beverages during the event
2. COSMO - Studenckie koło naukowe Politechniki Krakowskiej - space for the meetup
3. JetBrains – 2x pycharm licenses giveaway during the event
4. CLUG – recording and streaming of the meetup