Are you looking for an #online #database #modeling #tool with #SQL generation?
With the latest updates (e.g. modeling of #association #classes), BESSER is your ideal tool to #design and #generate your databases in many different "flavours" :
and even #SQLAlchemy
Ready to give it a try? No installation required! 
https://editor.besser-pearl.org/
Did I already mention is completely 
and #opensource?
#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
1) mariadb:10.11
This one was easy, since healthcheck is documented.
Add the following in the [Container] section of the nextcloud-db.container:
...
HealthCmd=healthcheck.sh --connect --innodb_initialized || exit 1
HealthStartPeriod=10s
HealthInterval=10s
HealthTimeout=5s
HealthRetries=3
Notify=healthy
...
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.
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 
@ninecloudnavigators may I ask why you rather support MySQL instead of #MariaDB for your database products?
i just fucked my entire mysql database. im so fucking cooked man
Hands down the best April Fool's day prank 
New statement to end transaction in MariaDB - amen 
Beautifully crafted by @sigmasternchen 
@andreasdotorg @redknight
I think at that level it's conceptually easy, you "just" need (wo-)manpower to set up and maintain everything yourself. Assuming you want to set up a new cloud provider from scratch and build one/two/three new DCs in different regions in Europe:
- buy standard "off-the-shelve" server hardware
- at this level you can use US networking equipment (firewalls, routers, switches)
- and then use/self-host all the open-source software you want
E.g.:
- use your favourite #Linux distro (#debian, #ubuntu, #fedora, or whatever)
- set up Netbox or a similar tool (and maybe phpIPAM) + #PostGreSQL Server
- there's probably no way around #OpenStack either way, with #MariaDB and some other open source tools in the background
- you can set up #Prometheus, #Grafana, #OpenSearch for observability
And on top of that offer services as you see fit:
- automate setup/maintenance of #Kubernetes clusters (I heard #RKE2 is a fairly self-contained #K8s distribution)
- automate setup/maintenance of DB servers
- provide a way to run "serverless" apps
- set up #nextcloud or so
Most Relational DBMSen (#PostgreSQL, #MariaDB, etc.) have explicit options, when defining a foreign key relationship, to declare what must happen; see "ON DELETE RESTRICT", "ON UPDATE CASCADE", and the like.
#Django ORM `ForeignKey` currently allows specifying the "on delete" referential actions, but not "on update". https://code.djangoproject.com/ticket/21295
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.
Evaluating vector indexes in MariaDB and pgvector: part 1 : https://smalldatum.blogspot.com/2025/01/evaluating-vector-indexes-in-mariadb.html #mariadb #opensource #relational #database #vector #ai #pgvector
Just a regular reminder for you to check your backups.
It's not fun to find after a disaster, that sql backups contain only a short message "mysqldump command not found", because mariadb has stopped shipping mysql aliases in docker images.
Dass #MariaDB für eine Timestamp Column automatisch current_timestamp() einsetzt, als Default und On Update, ist eine Designentscheidung, die ich nie in meinem Leben verstehen werde.
Ich habe den Artikel "Friendica auf dem Raspberry Pi installieren" noch mal überarbeitet bzw. erweitert.
Hinzugekommen sind die Installation von #Apache2, #MariaDB und die benötigten PHP-Module, sowie die Konfiguration des Virtuellen Hosts für Friendica.
So ist nun eine komplette Installationsanleitung daraus entstanden. 
Hier geht es zur Anleitung:
Friendica auf dem Raspberry Pi installieren - Blog:Zwo.me
#friendica, #FriendicaInstallation, #apache2, #mariadb, #php, #virtualhost, #raspberrypi
Try RAG with MariaDB Vector on your own MariaDB data!: https://mariadb.org/rag-with-mariadb-vector/ #mariadb #OpenSource #database #RAG #ai
Hacker News 
