Anyone else remember how #MariaDB company adopting the "Business Source License" for MaxScale made MaxScale and the company super-profitable? No one? Oh yeah, that's because it didn't. #Hashicorp#BUSL#opensource
Does anyone have tips for installing #MySQL alongside and existing #MariaDB server in #Ubuntu 22.04? I am using a bunch of MariaDB exclusive field types and functions for geosearches, but would also like to try out Ghost which requires MySQL.
Hmmm. In the documentation for its latest release, #Django's reference doc says that its ORM layer supports #MariaDB 10.4 and up. It also says it supports MySQL 8.0 and up.
MariaDB 10.4 and #MySQL 8.0 are not guaranteed to be compatible; MariaDB 10.4 and MySQL 5.7 are. Later MariaDB releases make no compatibility guarantees with MySQL.
However, there isn't a separate Django backend for MariaDB; just a "shared" one for MySQL.
Limiting queries doesn't work on #Django with #MariaDB as it would've worked on #PostgreSQL. I've been looking for a way to work around it since yesterday, as I need the ability to limit querysets, but would love to still offer using MariaDB with it rather than forcing the use of PostgreSQL. I'm surprised I've not seen much discussion of this on SO or Django's docs.
Question for the #MySQL / #MariaDB buffs, I have three tables defined thus:
CREATE TABLE IF NOT EXISTS `user` (
`uid` mediumint unsigned NOT NULL auto_increment COMMENT 'sequential ID',
...
PRIMARY KEY(`uid`)
);
CREATE TABLE IF NOT EXISTS `gserver` (
`id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
...
PRIMARY KEY(`id`)
);
CREATE TABLE IF NOT EXISTS `user-gserver` (
`uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner User id',
`gsid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Gserver id',
...
PRIMARY KEY(`uid`,`gsid`),
FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE,
FOREIGN KEY (`gsid`) REFERENCES `gserver` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE
);
Running the last query triggers the error Foreign key constraint is incorrectly formed. Is there no way to reference multiple tables in foreign keys out of a compound primary key?#SQL#Database#DBA
Until a truly performant (= fast, low memory footprint) two dimensional storage ("table") type (*) emerges, what are the options for managing big data in #perl?
Also bestenfalls(?) pro DB-Typ&Version ein Docker-Image auf eigenem Port. Gern direkt mit initialen DBs&Tabellen aus nem zentralen SQL-Dump. Dann kann ich ein PHP Script damit connecten und iterieren.
Sowas muss doch schonmal jemand gemacht haben und ein docker-compose dafür besitzen, zB für QA/Testing? Finde aber nix.
So made some progress on @FurryFediverse last night, updating the Schema to support the new features. I am also moving to #MariaDB#MySQL database support going forward instead of the #SQLite we were using just for the speed and more data we put in it. My main goals today are:
#OffTopic For a dynamic website with a database, is #php + #MariaDB still the best/most recommended combination, or are there lighter options, such as #javascript + DB (json?)?
Oh dear, seems #HashiCorp has decided to finally execute the inevitable bait and switch. The #BSL (#BusinessSourceLicense) is a piece of decidedly not-#FLOSS garbage (albeit one with a converts-to-FLOSS sunset clause built in), that I've been eying wearily ever since #MariaDB created it (though not applying it to anything I actually use; that is still #GPL). The only HashiCorp thing I use is #Terraform; Here's to hoping someone forks the last free version ASAP.
It was a good learning experience and we may use this soon for a client. We may be transferring an older version of a Wordpress website on another host to a ProxMox VM. I haven't done a migration like that before, so we'll see how it goes.
I'm not a big fan of #Wordpress now, but I did use it quite a bit over ten years ago. It's changed a lot since then!
Zu hülf! Wer kennt sich aus? Ich habe eine Datenbank die gehört zu einer php Anwendung (pixelfed) wie finde ich im code raus wo welche Dinge gespeichert werden (alt text zu Bildern)?
Mein Problem: Der Alt-Text wird nach 191 chars abgeschnitten, und ich vermute die colum in der pasenden table hat einfach das falsche Datenformat und das will ich ändern. #mariadb#pixelfed#fediadmin