Database focused 154th DevClub.lv

Hi!

Databases are everywhere — but understanding how they really work is what separates good systems from great ones.

Join us at the next DevClub.lv meetup for an evening dedicated to modern database engineering. Learn how to read PostgreSQL execution plans, discover what's new in MySQL 9.7, and see real-world MySQL corruption troubleshooting and recovery techniques from production environments.

You are welcome to Database focused event on June 18, 18:30, at Accenture office – 214 Brīvības gatve.

Agenda for "Database" focused 154th DevClub.lv:

from will give a talk "MySQL Corruptions Troubleshooting: Case Studies".
This presentation is intended for beginners.

After years of work, every IT professional gains their own unique experience that can help them in the future.
Good old common sense, based on human intellect and time-proven methods, will save your time in the age of AI-driven technologies.
Using real-life cases, I will show how basic troubleshooting methods can save your time and how to avoid common pitfalls when unplanned issues arise.
Some corruption recovery techniques will be learned as well.
Case 1: Ubuntu + Zabbix upgrade failed due to problems with MySQL database. Logical data corruption while no issues with software upgrade .
Case 2: Zabbix MySQL database corruptions recovery after storage hardware issues.

(Language - Latvian)

Andrey Chervonets is DBA with 25+ years experience of supporting information systems based on Oracle products and technologies. He is Oracle Database OCP/OCE, Oracle AS/WebLogic OCP, IBM DB2 Certified Database Administrator.

will give a talk "EXPLAIN: make it make sense"

Most developers know how to measure the time a database query takes and to find which one is the slowest. But what next? What is going on there? Is it good that it’s doing that? Is the query supposed to take this much time? Will some indexes help? In this talk, I will help you decipher database query plans and give some rules of thumb to understand if the database is doing the best it can. We will also use query plans to find the best indexes for queries by observing what the database is looking for. I will also share several anti-patterns I have seen in projects and show how to rewrite them in a database-friendly way. Although I will use Python to explain the principles and execute my queries, I will show the raw SQL to make it applicable to any programming language.

(Language- English)

Tags: SQL, PostgreSQL, Explain plan, Python

Aivars Kalvāns is a FinTech developer, software architect, and consultant. He spent more than 18 years developing and architecting payment card software for acquiring and issuing, as well as for accounting and utility payments, through mobile phones, ATMs, and POS terminals. At the moment, he is a contractor exploring Foreign Exchange, SWIFT, SEPA, ledgers, and other areas of the FinTech landscape.

from will give a talk titled “The Next Chapter of MySQL: What’s new in Versions 9.7”

Scott Stroz will deliver his speech ONLINE.

MySQL 9.7 LTS marks a major milestone for MySQL Community Edition, delivering expanded capabilities across observability, high availability, application development, and query performance. In this session, Scott explores the Community Edition features introduced in MySQL 9.7 LTS and what they mean for teams building and operating MySQL-backed systems. You will learn how new replication and Group Replication observability features provide better insight into lag, flow control, cluster health, and failover behavior; how OpenTelemetry support helps integrate MySQL into modern monitoring pipelines; how JSON Duality Views continue to evolve for application architectures; and how the Hypergraph Optimizer broadens access to advanced query planning in Community Edition.

This is not a product pitch. It is a practical look at what is now available in MySQL Community Edition, why these features matter, and how they can help teams build, scale, monitor, and optimize MySQL-backed applications with more confidence.

(Language - English)

Scott Stroz is a Developer Advocate for MySQL and has been a full-stack developer for longer than the term "full-stack developer" has been around. In that time, MySQL was the only constant in his development stack. He is passionate about sharing what he has learned on his coding journey so others may learn from his mistakes.

Videos from previous events you can find at our homepage and our YouTube channel. The best way to be informed about new videos is to Subscribe to our YouTube channel.

If you have any challenge where you are looking for external help, remember - can help you find world-class trainers and consultants almost for any need people in software development could have. Contact us to get to know more!

Com Tec Co (CTCo) is a global digital services provider with 600+ experts driving digital transformation across industries.
We’d love to connect with tech professionals who are passionate about innovation and growth:

– Full-Stack developer
– Java developer
–

At Dativa, we deliver secure and scalable IT solutions trusted by governments and enterprises, backed by deep expertise in custom software and e-services development. Join us!

Trading since 2017, Gravity Team is one of the leading crypto market makers and liquidity providers, with cumulative trading volumes to date in excess of $400 billion. Join our community of innovators, problem solvers and owners who apply scientific discovery techniques to make crypto markets a better place for everyone.

- AI Platform Architect

Levelpath is on a bold mission to revolutionize procurement software—and make it delightful. Founded in 2022, we’re a AI-powered platform tackling real challenges in the $11.5B (and growing) market. Our engineering team builds cutting-edge solutions that unify workflows, data, and automation for a seamless business experience. Backed by top Silicon Valley VCs and a proven founding team, we’re hiring developers who thrive on solving hard problems and pushing boundaries to transform the enterprise.

– Senior Security Engineer

GoCardless is a global fintech building the world's bank payment network, processing over US$130B annually for 100,000+ businesses. Our teams also use AI and open banking to increase payment success and reduce fraud, creating complex engineering challenges at a massive scale. We’re solving problems that affect how money moves globally. Join us to build the future of payments!

– Data Analyst II
– Software Development Engineer - Payment Intelligence team
- Ruby Software Development Engineer

Thanks to our sponsors for supporting DevClub.lv events: