Durchsuchen nach
Kategorie: Datenbanken

Datenbanken wie MySQL und MongoDB kommen hier vor.

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

What you can animate with Python for your physics learning

What you can animate with Python for your physics learning

Here is the video to the is script here You want to see more? How to Run This Simulation To get the Stoppenberg (is the name of a quarter of the town in Essen here in the West-Germany – we have a lot of hills here) Physics Sim running on your local machine, follow these three simple steps: 1. Install the Prerequisites First, ensure you have Python installed. Then, open your terminal (Fedora) or Command Prompt (Windows) and install the…

Weiterlesen Weiterlesen