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
@jimcarroll#Mastodon is minimal maintenance in 2GB RAM? Something to consider. I love me some #Friendica, but it's a crash-o-matic in my low-end box, mostly from #mariadb getting axed by the "OOM-killer".
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?
Article claims #MariaDB's for-profit arm is headed for bankruptcy after a merger that the author claims was basically a hostile takeover. Fortunately, mariadb.com and the corporation don't own the crucial copyrights over the FLOSS code. Those are owned by mariadb.org and the foundation.
In the meantime, the new owners, having fired the founder (Monty, who also founded #MySQL) are now lawyering up in preparation for legions of lawsuits. Or at least, that's what the article says.