Calculation of a Triangle with two Unknowns with your Head and with Python

Calculation of a Triangle with two Unknowns with your Head and with Python

You have a triangle, where you only know one site and the angle. This problem comes during a test at the Tesla company of Elon Musk. This is only an example and this is nothing when you want to build a house. When you want to build a house, then you need one solution and not so many. The setup: The Mathematical Approach: We start with the Pythagorean theorem: a2 + b2 = c2 We have to subtract b2, then…

Weiterlesen Weiterlesen

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