mastodon.world is one of the many independent Mastodon servers you can use to participate in the fediverse.
Generic Mastodon server for anyone to use.

Server stats:

8.1K
active users

#mariadb

11 posts9 participants3 posts today
House Panther :verified_paw:<p>If anyone decided to set up <a href="https://goblackcat.social/tags/Nextcloud" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Nextcloud</span></a>, I've learned that it runs so much better on <a href="https://goblackcat.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> than <a href="https://goblackcat.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> or <a href="https://goblackcat.social/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a>.</p>
beyondwatts<p>Number of <a href="https://beyondwatts.social/tags/bitnami" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>bitnami</span></a> container images in the <a href="https://beyondwatts.social/tags/homelab" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>homelab</span></a> cluster: 4</p><p>Number of <a href="https://beyondwatts.social/tags/bitnami" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>bitnami</span></a> container images successfully removed: 2</p><p>Number of <a href="https://beyondwatts.social/tags/bitnami" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>bitnami</span></a> container images to remove: 1</p><p>Next up was redis. Harbor doesn't support a full redis cluster so I searched around for a primary-secondary configuration. Looks like the DandyDeveloper helm chart should do the business so we are off to the races... Two down, one to go!</p><p><a href="https://github.com/DandyDeveloper/charts/tree/master/charts/redis-ha" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">github.com/DandyDeveloper/char</span><span class="invisible">ts/tree/master/charts/redis-ha</span></a></p><p><a href="https://beyondwatts.social/tags/homelab" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>homelab</span></a> <a href="https://beyondwatts.social/tags/kubernetes" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>kubernetes</span></a> <a href="https://beyondwatts.social/tags/docker" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>docker</span></a> <a href="https://beyondwatts.social/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mariadb</span></a> <a href="https://beyondwatts.social/tags/galera" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>galera</span></a> <a href="https://beyondwatts.social/tags/redis" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>redis</span></a></p>
beyondwatts<p>Number of <a href="https://beyondwatts.social/tags/bitnami" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>bitnami</span></a> container images in the <a href="https://beyondwatts.social/tags/homelab" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>homelab</span></a> cluster: 4</p><p>Number of <a href="https://beyondwatts.social/tags/bitnami" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>bitnami</span></a> container images successfully removed: 1</p><p>Number of <a href="https://beyondwatts.social/tags/bitnami" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>bitnami</span></a> container images to remove: 2</p><p>First up was mariadb-galera, this may end up being a blocg post as I ended up creating my own configuration. I tried the mariadb-operator but it doesn't support scaling down the cluster so it was quickly ruled out...</p><p><a href="https://beyondwatts.social/tags/homelab" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>homelab</span></a> <a href="https://beyondwatts.social/tags/kubernetes" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>kubernetes</span></a> <a href="https://beyondwatts.social/tags/docker" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>docker</span></a> <a href="https://beyondwatts.social/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mariadb</span></a> <a href="https://beyondwatts.social/tags/galera" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>galera</span></a></p>
Rad Web Hosting<p>10 Steps to Protect Your <a href="https://mastodon.social/tags/VPS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>VPS</span></a> Against SQL Injection <br>This article provides a guide discussing how to protect your VPS against SQL injection.<br>What is SQL Injection?<br>SQL Injection is a type of cyber attack where an attacker inserts or “injects” malicious SQL code into a query through input fields, URLs, or other data entry points. If the application doesn't properly validate or sanitize the input, the ...<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=mastodon.social" rel="nofollow noopener" translate="no" target="_blank"><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=mastodon.social</span></a> <a href="https://mastodon.social/tags/sqlinjection" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlinjection</span></a> <a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgresql</span></a> <a href="https://mastodon.social/tags/vpsguide" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>vpsguide</span></a> <a href="https://mastodon.social/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mariadb</span></a></p>
Rad Web Hosting<p>⚙️ SSD-Powered <a href="https://mastodon.social/tags/cPanel" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>cPanel</span></a> Web <a href="https://mastodon.social/tags/Hosting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Hosting</span></a> – Up to 25x Faster ⚙️ SSD-Powered cPanel Web Hosting by Rad Web Hosting<br>Built for Performance. Backed by Reliability. Ready to Scale.<br>Developers, sysadmins, and power users—we built this for you. Our SSD-powered cPanel hosting is engineered on high-availability ...<br>Continued 👉 <a href="https://blog.radwebhosting.com/ssd-powered-cpanel-web-hosting-up-to-25x-faster/?utm_source=mastodon&amp;utm_medium=social&amp;utm_campaign=mastodon.social" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">blog.radwebhosting.com/ssd-pow</span><span class="invisible">ered-cpanel-web-hosting-up-to-25x-faster/?utm_source=mastodon&amp;utm_medium=social&amp;utm_campaign=mastodon.social</span></a> <a href="https://mastodon.social/tags/letsencrypt" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>letsencrypt</span></a> <a href="https://mastodon.social/tags/phpmyadmin" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>phpmyadmin</span></a> <a href="https://mastodon.social/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mariadb</span></a> <a href="https://mastodon.social/tags/litespeed" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>litespeed</span></a> <a href="https://mastodon.social/tags/cloudlinux" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>cloudlinux</span></a> <a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgresql</span></a> <a href="https://mastodon.social/tags/phppgadmin" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>phppgadmin</span></a> <a href="https://mastodon.social/tags/wpcli" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>wpcli</span></a> <a href="https://mastodon.social/tags/laravel" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>laravel</span></a> <a href="https://mastodon.social/tags/csf" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>csf</span></a> <a href="https://mastodon.social/tags/softaculous" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>softaculous</span></a> <a href="https://mastodon.social/tags/joomla" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>joomla</span></a> <a href="https://mastodon.social/tags/webhosting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>webhosting</span></a></p>
Paul<p>Got Cobra working in Go for my db2xlsx project which exports a MySQL / MariaDB database structure to an Excel file.</p><p>Benefits:</p><p>Simplifies the parsing<br>Allows for sub commands<br>Supports mandatory arguments</p><p>Three issues closed as a result, and I'll be able to tackle two of the others based on the groundwork laid.</p><p><a href="https://github.com/godev-uk/db2xlsx" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">github.com/godev-uk/db2xlsx</span><span class="invisible"></span></a></p><p><a href="https://social.xk7.net/tags/golang" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>golang</span></a> <a href="https://social.xk7.net/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> <a href="https://social.xk7.net/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a></p>
Rad Web Hosting<p>Install and Configure <a href="https://mastodon.social/tags/Cacti" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Cacti</span></a> on <a href="https://mastodon.social/tags/AlmaLinux" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>AlmaLinux</span></a> <a href="https://mastodon.social/tags/VPS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>VPS</span></a> This article provides a guide demonstrating how to install and configure Cacti on AlmaLinux VPS.</p><p>What Is Cacti?<br>Cacti is an open-source network monitoring and graphing tool built on top of RRDtool. It’s designed to collect, store, and visualize time-series data from networks and systems.<br>What Cacti Does</p><p> Polls data from devices ...<br>Continued 👉 <a href="https://blog.radwebhosting.com/install-and-configure-cacti-on-almalinux-vps/?utm_source=mastodon&amp;utm_medium=social&amp;utm_campaign=mastodon.social" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">blog.radwebhosting.com/install</span><span class="invisible">-and-configure-cacti-on-almalinux-vps/?utm_source=mastodon&amp;utm_medium=social&amp;utm_campaign=mastodon.social</span></a> <a href="https://mastodon.social/tags/opensource" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>opensource</span></a> <a href="https://mastodon.social/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mariadb</span></a> <a href="https://mastodon.social/tags/letsencrypt" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>letsencrypt</span></a> <a href="https://mastodon.social/tags/selfhosted" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>selfhosted</span></a> <a href="https://mastodon.social/tags/selfhosting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>selfhosting</span></a> <a href="https://mastodon.social/tags/rrdtool" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>rrdtool</span></a></p>
Nextcloud 📱☁️💻<p>Speaker confirmed for <a href="https://mastodon.xyz/tags/NextcloudConf25" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NextcloudConf25</span></a>! </p><p> 🎤 Michael “Monty” Widenius, creator of <a href="https://mastodon.xyz/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> and co-founder of <a href="https://mastodon.xyz/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a>, will be joining us in Berlin! </p><p> Decades of <a href="https://mastodon.xyz/tags/OpenSource" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OpenSource</span></a> wisdom, from a true pioneer. <br> 📅 Sept 27–28 <br> 📍 Berlin, Germany </p><p> Tickets: <a href="https://nextcloud.com/conference-2025/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">nextcloud.com/conference-2025/</span><span class="invisible"></span></a></p>
Paul<p>Today's fun challenge:</p><p>Can't export a MySQL database using MariaDB mysqldump because the tools have now diverged too far</p><p>Can't install the MySQL mysqldump because it conflicts with the MariaDB one</p><p>Can't use the Docker MySQL image because it doesn't allow interaction (to provide the password)</p><p>Can't use the Docker MySQL image with an environment variable because that's ignored when redirecting output to a file</p><p><a href="https://social.xk7.net/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> <a href="https://social.xk7.net/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a></p>
LLMsАльтернатива чатам с ИИ для анализа и оптимизации SQL запросов Всем привет! Экспериментировал с оптимизацие...<br><br><a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/sql" target="_blank">#sql</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/mysql" target="_blank">#mysql</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/mariadb" target="_blank">#mariadb</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/mysql" target="_blank">#mysql</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/optimization" target="_blank">#optimization</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/mysql" target="_blank">#mysql</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/tuning" target="_blank">#tuning</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/sql" target="_blank">#sql</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/tuning" target="_blank">#tuning</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/optimizer" target="_blank">#optimizer</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/query" target="_blank">#query</a><br><br><a href="https://habr.com/ru/articles/929730/?utm_source=habrahabr&amp;utm_medium=rss&amp;utm_campaign=929730" rel="nofollow noopener" target="_blank">Origin</a> | <a href="https://awakari.com/sub-details.html?id=LLMs" rel="nofollow noopener" target="_blank">Interest</a> | <a href="https://awakari.com/pub-msg.html?id=LhirPKeba513TWTIPntj8WWpfxg&amp;interestId=LLMs" rel="nofollow noopener" target="_blank">Match</a>
Habr<p>Альтернатива чатам с ИИ для анализа и оптимизации SQL запросов</p><p>Всем привет! Экспериментировал с оптимизацией SQL запросов в ChatGPT и Claude. В какой-то момент понял, что это превращается в одно и то же: Напиши промт → вставь SQL → подожди → поправь → повтори</p><p><a href="https://habr.com/ru/articles/929730/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">habr.com/ru/articles/929730/</span><span class="invisible"></span></a></p><p><a href="https://zhub.link/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> <a href="https://zhub.link/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysql</span></a> <a href="https://zhub.link/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mariadb</span></a> <a href="https://zhub.link/tags/mysql_optimization" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysql_optimization</span></a> <a href="https://zhub.link/tags/mysql_tuning" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysql_tuning</span></a> <a href="https://zhub.link/tags/sql_tuning" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql_tuning</span></a> <a href="https://zhub.link/tags/optimizer" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>optimizer</span></a> <a href="https://zhub.link/tags/query_optimization" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>query_optimization</span></a> <a href="https://zhub.link/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgresql</span></a></p>
dusoft<p>TIL that MariaDB has more performing engines such as MyRocks or OQGraph for storing graph structures. <a href="https://fosstodon.org/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysql</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/dba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dba</span></a> <a href="https://fosstodon.org/tags/db" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>db</span></a> <a href="https://fosstodon.org/tags/Databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Databases</span></a></p>
Neustradamus :xmpp: :linux:<p><a href="https://mastodon.social/tags/Roundcube" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Roundcube</span></a> 1.7 Beta has been released (<a href="https://mastodon.social/tags/Webmail" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Webmail</span></a> / <a href="https://mastodon.social/tags/Mail" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Mail</span></a> / <a href="https://mastodon.social/tags/IMAP" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>IMAP</span></a> / <a href="https://mastodon.social/tags/SMTP" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SMTP</span></a> / <a href="https://mastodon.social/tags/LDAP" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>LDAP</span></a> / <a href="https://mastodon.social/tags/Managesieve" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Managesieve</span></a> / <a href="https://mastodon.social/tags/PHP" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PHP</span></a> / <a href="https://mastodon.social/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a> / <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> / <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> / <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLite</span></a> / <a href="https://mastodon.social/tags/OracleDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OracleDB</span></a> / <a href="https://mastodon.social/tags/MSSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MSSQL</span></a>) <a href="https://roundcube.net/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">roundcube.net/</span><span class="invisible"></span></a></p>
Crazy-to-Bike<p><a href="https://troet.cafe/@nabor" class="u-url mention" rel="nofollow noopener" target="_blank">@nabor@troet.cafe</a> <a href="https://troet.cafe/@Klimakipppunkt" class="u-url mention" rel="nofollow noopener" target="_blank">@Klimakipppunkt@troet.cafe</a> <a href="https://freiburg.social/@CrazyIT" class="u-url mention" rel="nofollow noopener" target="_blank">@CrazyIT@freiburg.social</a> <a href="https://mastodon.social/@alexantemachina" class="u-url mention" rel="nofollow noopener" target="_blank">@alexantemachina@mastodon.social</a><span> <br><br>Da ich tatsächlich keine Möglichkeit sehe, HA auf ein vernünftiges Filesystem zu installieren - so ich das sehe, hat man, egal welche Installationsvariante man wählt, immer ein </span><a href="https://fediworld.de/tags/vFat" rel="nofollow noopener" target="_blank">#vFat</a> <a href="https://fediworld.de/tags/Dateisystem" rel="nofollow noopener" target="_blank">#Dateisystem</a> - wird wohl das Auslagern der <a href="https://fediworld.de/tags/Datenbank" rel="nofollow noopener" target="_blank">#Datenbank</a><span> respektive, eine ganz andere DB anzuflanschen, der einzige Ansatz sein, der Sinn macht, um ein stabiles System zu bekommen, bei dem nicht nach jedem Stromausfall alle Daten weg sind.<br><br>Den statischen Teil von /homeassistant kann man ja einmal wegsichern und bei Bedarf zurückspielen.<br><br>Die Datenbank muss aber stabil sein, um nicht immer wieder zeitweise Datenverlust zu haben, weil zwischen letzem Backup und Ausfall Zeit vergangen ist.<br><br>Am Besten kenne ich mich mit </span><a href="https://fediworld.de/tags/mySQL" rel="nofollow noopener" target="_blank">#mySQL</a> / <a href="https://fediworld.de/tags/MariaDB" rel="nofollow noopener" target="_blank">#MariaDB</a> aus. Da würde ich eine VM in <a href="https://fediworld.de/tags/Proxmox" rel="nofollow noopener" target="_blank">#Proxmox</a> damit machen und dann mit dem ensprechenden <a href="https://fediworld.de/tags/Addon" rel="nofollow noopener" target="_blank">#Addon</a><span> von HA anflanschen.<br><br>Eine komplette (Debian o.ä.)-VM für die Datenbank halte ich für übertrieben. Also </span><a href="https://fediworld.de/tags/LXC" rel="nofollow noopener" target="_blank">#LXC</a><span>, oder was spricht dagegen (außer, dass ich LXC noch nie genutzt und deshalb damit keine Erfahrung habe)?<br><br>Wichtig wäre mir, wenn ich dieSQLite-DB schon in eine echte DB auslagere, dass ich mit </span><a href="https://fediworld.de/tags/phpMyAdmin" rel="nofollow noopener" target="_blank">#phpMyAdmin</a> darauf zugreifen kann. phpMyAdmin lief bisher bei mir immer auf demselben Server wie die DB. Ist das bei LXC easy?</p>
slamp<p>It took me few hours but I upgraded my <a href="https://hachyderm.io/tags/nextcloud" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>nextcloud</span></a> installation from 29.0.5 to 31.0.7<br><a href="https://nextcloud.com/blog/nextcloud-hub10/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">nextcloud.com/blog/nextcloud-h</span><span class="invisible">ub10/</span></a></p><p>The hardest part was updating <a href="https://hachyderm.io/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mariadb</span></a> from 10.5 to 10.11: <br>Indeed, during the restore, I got an error that forced me to delete <a href="https://hachyderm.io/tags/memories" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>memories</span></a> <a href="https://apps.nextcloud.com/apps/memories" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">apps.nextcloud.com/apps/memori</span><span class="invisible">es</span></a></p><p>&gt; mysql restore access denied trigger memories_fcu_trg after update on oc_filecache</p><p>I will not reinstall memories and instead try to use <a href="https://hachyderm.io/tags/immich" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>immich</span></a> with nextcloud</p>
Crazy-to-Bike<p><a href="https://mastodon.social/@alexantemachina" class="u-url mention" rel="nofollow noopener" target="_blank">@alexantemachina@mastodon.social</a><span> <br><br>Warum meinst du?<br>Datenbanken nehmen ja durch eine volle Platte nicht Schaden, im Sinne bereits gespeichertes ist auf einmal weg, sondern, dass neue Daten nicht oder nur korrupt gespeichert werden.<br><br>Grundsätzlich verstehe ich auch nicht, warum bei </span><a href="https://fediworld.de/tags/HomeAssistant" rel="nofollow noopener" target="_blank">#HomeAssistant</a> als Standard auf <a href="https://fediworld.de/tags/SQlite" rel="nofollow noopener" target="_blank">#SQlite</a> gesetzt wird. Egal welches System mit Datenbank ich bisher installiert habe, wurde entweder direkt auf <a href="https://fediworld.de/tags/mySQL" rel="nofollow noopener" target="_blank">#mySQL</a>, <a href="https://fediworld.de/tags/MariaDB" rel="nofollow noopener" target="_blank">#MariaDB</a> oder <a href="https://fediworld.de/tags/Postgres" rel="nofollow noopener" target="_blank">#Postgres</a> gesetzt, oder zumindest empfohlen, nicht SQlite zu nehmen.</p>
Scott Williams 🐧<p>*Takes a deep breath*</p><p><a href="https://mastodon.online/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a> might be the best general database engine ever and it sucks that the for-profit company using the name kept stepping on rusty rakes over and over again so that people in suits who can't distinguish the corp from the foundation pushed for other platforms.</p><p>Side note: <a href="https://mastodon.online/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a>, I want to love you, but I have so many similar feelings about you as I do about coding in rust. You're too pedantic for your own good.</p><p><a href="https://mastodon.online/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>database</span></a> <a href="https://mastodon.online/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysql</span></a> <a href="https://mastodon.online/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgres</span></a></p>
:projetstodon: Shalien<p>The only thing really preventing me from using <span class="h-card" translate="no"><a href="https://writing.exchange/@writefreely" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>writefreely</span></a></span> is that they use <a href="https://mastodon.projetretro.io/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mariadb</span></a></p>
Sushil Kumar<p>Better experience and fast, secure way to create a connection with MariaDB.</p><p> // Config.php</p><p>$mariadb = ini_get('pdo_mysql.default_socket'); </p><p>$pdo = new PDO("mysql:unix_socket=$mariadb;dbname=test", 'root', '');</p><p>if($pdo){<br> echo "Database connection success!";<br>} </p><p><a href="https://mastodon.social/tags/php" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>php</span></a> <a href="https://mastodon.social/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mariadb</span></a> <a href="https://mastodon.social/tags/pdo" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pdo</span></a> <a href="https://mastodon.social/tags/socket" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>socket</span></a> <a href="https://mastodon.social/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysql</span></a> <a href="https://mastodon.social/tags/mysqli" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysqli</span></a> <a href="https://mastodon.social/tags/mysqlpdo" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysqlpdo</span></a></p>
Roland Häder🇩🇪<span class="h-card"><a href="https://kafeneio.social/users/indyradio" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>indyradio</span></a></span> They want to hack my <a href="https://f.haeder.net/search?tag=MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a> server?<br><br>Are they sure?<br><br>But yes, sure. Remotely accessible software can be used to get into your database, e.g. "PHP/Perl/Python shells".