I just had to explain to our "technical" "Product Owner"
The difference between a Database Server and Database.
Now maybe im being to picky here. but shouldn't someone in charge of a product that is built around databases understand the basic functionality of Database Servers?
À cette occasion, notre collègue Christophe vous propose de passer en revue « quelques affirmations, étonnements et mensonges de divers DBAs et non-DBAs qui ont voulu restaurer une sauvegarde » 🤓
=> https://dali.bo/202403_restauration
@fosdem 2024 was once again a great opportunity to learn about #PostgreSQL and interact with the #Postgres#community. I also had the great pleasure to meet many fellow enthusiasts at the PostgreSQL Europe booth, where I was joined by friend and comrade-in-arms @tchorix and we took the opportunity to do an impromptu book signing for "PostgreSQL 16 Administration Cookbook" which we co-authored 👉 https://packt.link/BmLOz
Couldn't be prouder to announce the release of the PostgreSQL 16 Administration Cookbook! Massive thanks to my co-authors Gianni Ciolli, Boriss Mejías @tchorix, Vibhor Kumar and Simon Riggs, and Packt for a spectacular effort on a book that is bound to be a valuable resource for the #PostgreSQL community.
The scope of building a large #FOSS webservice is so large, it's impossible for one person to handle it alone. But it's also very very difficult to find competent and trustworthy people to cover the aspects you cannot. Especially DBAs!
A #DBA could be considered like the healer in a "Holy Trinity" game (Tank/Healer/DPS). It's the role everyone needs but very few enjoy doing.
If you find a competent and trustworthy DBA to help your FOSS project. They're worth their weight in gold!
Going on vacation to Italy tomorrow, with the De Bellis Antiquitates rulebook, Tony Bath's Setting up a Wargames Campaign, and the full compilation of Hyboria - The Campaign That Grew in my bag.
All of this reminded me of an article from long, long ago when I was a C# developer trying to break in to the #DBA space...and I was asking myself "What kind of #DBA do I want to be? What kind of DBA do I present myself as on my resume?"
I copied/pasted much of that article into a text file. I've searched for it online, but can no longer find it.
I suspect it was something Steve Jones wrote for SQLServerCentral(.)com.
I'm now 45 years old (as of last week) and been working in computing professionally since 1996. My first computer ran GNU/Linux and been in the #BSD and #Linux world ever since (my family was poor so I didn't get a computer until I hustled for parts to build my own and didn't have Internet service for the first 6 months, so I mostly read man pages and learned #programming languages), only recently catching up to Windows stuff as part of switching to pentesting as a career (away from #sysadmin, #coding, and #dba stuff) in 2020.
Please respond by saying what sorts of TTRPG things you're pretty likely to either talk about or respond to if you see them.
This can be a list of games (D&D! Tribe 8! Fate!) or categories (the weirdest of indie stuff! NSR! Anything PBtA!), topics (Worldbuilding! Publishing!), stuff you're making, meta-commentary (The State Of The Industry), and so on.
Then maybe share, and if the replies are building up, check them for new people.
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