mastodon.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
The original server operated by the Mastodon gGmbH non-profit

Administered by:

Server stats:

341K
active users

#mariadb

9 posts9 participants0 posts today
ax6761<p><span class="h-card" translate="no"><a href="https://fosstodon.org/@my_actual_brain" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>my_actual_brain</span></a></span> If you use <a href="https://freeradical.zone/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a> (at least since v10), try your best to run it in the strictest possible configuration, in order for it not have "0" dates; to fail on too-short of space instead of truncating a value; &amp; to avoid other assorted foot-guns.</p>
arosano 🇩🇰🇮🇱<p>Does anyone here run <a href="https://mastodon.bsd.cafe/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mariadb</span></a> on <a href="https://mastodon.bsd.cafe/tags/NetBSD" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NetBSD</span></a>? I have a question.</p>
Alejandro Duarte<p>📦 Time to update your package.json: <a href="https://mastodon.online/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a> Connector/Node.js 3.4.1 released:</p><p> ✅ ? works with namedPlaceholders<br> ✅ Bulk insert IDs returned (11.5.1+)<br> ✅ Zero-config SSL for Parsec auth</p><p>See the full list of issues fixed at <a href="https://mariadb.com/kb/en/mariadb-connector-node-js-3-4-1-release-notes/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">mariadb.com/kb/en/mariadb-conn</span><span class="invisible">ector-node-js-3-4-1-release-notes/</span></a></p><p><a href="https://mastodon.online/tags/NodeJS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NodeJS</span></a></p>
Topslakr<p>New House Projects – Weather Watching V0.5</p><p>I've always been fascinated with the weather. I can still remember the daily routine of charting the weather in kindergarten with meticulous scientific rigor: Each morning one pupil, on a rotation, would peer out a window and then mark down if it was sunny, or cloudy, or possibly raining...</p><p><a href="https://topslakr.com/2025/04/new-house-projects-weather-watching-v0-5/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">topslakr.com/2025/04/new-house</span><span class="invisible">-projects-weather-watching-v0-5/</span></a></p><p><a href="https://fosstodon.org/tags/Topslakr" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Topslakr</span></a> <a href="https://fosstodon.org/tags/Weather" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Weather</span></a> <a href="https://fosstodon.org/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a> <a href="https://fosstodon.org/tags/Weather" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Weather</span></a> <a href="https://fosstodon.org/tags/WeeWx" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>WeeWx</span></a> <a href="https://fosstodon.org/tags/Vermont" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Vermont</span></a></p>
Upscene Productions<p>Video: Adding a foreign key constraint to an existing <a href="https://mstdn.business/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLite</span></a> table using Database Workbench.</p><p><a href="https://www.youtube.com/watch?v=ZnFf4sj8jro" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">youtube.com/watch?v=ZnFf4sj8jr</span><span class="invisible">o</span></a></p><p><a href="https://mstdn.business/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a><br><a href="https://mstdn.business/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a><br><a href="https://mstdn.business/tags/SQLServer" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLServer</span></a><br><a href="https://mstdn.business/tags/Oracle" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Oracle</span></a><br><a href="https://mstdn.business/tags/Firebird" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Firebird</span></a><br><a href="https://mstdn.business/tags/InterBase" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>InterBase</span></a><br><a href="https://mstdn.business/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a><br><a href="https://mstdn.business/tags/NexusDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NexusDB</span></a><br><a href="https://mstdn.business/tags/databasetools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>databasetools</span></a> <a href="https://mstdn.business/tags/databasedevelopment" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>databasedevelopment</span></a> <a href="https://mstdn.business/tags/DatabaseWorkbench" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseWorkbench</span></a></p>
Gytis Repečka<p>Hands down the best April Fool's day prank :ablobcatrave:</p><p>New statement to <a href="https://comfy.social/notes/a614sx4f76" rel="nofollow noopener" target="_blank">end transaction in MariaDB</a> - <code>amen</code> :blobcatcheer:</p><p>Beautifully <a href="https://github.com/MariaDB/server/pull/3937" rel="nofollow noopener" target="_blank">crafted</a> by <span class="h-card"><a href="https://comfy.social/@sigmasternchen" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>sigmasternchen</span></a></span> :sql:</p><p><a href="https://social.gyt.is/tags/databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>databases</span></a> <a href="https://social.gyt.is/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mariadb</span></a> <a href="https://social.gyt.is/tags/commit" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>commit</span></a> <a href="https://social.gyt.is/tags/aprilfoolsjoke" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>aprilfoolsjoke</span></a></p>
Rad Web Hosting<p>How to Install <a href="https://mastodon.social/tags/AbuseIO" class="mention hashtag" rel="tag">#<span>AbuseIO</span></a> on a <a href="https://mastodon.social/tags/Debian" class="mention hashtag" rel="tag">#<span>Debian</span></a> <a href="https://mastodon.social/tags/VPS" class="mention hashtag" rel="tag">#<span>VPS</span></a> (5 Minute Quick-Start Guide) This article provides a detailed guide on how to install AbuseIO on a Debian VPS server.<br />What is AbuseIO?<br />AbuseIO is an open-source abuse management platform designed to help network operators, hosting providers, and ISPs efficiently process and respond to abuse reports. It automates the collection, categorization, and handling of abuse complaints ...<br />Continued 👉 <a href="https://blog.radwebhosting.com/how-to-install-abuseio-on-a-debian-vps/?utm_source=mastodon&amp;utm_medium=social&amp;utm_campaign=ReviveOldPost" target="_blank" rel="nofollow noopener" translate="no"><span class="invisible">https://</span><span class="ellipsis">blog.radwebhosting.com/how-to-</span><span class="invisible">install-abuseio-on-a-debian-vps/?utm_source=mastodon&amp;utm_medium=social&amp;utm_campaign=ReviveOldPost</span></a> <a href="https://mastodon.social/tags/mariadb" class="mention hashtag" rel="tag">#<span>mariadb</span></a> <a href="https://mastodon.social/tags/installguide" class="mention hashtag" rel="tag">#<span>installguide</span></a> <a href="https://mastodon.social/tags/vpsguide" class="mention hashtag" rel="tag">#<span>vpsguide</span></a></p>
Michel Lind :fedora: :debian:<p>Bless your transactions by committing them with "amen" in <span class="h-card" translate="no"><a href="https://fosstodon.org/@mariadb" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>mariadb</span></a></span> </p><p><a href="https://mariadb.org/amen-statement-for-committing-transactions/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">mariadb.org/amen-statement-for</span><span class="invisible">-committing-transactions/</span></a></p><p><a href="https://hachyderm.io/tags/AprilFools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>AprilFools</span></a> <br><a href="https://hachyderm.io/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a> <br><a href="https://hachyderm.io/tags/Database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Database</span></a> <br><a href="https://hachyderm.io/tags/Transaction" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Transaction</span></a></p>
Upscene Productions<p>Video: Convert a <a href="https://mstdn.business/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> database to <a href="https://mstdn.business/tags/PosgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PosgreSQL</span></a> using Database Workbench.</p><p><a href="https://youtu.be/L4nOo26CIdU" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">youtu.be/L4nOo26CIdU</span><span class="invisible"></span></a></p><p><a href="https://mstdn.business/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a><br><a href="https://mstdn.business/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a><br><a href="https://mstdn.business/tags/SQLServer" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLServer</span></a><br><a href="https://mstdn.business/tags/Oracle" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Oracle</span></a><br><a href="https://mstdn.business/tags/Firebird" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Firebird</span></a><br><a href="https://mstdn.business/tags/InterBase" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>InterBase</span></a><br><a href="https://mstdn.business/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a><br><a href="https://mstdn.business/tags/NexusDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NexusDB</span></a><br><a href="https://mstdn.business/tags/databasetools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>databasetools</span></a> <a href="https://mstdn.business/tags/databasedevelopment" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>databasedevelopment</span></a> <a href="https://mstdn.business/tags/DatabaseWorkbench" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseWorkbench</span></a></p>
Federico Razzoli<p>The EXPLAIN command has been extended in different ways by <a href="https://mastodon.social/tags/MariaDB" class="mention hashtag" rel="tag">#<span>MariaDB</span></a> and <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="tag">#<span>MySQL</span></a>. See which options you have on these fantastic systems!<br /><a href="https://vettabase.com/the-explain-command-and-its-variants-in-mariadb-and-mysql/" target="_blank" rel="nofollow noopener" translate="no"><span class="invisible">https://</span><span class="ellipsis">vettabase.com/the-explain-comm</span><span class="invisible">and-and-its-variants-in-mariadb-and-mysql/</span></a></p>
Rad Web Hosting<p>10 Steps to Protect Your <a href="https://mastodon.social/tags/VPS" class="mention hashtag" rel="tag">#<span>VPS</span></a> Against SQL Injection <br />This article provides a guide discussing how to protect your VPS against SQL injection.</p><p>Cybercriminals often target websites to gain access to valuable user data such as login credentials. This data could then be used for identity theft or sold on the dark web. Preventing SQL injection is an important step to secure your VPS ...<br />Continued 👉 <a href="https://blog.radwebhosting.com/how-to-protect-your-vps-against-sql-injection/?utm_source=mastodon&amp;utm_medium=social&amp;utm_campaign=ReviveOldPost" target="_blank" rel="nofollow noopener" translate="no"><span class="invisible">https://</span><span class="ellipsis">blog.radwebhosting.com/how-to-</span><span class="invisible">protect-your-vps-against-sql-injection/?utm_source=mastodon&amp;utm_medium=social&amp;utm_campaign=ReviveOldPost</span></a> <a href="https://mastodon.social/tags/sqlinjection" class="mention hashtag" rel="tag">#<span>sqlinjection</span></a> <a href="https://mastodon.social/tags/vpsguide" class="mention hashtag" rel="tag">#<span>vpsguide</span></a> <a href="https://mastodon.social/tags/mariadb" class="mention hashtag" rel="tag">#<span>mariadb</span></a> <a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="tag">#<span>postgresql</span></a></p>
zwangseinweisung<p>Oh... <a href="https://mastodon.social/tags/MariaDB" class="mention hashtag" rel="tag">#<span>MariaDB</span></a> in <a href="https://mastodon.social/tags/Debian" class="mention hashtag" rel="tag">#<span>Debian</span></a> ist kaputt<br /><a href="https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1101340" target="_blank" rel="nofollow noopener" translate="no"><span class="invisible">https://</span><span class="ellipsis">bugs.debian.org/cgi-bin/bugrep</span><span class="invisible">ort.cgi?bug=1101340</span></a></p>
Alejandro Duarte<p>🚨 Hackathon Alert - AI Developers 🚨</p><p>Build with MariaDB Vector + Python.</p><p>Submit your AI project idea by March 31, demo it at Helsinki Python Meetup in May.</p><p>👉 Join via <a href="https://helsinki-python.github.io/discord" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">helsinki-python.github.io/disc</span><span class="invisible">ord</span></a><br>🔗 <a href="https://mariadb.org/ai-hackathon/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">mariadb.org/ai-hackathon/</span><span class="invisible"></span></a></p><p> <a href="https://mastodon.online/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a> <a href="https://mastodon.online/tags/Python" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Python</span></a> <a href="https://mastodon.online/tags/AI" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>AI</span></a> <a href="https://mastodon.online/tags/VectorSearch" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>VectorSearch</span></a> <a href="https://mastodon.online/tags/Hackathon" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Hackathon</span></a> <a href="https://mastodon.online/tags/Helsinki" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Helsinki</span></a> <a href="https://mastodon.online/tags/Finland" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Finland</span></a> <a href="https://mastodon.online/tags/Suomi" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Suomi</span></a></p>
Alejandro Duarte<p>🔧 Time to update your Maven's pom.xml: <a href="https://mastodon.online/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a> Connector/J 3.5.3 available (also 3.4.2, and 3.3.4)</p>
Helsinki Python<p>For our May meetup (that's the one after the next one) we have <span class="h-card" translate="no"><a href="https://fosstodon.org/@mariadb_org" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>mariadb_org</span></a></span> as a host and they are also organising a hackathon! There are a few €500 Verkkokauppa gift cards as prizes for the best use of their new vector extension to <span class="h-card" translate="no"><a href="https://fosstodon.org/@mariadb" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>mariadb</span></a></span>.</p><p>Deadline for sign up is Monday (31st). Find out more details via their announcement blog post, and join up on our Discord via <a href="https://helsinki-python.github.io" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">helsinki-python.github.io</span><span class="invisible"></span></a></p><p><a href="https://fosstodon.org/tags/Helsinki" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Helsinki</span></a> <a href="https://fosstodon.org/tags/Python" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Python</span></a> <a href="https://fosstodon.org/tags/HelPy" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>HelPy</span></a> <a href="https://fosstodon.org/tags/meetup" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>meetup</span></a> <a href="https://fosstodon.org/tags/hackathon" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>hackathon</span></a> <a href="https://fosstodon.org/tags/Finland" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Finland</span></a> <a href="https://fosstodon.org/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a></p>
Christian Mayer<p>DBeaver — Universal Database Tool — <a href="https://dbeaver.io/" target="_blank" rel="nofollow noopener" translate="no"><span class="invisible">https://</span><span class="">dbeaver.io/</span><span class="invisible"></span></a> <a href="https://mastodon.social/tags/mysql" class="mention hashtag" rel="tag">#<span>mysql</span></a> <a href="https://mastodon.social/tags/mariadb" class="mention hashtag" rel="tag">#<span>mariadb</span></a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="tag">#<span>sql</span></a> <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="tag">#<span>sqlite</span></a> <a href="https://mastodon.social/tags/erd" class="mention hashtag" rel="tag">#<span>erd</span></a> <a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="tag">#<span>postgresql</span></a> <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="tag">#<span>database</span></a></p>
Ron<p>So, mittlerweile ist es doch akut geworden, sich über das Logging in FHEM Gedanken zu machen. Nach 1,5 Jahren haben sich 87.000.000 Datensätze haben sich in der DbLog angesammelt. Vernünftig handhaben lassen sich diese Daten kaum.</p><p>Es ist also Zeit sich einmal grundlegende Gedanken zum logging zu machen.</p><p>1. Grundregel: Logging generell ausstellen für JEDES neue Gerät. In die fhem.cfg gehört dieser Befehl: </p><p>```<br>attr global DbLogExclude .*<br>```</p><p>Damit wird erreicht, dass kein Gerät Daten loggt. für jedes Gerät wird explizit entschieden, ob es geloggt werden soll: </p><p>```<br>attr DEVICE DbLogInclude READING1,READING2,READING3<br>```</p><p>2. Nur Veränderungen werden geloggt:<br>Ohne die folgende Zeile wird *SEHR* viel protokolliert.</p><p>```<br>attr DEVICE READING1,READING2,READING3<br>```</p><p>Damit werden nur geänderte Daten geloggt.</p><p>3. Genau überlegen, wofür man die geloggten Daten *WIRKLICH* braucht.<br>Mir fallen nur 2 Gründe ein: um Fehlern auf die Schliche zu kommen, für Diagramme (Plots, also statistische Erhebungen). Es werden beim Logging ja zwei Tabellen bedient: Eine Tabelle enthält immer den letzten Wert und eine Tabelle enthält auch historische Werte. Wann immer auf aktuelle Werte zurückgegriffen werden soll, wird die current-DB bemüht und nur für Plots und dergleichen wird auf die Histrory zurückgegriffen. Und genau diese wird sehr schnell sehr gross. Bei mir nach 1,5 Jahren knapp 1 TB.</p><p>Und je größer die Datenbank, bei MariaDB wird der Zugriff auf die Daten immer langwieriger. Und irgendwann ist sogar das Löschen kaum noch möglich.</p><p>Ich habe Schritt für Schritt angefangen zu löschen</p><p>```<br>set DBLog delete OldDays TAGE<br>```</p><p>löscht alles, was älter als TAGE ist. Ich habe Monatsweise gelöscht. Mein System löscht ungefähr 300.000 Datensätze pro Stunde. Pro Monat sind ungefähr 5 h notwendig. In der zeit kann nicht in die Datenbank geschrieben werden. Es gehen aber keine Daten verloren, sie werden zwischengepuffert. Bei mir waren das durchaus im Bereich 30.000 bis 40.000 Datensätze. Ich weiss nicht, wieviele Datensätze das System zwischenspeichern kann... Da ich zum tageswechsel rechenintensive Routinen laufen habe, hab ich es immer so getimet, dass ich weit vor Mitternacht aufgehört habe. Nach 3 Tagen hatte ich ein halbes Jahr Daten über Board gekippt.</p><p>4. Da im Laufe der Zeit immer mehr protokolliert wurde, habe ich mich rangesetzt, und bin die Geräte durchgegangen und hab Unsinniges gelöscht. Dazu habe ich aber eine Liste aller Devices gebraucht. Über FHEM weiss ich nicht, wie man hier eine Liste bekommen kann. Das habe ich daher ausserhalb von FHEM gemacht: mit phpMyAdmin. Der folgende SQL-Befehl gibt alle Devices aus und sagt auch, wie viele Datensätze enthalten sind.</p><p>```<br>SELECT history.DEVICE, Count(history.DEVICE) AS<br>AnzahlvonDEVICE<br>FROM history<br>GROUP BY history.DEVICE;<br>```</p><p>sowas kommt dabei raus:</p><p>```<br>Robin_6fachTaster6 6<br>RonIP 3608305<br>RouterIP 176987<br>Schlafzimmer_Thermostat_Clima 30604<br>Serverstrom 2252086<br>ShellyBad 63924<br>SpielZimmer_Heizung_Messwerte 675<br>```</p><p>DIe Geräte mit nur wenigen Treffern sind egal, da wird eher nichts (mehr) protokolliert. Aber alle anderen schaut man sich an. Bei Thermostaten kann man viel sparen: denn wenn man neben dem Stellmotor noch einen Wandthermostaten verwendet, braucht man beim Stellmotor ausser der Ventilöffnung, wenn man die braucht, werden Temperatur noch Luftfeuchtigkeit protokollieren, das tut man beim Wandthermostaten.</p><p>Bei Strommessern habe ich die Stromstärke mitgeschrieb en. Wozu? Hab ich noch nie gebraucht.</p><p>Bei Schaltern braucht man nicht mitloggen, wie oft man geschaltet hat. u.s.w. u.s.f.</p><p>Ich werde jedenfalls noch weiter löschen, bis ich beim 1.1.25 angekommen bin. Da ich zwischenzeitlich die zu speichernde Datenmenge ordentlich ausgemistet habe. Sollten die anfallenden Daten überschaubar sein. Am Interessantesten sind bei mir die Energie-Messwerte. Da könnte man überlegen, ob man die Daten nicht FHEM ausdünnen läßt. z.B. einmal im Monat schmeisst man alles weg, ausser den letzten Wert. Oder man mittelt die tageswerte und hebt nur den Mittelwert auf. Mal schauen. Aber insgesamt denke ich, alles was länmger als 1 Monat zurückliegt, ist eher uninteressant und kann weg. Aber als Daten-Messi fällt es natürlich schwer, sich von Datenmüll zu trennen!<br><a href="https://social.amichan.de/tags/fhem" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>fhem</span></a> <a href="https://social.amichan.de/tags/dblog" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dblog</span></a> <a href="https://social.amichan.de/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mariadb</span></a> <a href="https://social.amichan.de/tags/wermisstmisstmist" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>wermisstmisstmist</span></a></p>
Alejandro Duarte<p>🤔 "What did this row look like last month?". Watch this 60s demo to learn how to answer this question with <a href="https://mastodon.online/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a> 🚫 No triggers 🚫 No extra tables 🚫 No timestamp hacks.<br>👉 <a href="https://youtube.com/shorts/3GHV0D6wSFI" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">youtube.com/shorts/3GHV0D6wSFI</span><span class="invisible"></span></a></p>
Upscene Productions<p>Video: Creating an <a href="https://mstdn.business/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLite</span></a> database with tables and foreign key relationships.<br><a href="https://www.youtube.com/watch?v=w88NySp6Ydk" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">youtube.com/watch?v=w88NySp6Yd</span><span class="invisible">k</span></a></p><p><a href="https://mstdn.business/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a><br><a href="https://mstdn.business/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a><br><a href="https://mstdn.business/tags/SQLServer" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLServer</span></a><br><a href="https://mstdn.business/tags/Oracle" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Oracle</span></a><br><a href="https://mstdn.business/tags/Firebird" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Firebird</span></a><br><a href="https://mstdn.business/tags/InterBase" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>InterBase</span></a><br><a href="https://mstdn.business/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a><br><a href="https://mstdn.business/tags/NexusDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NexusDB</span></a><br><a href="https://mstdn.business/tags/databasetools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>databasetools</span></a> <a href="https://mstdn.business/tags/databasedevelopment" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>databasedevelopment</span></a> <a href="https://mstdn.business/tags/DatabaseWorkbench" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseWorkbench</span></a></p>
Paul<p><span class="h-card" translate="no"><a href="https://social.anoxinon.de/@linuxnews" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>linuxnews</span></a></span>&nbsp;ja, Nextcloud &amp; <a href="https://troet.cafe/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a> ist deutlich Wartungsintensiver als Nextcloud &amp; <a href="https://troet.cafe/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a></p>