Post AYlTLKSSsp46LGrd0i by feld@bikeshed.party
(DIR) More posts by feld@bikeshed.party
(DIR) Post #AYjNt5LTswHW8SH3Pk by finlaydag33k@social.linux.pizza
2023-08-14T19:23:50Z
0 likes, 1 repeats
- Mastodon: PostgreSQL- MissKey/Firefish: PostgreSQL- Pleroma: PostgreSQL- GoToSocial: PostgreSQLIs there a particular reason why PostgreSQL is so popular among Fediverse?I'm not against PostgreSQL or anything but I'm just wondering why there's no MySQL/MariaDB (which I'm more familiar with).
(DIR) Post #AYjOTiSlvMVBsi9RZY by rick@a.n0id.space
2023-08-14T19:28:38.115346Z
0 likes, 0 repeats
@finlaydag33k i like it quite much :p also afaik pleroma/akkoma stores raw ap json in the DB
(DIR) Post #AYjOTjIsncBaUKX3nU by finlaydag33k@social.linux.pizza
2023-08-14T19:30:25Z
0 likes, 0 repeats
@rick Yea but I was mainly wondering if there was a specific reason they chose to use PostgreSQL over say MariaDB or something.I mean, it seems to be popular for it, so there must be a reason right?
(DIR) Post #AYjP3coMPmQAmHN7Gi by rick@a.n0id.space
2023-08-14T19:35:45.259156Z
0 likes, 0 repeats
@finlaydag33k well, my point was that postgres supports json. afaik mariadb doesn't do that. well there are other json databases like mongodb.. but yeah.. :blobcatshrug: i try to use postgres everywhere i can, cause i know it the best.. maybe sth like that was the initial reason for the maintainers too :renge_shrug:
(DIR) Post #AYjP3ddlKfXPLhQAO8 by finlaydag33k@social.linux.pizza
2023-08-14T19:36:57Z
0 likes, 0 repeats
@rick OHHHHH, JSON like that (Document store).I thought you just meant slapping JSON in a field and call it a day xD
(DIR) Post #AYjRdWvDzKdYqUpaNM by bady@mastodon.sdf.org
2023-08-14T20:05:23Z
0 likes, 0 repeats
@finlaydag33k https://mastodon.social/@dansup/110876935341269494
(DIR) Post #AYjSB6zot1OuHezeam by finlaydag33k@social.linux.pizza
2023-08-14T20:11:56Z
0 likes, 0 repeats
@bady Nice.Hopefully more software can get MySQL/MariaDB support...I'm just not comfortable enough with PostgreSQL to run something "in production" with it (it's already a wonder my Matrix server didn't die yet).
(DIR) Post #AYjT8FHdiXvb4XWeKu by selea@social.linux.pizza
2023-08-14T20:22:29Z
1 likes, 0 repeats
@finlaydag33k The reason is deadlocks.If you write something to a table in mariadb/MySQL - the table locks and renders it unable to be either read of written to for a short time.
(DIR) Post #AYjTYmvvEOa2xq1Y0W by selea@social.linux.pizza
2023-08-14T20:27:04Z
0 likes, 0 repeats
@finlaydag33k @bady Pixelfed use MySQL I think
(DIR) Post #AYjUsxqmS2pMZJnsrA by zem@conesphere.social
2023-08-14T20:42:13Z
0 likes, 0 repeats
@finlaydag33kThe question should be: why is there so many mysql out there. but they are both great databases although i find podtgresql easier to operate.@selea
(DIR) Post #AYjUupcxzihde4EUQi by datamaps@social.linux.pizza
2023-08-14T20:42:30Z
0 likes, 0 repeats
@selea @finlaydag33k I think that's only true if you use the MyISAM engine, InnoDB tables support simultaneous write access by multiple sessions
(DIR) Post #AYjUy79xGci2tAECX2 by portaloffreedom@social.linux.pizza
2023-08-14T20:43:13Z
0 likes, 0 repeats
@finlaydag33kPersonally I always choose to develop for postgres because it's more compliant to sql and better documented. I really trust it more. MySQL gives me LAMP vibe, which I just don't like.But I don't develop any fediverse software so I'm not really sure what reasons they might have.@selea
(DIR) Post #AYjUyKm0eRsF6x8H9U by finlaydag33k@social.linux.pizza
2023-08-14T20:43:10Z
0 likes, 0 repeats
@gme PgAdmin reminds me of PHPMyAdmin.Although, my tool of choice (DbGate) does seem to support PostgreSQL as well so that should do.@bady
(DIR) Post #AYjV9aflsVchbja9Kq by finlaydag33k@social.linux.pizza
2023-08-14T20:45:17Z
0 likes, 0 repeats
@portaloffreedom Yea, that's exactly why I'm more of a MySQL/MariaDB guy... Most of the stuff I do and have historically done involves a LNMP stack (I mainly use Nginx instead of Apache2).It's where most of my knowledge lies really.@selea
(DIR) Post #AYjVKG0B4XhWgRDHPc by finlaydag33k@social.linux.pizza
2023-08-14T20:47:12Z
0 likes, 0 repeats
@zem A lot of beginners start with WAMP/LAMP/LNMP stacks, at least, from "my era" (when PHP was "the go-to back-end language").So I think this heavily contributed to that.It's why I prefer MySQL/MariaDB, mainly because I'm used to it and know my way around it.@selea
(DIR) Post #AYjVlleBWXmgeG2nz6 by finlaydag33k@social.linux.pizza
2023-08-14T20:52:10Z
0 likes, 0 repeats
@datamaps Mostly true.InnoDB locks the row where MyISAM locks the entire table.The other part of the story is that MyISAM generally performs a lotbetter when you mainly do reads (OLAP) where InnoDB does better with writes (OLTP).I generally use MyISAM when I need to handle "historical data" (like analytical stuff - altho nowadays, I tend to use Apache Druid for this instead) and InnoDB when I need to handle "operational data" (eg. users n such).@selea
(DIR) Post #AYjcSV2hjac1KMGxYu by feld@bikeshed.party
2023-08-14T22:06:06.687043Z
1 likes, 0 repeats
better JSON support, and it's a database that doesn't lose your datasource: a sysadmin who has cried many long nights over MySQL corrupting itself
(DIR) Post #AYjeS4EHcouG4lbsiu by kirrus@social.theindiestone.com
2023-08-14T22:29:26Z
0 likes, 0 repeats
@finlaydag33k in my experience, devs prefer Postgres for features. Ops prefer MySQL/MariaDB for maintainability and uptime. Posgres is a pain to maintain, and requires an (often overlooked) outage to upgrade
(DIR) Post #AYjiaHgBtwopvLpy76 by prettygood@socially.drinkingatmy.computer
2023-08-14T23:15:46.383744Z
0 likes, 0 repeats
@feld @finlaydag33k yeah I'm with field here. The question you should be asking is why other applications DON'T prefer postgres
(DIR) Post #AYjicRw6jpAgJWJZWi by prettygood@socially.drinkingatmy.computer
2023-08-14T23:16:10.496777Z
0 likes, 0 repeats
@feld @finlaydag33k congrats feld you're now field
(DIR) Post #AYjikRKKt3fik0SPVw by feld@bikeshed.party
2023-08-14T23:17:25.960808Z
1 likes, 0 repeats
I get this more often than you'd think!
(DIR) Post #AYjjHS1fJG1qSsSu6i by prettygood@socially.drinkingatmy.computer
2023-08-14T23:23:34.999313Z
0 likes, 0 repeats
@feld phone posters tattling on ourselves
(DIR) Post #AYkABFex4Whv8V6qmG by baconicsynergy@social.linux.pizza
2023-08-15T04:24:59Z
0 likes, 0 repeats
@finlaydag33k *takes notes*
(DIR) Post #AYkDSN4D5IS4tYmKzg by selea@social.linux.pizza
2023-08-15T05:01:34Z
0 likes, 0 repeats
@datamaps @finlaydag33k Does it really now?I remember having real issues with deadlocks even on innodb tables two-three years back
(DIR) Post #AYkDXxOjQySF1P2c1A by arjen@idf.social
2023-08-14T21:21:46Z
0 likes, 0 repeats
@datamaps @selea @finlaydag33k yes, but with postgresql this does not require configuration options you might not know. It's a proper DBMS out of the box. So, really, it's the simpler choice of the two!
(DIR) Post #AYkDXyLvsroFz0jtIG by selea@social.linux.pizza
2023-08-15T05:02:36Z
0 likes, 0 repeats
@arjen @datamaps @finlaydag33k Thanks for clarifying how it works in this thread everyone :)
(DIR) Post #AYkDwXzz0LmnUGBsfI by finlaydag33k@social.linux.pizza
2023-08-15T05:07:09Z
0 likes, 0 repeats
@feld tbf, can't say I've ever seen a MySQL install corrupt itself over my 12 years of use. :gnulightened:
(DIR) Post #AYkE04Uge1sV8cETmy by finlaydag33k@social.linux.pizza
2023-08-15T05:07:47Z
0 likes, 0 repeats
@kirrus That makes a lot of sense then.The outtage is a pain tho D:
(DIR) Post #AYkTRWYPvMivIQWf7A by ellenor2000@mastodon.top
2023-08-15T08:00:47Z
0 likes, 0 repeats
@finlaydag33k They want to punish admins. That's why.
(DIR) Post #AYkpb5bTBBLDb5v5gO by feld@bikeshed.party
2023-08-15T12:08:25.657514Z
0 likes, 0 repeats
Used to happen every time you ran out of disk space or had an unexpected shutdown / crash, and then the recovery tools required 2x disk to rebuild it :sweatdrop:
(DIR) Post #AYlTELH9RfjaqnEylE by finlaydag33k@social.linux.pizza
2023-08-15T19:33:08Z
0 likes, 0 repeats
@feld r.i.p.Can't say I've ever had a project that ate away that much disk space either.Yea ok, one time I had a rainbow table creation project (basically distributed rainbow table computing).That _did_ kinda chew at my storage.
(DIR) Post #AYlTLKSSsp46LGrd0i by feld@bikeshed.party
2023-08-15T19:33:57.212126Z
0 likes, 0 repeats
You've never had customer VMs with like 50GB of space and they're always sitting at 45GB used but they don't want to pay for more storage? 🥲
(DIR) Post #AYlVi9Wnt2NZ0nu85Q by finlaydag33k@social.linux.pizza
2023-08-15T20:00:57Z
1 likes, 0 repeats
@feld I am glad that outside some meetings where I practically could take a nap, the amount of customers I had to deal with was extremely low. (most of my work involved internal matters).
(DIR) Post #AYlhJAXYBa2QMS6gro by dd@social.linux.pizza
2023-08-15T22:10:53Z
0 likes, 0 repeats
@finlaydag33k fwiw #streams fedi server uses mariadb as default or can run on postgresql.https://codeberg.org/streams/streams