Haki Benita

In the talk I want to present a few lesser know, but useful features you may never heard about! For example, do you know how you can get the number of inserted and update rows in an upsert? how to create reproducible random data for testing and demonstrations? match a text against multiple patterns without complicated condition? How about using \copy with multi-line queries? All that and more... in my talk :)

In this talk I'll present lesser known features in PostgreSQL such as:

• How you can get the number of inserted and update rows in an upsert
• How to create reproducible random data for testing and demonstration
• How to match a text against multiple patterns without complicated condition
• How to use \copy with multi-line queries
• And many more fun features from the deep end of the documentation!

Concurrency in web applications is so easy to get wrong, and so hard to identify and debug when it comes to bite you. In this talk I'm going to present common concurrency issues with even the simplest application, and suggest ways to identify and prevent them!

In this talk I'll present common issues, and different approaches for dealing with concurrency:

• Why it is better to ask for forgiveness instead of permission when dealing with concurrency
• What is the TOCTOU (time-of-check-time-of-use) problem, how it can happen and how to address it
• How database locking can help with concurrency, and how to avoid it!
• How and when to rely on database features to maintain correctness

Mypy has been around since 2012, and in recent years its gaining wide spread adoption. As the framework continues to evolve and improve, more and more useful features are being added. In this talk I'm presenting some hidden gems in the type system you can use to make your code better and safer!

The Mypy typing system, and the complementary extensions module, includes some powerful but lesser known features such immutable types and exhaustiveness checking. Using these advanced features, developers can declare more accurate types, get better warnings, produce better code and be more productive.

Databases are the backbone of most modern systems, and taking some time to understand how they work is a good investment for any developer! In this article I share some non-trivial tips about database development!

Rules of thumb has been passed on from DBA to DBA for many years. Some of these rules may seem weird while others makes perfect sense. In this talk I present some of the "rules" I accumulated over the years, such as why you should always load sorted data into tables, how to make indexes invisible, and why you should always schedule long running processes in odd hours...