Percona Community is a great place to share you database knowledge and expirience. In this summer I was lucky to participate in Percona Community Live 2022 and publish my two modest articles on Percona Community Blog.
I have spent a lot of time working with various database systems. I was a SQL and PL/SQL developer on big distributed teams, writing tons of nontrivial SQL queries and implementing tons of complex and tricky business logic on the database side. And I worked as a “classical” Java developer where we interacted with any databases through ORM, operating mostly JPA annotation and framework properties (hoping to find and turn on a “magic” parameter fast=true). ...
For many people, SQL is still a “low-level” computer language for data. It is considered an ancient and difficult to understand language, designed for special secret engineers with special secret skills. In this way, a mere mortal should not write SQL queries and should rely on special tools. And we are used to the fact that almost all ORM, DB managers, monitoring tools, and other DB tools generate tons of “tricky” queries against our data, turning SQL into dumb bytecode. And we can basically just observe this process and hope for the best. ...
SQL is Esperanto in the data world. But unlike “Lingwe Uniwersala” SQL became world-known and really common. Initially SQL was invented in 70 special for databases. Even then its creators aimed to create a simple and powerful data language for a wide range of users, with not only IT background, such as engineers, scientists, researchers, analytics, managers etc. SQL first of all was made by humans for humans, not for machines. ...