If anyone decided to set up #Nextcloud, I've learned that it runs so much better on #PostgreSQL than #MySQL or #MariaDB.

#duckduckfedi #mysql :

I experience sth like this:

Logging into database locally:
mysql -ume -pmypwd
> SELECT current_user();
>> me@%
> use mydb;
>> OK

Logging in remotely:
mysql -ume -pmypwd -hmyhost
> SELECT current_user();
>> me@%
> use mydb;
>> Access denied for user 'me'@'%' to database 'mydb'

Same server, as far as I can tell same user, same passwords... Why can't I access mydb from outside?

I don't even know how to google this.

New release of free Database Workbench Lite Edition for #Firebird and #MySQL/#MariaDB.

Additional database systems supported in Basic, Pro and Enterprise editions: #SQLServer #oracle #sqlite #PostgreSQL #postgres #interbase #nexusdb

https://www.upscene.com/news/item/20250724

Speaker confirmed for #NextcloudConf25!

Michael “Monty” Widenius, creator of #MySQL and co-founder of #MariaDB, will be joining us in Berlin!

Decades of #OpenSource wisdom, from a true pioneer.
Sept 27–28
Berlin, Germany

Tickets: https://nextcloud.com/conference-2025/

Today's fun challenge:

Can't export a MySQL database using MariaDB mysqldump because the tools have now diverged too far

Can't install the MySQL mysqldump because it conflicts with the MariaDB one

Can't use the Docker MySQL image because it doesn't allow interaction (to provide the password)

Can't use the Docker MySQL image with an environment variable because that's ignored when redirecting output to a file

Subsonic Mediathek plötzlich leer? So behebst du’s!

Kennst du das Problem? Nach einem Mediensuchlauf in Subsonic ist plötzlich deine komplette Mediathek leer. Alle Songs, Alben und leere Playlists - einfach weg! Genau das ist mir passiert, nachdem ich meinen Subsonic-Server mit einer MySQL-Datenbank verbunden h...

https://www.cleveradmin.de/blog/2025/07/subsonic-mediathek-fix/
#Scripte #BashScript #cronjob #Fix #Mediathek #Medienverwaltung #Musikserver #mysql #OpenSource #Subsonic

I've used #MySQL before (last time was 2016, I think), but today I'm mostly onto #Postgres (and sometimes, #SQLite). I know PG is superior to MySQL is pretty much all aspect I could think of, but still, it seems that MySQL still has a quite big user base.

What's the catch? What am I missing here? Why would someone use MySQL over Postgres to build smt since Postgres [apparently] is better than MySQL in every single possible aspect?

It's a honest question. Please help me understand it – and perhaps, consider modern MySQL/MariaDB in next projects. :)

*Takes a deep breath*

#MariaDB 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.

Side note: #PostgreSQL, 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.

User-Management Solution for Ubuntu Nodes with users' details and encrypted passwords in a MySQL Database #login #mysql #authentication #usermanagement #groups

https://askubuntu.com/q/1552742/612

Better experience and fast, secure way to create a connection with MariaDB.

// Config.php

$mariadb = ini_get('pdo_mysql.default_socket');

$pdo = new PDO("mysql:unix_socket=$mariadb;dbname=test", 'root', '');

if($pdo){
echo "Database connection success!";
}

#Datatables ist schon ein geiles #Javascript Framework zur Darstellung von Tabellen. Zusammen mit #PHP, #MySQL, #jQuery und #Ajax lassen sich da richtig gute Anwendungen bauen.

Want smoother user experience in your PHP apps? Learn how I implement MySQL pagination without the bloat. Clean, scalable, and dev-friendly.
https://mikelopez.com/blog/1118
#PHP #MySQL #DevLife #Pagination #WebDevelopment #BasicPHP

Nexus joins data across systems and you can process the join anywhere.

https://coffingdw.com/1000-techniques-to-join-data-across-systems/

Nexus can join one hundred tables from one hundred different systems in a single query.

https://coffingdw.com/2023-a-100-table-join-across-100-systems/

Today is the DBA Appreciation Day!

Bring your DBAs a cake and a coffee, please. And don't drop any tables in production, pretty please. It's weekend ...

Nexus builds a visualization dashboard for every user on every system for every answer set.