In my previous post, I wrote about the quick way to generate Excel export from the database using Python. This was a simple report, but in fact, I had to…
Month: December 2021
If you are thinking of a quick way to prepare an Excel report from the data you have in your database, you can use Python. In order to achieve this,…
This issue is related to MySQL (I’m using mysql-connector-python). Surprisingly, when I was changed my query to a stored procedure, my code stopped working. It looked like this: And it…
I’m working on the old code right now and I try to perform some performance adjustments. The majority of work now relies on the identification of weak points and places…
Why such a code? I’m displaying the history of the database record – in a table, each row is a separate record of the history. The highest row contains current…