#Perl DBD::mysql and the corresponding #RHEL package have always been #MariaDB compatible, i.e., you could install MariaDB and DBD::mysql RPMs together.
But the new DBD::mysql package in #CentOS stream can no longer be installed with MariaDB.
I filed a bug (https://issues.redhat.com/browse/RHEL-88746) and #RedHat said it's not supposed to work. Except it always has.
What do you think?
(Note if it doesn't work then all Perl scripts on the host that use DBD::mysql must be modified to use DBD::MariaDB instead.)
#mysql

Movim is powerful web frontend for XMPP. Movim is officially dropping support for MySQL. They will only provide official support for PostgreSQL (default) and MariaDB.

https://movim.eu/

Movim is officially dropping support for MySQL

It is too difficult to maintain compatibility with all the quirks and specificity of this database MySQL was already broken for a while (migrations not running, broken queries).

Don't worry we are still fully compatible with PostgreSQL (that is the recommended one) and MariaDB. You can find those two databases in all the major distributions

This will greatly simplify and streamline the development of the project

Ive built a setup for hosting websites which consists of:
* Host running #microos with #podman
* #Treafik and #sshpiper at the edge
* #Nginx, php-fpm, #mariadb + phpmyadmin + nginx or #postgres + dbadmin, openssh for each site

It actually works quite well, openssh keybased access is to transfer files into the containers, traefik does the reverse proxying.

I'm just wondering if its a sustainable and maintainable setup. Sometimes just going with a "standard" solution seems so much easier.

https://blog.martinscloud.com/mariadb-use-docker-compose-for-mariadb/ #docker #docker-compose #compose #mysql #mariadb

Started to look at what modern forums look like now. Besides #discourse.

#nodebb is nice. Somewhat simple. #nodejs, #redis, and #mongodb.

#flarum is very intuitive. #php and #mariadb. Runs light and smooth.

Flarum liking for simplicity. Although nodebb has fediverse magic.

Auch nett: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

Wird vielleicht doch Zeit für tiefere Optimierungen an #mariadb…

Web developers: Do you use MariaDB or PostgreSQL for web apps? Is there any particular reason for your choice?

- Eridian

Database Migrations in the Real World

#mariadb #migration #mysql #oracle #postgresql

https://blog.jetbrains.com/idea/2025/02/database-migrations-in-the-real-world/

I got MariaDB installed on Debian which is a better replacement for MySQL, right?

I do remember using MariaDB many years ago... for what I need it should work just fine I assume.

(Some simple web site databases, WordPress, etc.)

Whenever an app let's you select from #sqlite , #MariaDB , or #postgresql , please don't select SQLite . I know it is easier now, but it is almost inevitable that you are going to need a real #SQL database. The transfer of data is always a #PITA.

Finally got data to import from a .csv file into a MariaDB table, for my toy train db. It dropped ~150 records from errors, so I'll have to do it again tomorrow.

As ever, data normalization is the key. I learned I have more steps to take after I save a LibreOffice Calc file as a .csv file, before importing it.

Still, real progress, and I feel good about that.

Quizfrage: Wann habe ich auf dieser #Friendica Instanz für die #MariaDB #Jemalloc aktiviert?
Erstaunt mich immer wieder, was das bringt.

#anonsys.net #Linux #Fediverse #FediAdmin #FriendicaAdmin

https://blog.martinscloud.com/mariadb-mysql-migrate-from-mariadb-to-mysql-using-mysql-shell/ #oracle #mysql #mariadb #migration #mysqlshell #mysql-shell #mysql_shell

/ #software / #app

@AntaresSQL
by @akela86

https://laravista.altervista.org/CatLink/links/272

Any foss tool to manage a database lifecycle (deployment, upgrades, incrementals and full backups)?

Thanks