Counting objects in a collection

Counting objects in a collection

MongoDB: Here’s a small script to count some values ​​in a collection. What can’t you do with Python? I really like statistics, especially my own. For my MongoDB database, which I use to track more data on Spain than MariaDB, I’ve written a small script to collect a lot of average values. With 521 documents, it’s interesting to know these averages. Here is a screenshot with the current results: And here’s the script:

Vokabeltrainer / Vokabelbox Deutsch – Spanisch

Vokabeltrainer / Vokabelbox Deutsch – Spanisch

Ich nenne es Vokalbox. Die älteren werden noch die Karteikarte kennen. Klar, die ist es auch noch weiterhin im Handel und anscheinend ist sie noch gefragt. Aber was gibt es Besseres, als das auf dem PC zu haben? Natürlich gibt es gefühlt Vokalprogramme wie Sand am Meer und wahrscheinlich habe ich für mich die langweiligere Variante selber erstellt. Genau selber erstellt. Ich kann jetzt meinen Code beliebig verändern. Könnt ihr das mit den gekauften Programmen auch? Wahrscheinlich nicht, denn der…

Weiterlesen Weiterlesen

How to do some admin works with MariaDB and Python

How to do some admin works with MariaDB and Python

The challenge for every administrator, especially database administrators, naturally lies in keeping track of what their own system is doing. I’m not a database administrator, meaning I don’t work full-time in this field 40 hours a week. But even for the hobbyist database administrator using MariaDB, some of this information is quite useful. But I’ve been interested in databases for many years. I’m fascinated by data storage, because we encounter countless databases every day, even if we’re not aware of…

Weiterlesen Weiterlesen

To import a CSV file into a MariaDB database

To import a CSV file into a MariaDB database

Here is a little script to import a CSV file into a database. But it is not for a server. This is a standalone program. If you want to program it for a server, then you should use another method as with getpass, because getpass is waiting for an input. It is not useful, that you should enter every time a passport if you want to automate the process. If you downloaded a CSV file from the internet, and you…

Weiterlesen Weiterlesen

Read out the Gas level from a CSV file with Python Pandas

Read out the Gas level from a CSV file with Python Pandas

The fill level of Germany’s gas storage facilities is currently very low. Too low for the situation at the end of January 2026. These levels were actually expected to be reached by the end of March. Unfortunately, the German government’s website is very slow to update the fill levels of our gas storage facilities, even though they should be updated daily. I suspect the fax machines are malfunctioning again, or too many errors are being made between the tablet and…

Weiterlesen Weiterlesen