governa, to php
@governa@fosstodon.org avatar
linuxmagazine, to PostgreSQL
@linuxmagazine@fosstodon.org avatar

From the Linux Update newsletter: Open source database management systems offer flexibility and lower costs while avoiding vendor lock-in, but how do you choose the one that's right for your organization? https://www.linux-magazine.com/Issues/2024/282/Data-Management

outofcontrol, to random
@outofcontrol@phpc.social avatar

After using TablePlus for around 3 years, is this still a good app to use? Are there newer better alternatives.

It’s renewal time and I’d like to check-in on other apps before upgrading.

Feedback welcome.

#tableplus #mysql #mariadb

oz, to rubyonrails
@oz@mastodonsweden.se avatar

My old man trait is that I think SQL is easier to read and work with than arel, active record et al. Unless you're making libraries, just write the damn query.

fossasia, (edited ) to Software
@fossasia@floss.social avatar

Daniel Black, Chief Innovation Officer of Foundation will share about “Benefits of making containers a core part of a project" at “FOSSASIASummit2024

https://eventyay.com/e/55d2a466/speakers

alyx, to ghost
@alyx@3615.computer avatar

Thanks to @jemal I learned that MariaDB is not actually officially supported by Ghost: https://forum.ghost.org/t/when-will-mysql-8-be-mandated-which-ver/29228/2

So if you made the same stupid choice as me, look into switching before it becomes an issue.

jemal, to ubuntu
@jemal@jemal.contact avatar

Does anyone have tips for installing alongside and existing server in 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.

pwaring, to azure
@pwaring@fosstodon.org avatar

TIL: Azure is dropping support for their MariaDB service, you'll have to use MySQL instead. AWS RDS still offers MariaDB but only up to 10.6, which is far behind the current stable releases of 10.11 and 11.3.

https://learn.microsoft.com/en-us/azure/mariadb/whats-happening-to-mariadb

StefanMuenz, to random German
@StefanMuenz@vivaldi.net avatar

Michael Widenius hat zwei Töchter: My und Maria. Nach der ersten nannte er sein erstes entwickeltes Datenbanksystem: , und nach der zweiten das zweite: . Letzteres ist gerade in finanziellen Schwierigkeiten. Ein Investor bietet 37 Millionen US-Dollar für die Übernahme. Wer das DBMS nutzt, sollte sich eventuell dafür interessieren, wie es da weitergeht.
https://www.heise.de/news/Unverbindliches-Uebernahmeangebot-fuer-das-Datenbankunternehmen-MariaDB-9632821.html

jbzfn, to opensource
@jbzfn@mastodon.social avatar

💸 Struggling database company MariaDB could be taken private in $37M deal
— TechCrunch

"The commercial entity behind MariaDB raised some $125 million in venture funding through the years to develop premium features and services on top of the core project, eventually going public in December 2022 via a special purpose acquisition company (SPAC)."

https://techcrunch.com/2024/02/19/struggling-database-company-mariadb-could-be-taken-private-in-a-37m-deal

Cheatha, to random German
@Cheatha@chaos.social avatar

An die Passagiere von : ihr Zug endet bald! Bitte steigen sie an der nächstmöglichen Station aus, um nicht auf dem Abstellgleis zu laden: https://www.heise.de/news/Unverbindliches-Uebernahmeangebot-fuer-das-Datenbankunternehmen-MariaDB-9632821.html

dustinrue, to Kubernetes
@dustinrue@chateaude.luxe avatar

Anyone running on , by chance?

darkghosthunter, to opensource
@darkghosthunter@mastodon.social avatar

Honestly, there was a time where MariaDB was relevant, and that was when PostgreSQL was weird, MS SQL was costly, and MySQL was on the verge of being proprietary.

Today, MS SQL has low entrance barriers, MySQL still works, and PostgreSQL is versatile and rock solid.

What does MariaDB offers that other don’t?

https://techcrunch.com/2024/02/19/struggling-database-company-mariadb-could-be-taken-private-in-a-37m-deal/

okpierre, to Software
@okpierre@mastodon.social avatar

Mariadb (the open source MySQL alternative) might be taken over. Deadline for that decision is March 29

zwovierzwo, to helpers German

Gibt es eine Anleitung wie man eine instanz kann.
Aktuell hat meine Datenbank ca. 18 GB und der Server kommt an die Grenzen.

wobei ich mich frage was da alles in der DB steht 😲
Allein schon die Abfrage auf die 40 Mio Datensätze bringt die DB und den Server ins schwitzen.

nick,
@nick@norden.social avatar

@Hiker

Ist es oder ?

Zumindest bei sollte auch via ein funktionieren...

@feb @zwovierzwo

hyc, to random
@hyc@mastodon.social avatar

There was a paper published in 2022 that was highly critical of using in a database management system. I wrote a lot about it on twitter back then, but have collected it all into a blog post now. tl;dr the paper is full of crap.
https://www.symas.com/post/are-you-sure-you-want-to-use-mmap-in-your-dbms

hyc, (edited )
@hyc@mastodon.social avatar

The reliability studies are particularly damning, they show /'s loses the entire database after a system crash on every workload tested. https://lists.openldap.org/hyperkitty/list/openldap-devel@openldap.org/message/K5XMXFFGHQOWKB6G2UGHWHW5WVH7X77C/

(Note that they claimed to have found 1 flaw in that occurred in 0.05% of their test runs, but it was actually a bug in the ext3 fs driver. One that had been fixed in Linux 2+ years before they began their research. In fact LMDB's reliability is flawless.) LMDB is the only DB that is perfectly crash-proof.

andre, to Pixelfed German
@andre@layer8.space avatar

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.

bogo, to random
@bogo@hapyyr.com avatar

the black vodka at the is worrh trying.

archer72, to random
@archer72@mastodon.sdf.org avatar

MariaDB event in what appears to be FOSDEM. I think this is FOSDEM. Is it concerning when Instagram calls it a fringe event?

CenturyAvocado, to random
@CenturyAvocado@fosstodon.org avatar

Why does / seem to ship in a really inefficient default config where a few concurrent queries of moderate tables (7,000 rows) brings it to its knees. (I never have to do such performance tuning on MSSQL.)

neustradamus, to wordpress
@neustradamus@mastodon.social avatar
softmetz, to helpers

@helpers Since version 2023.12 loading of my personal posts (the house icon) is very slow compared to all other feeds. Do others encounter that kind of behaviour?

softmetz,

I now run with

--optimizer-use-condition-selectivity=1 --optimizer-switch='rowid_filter=off' --innodb-buffer-pool-size=6G --query-cache-size=64M --max-heap-table-size=64M --tmp-table-size=64M

That helps a lot overall, but the personal page is still about 8 to 10 times slower than everything else.

hellosct1, to random French
@hellosct1@mamot.fr avatar

Comme en 2023, penser à la du dans la avec . N'attendez pas le podcast, voici les slides réalisés 20 Programmez avec Sebastien Giraud @mariadb @mariadb @lemug_fr https://speakerdeck.com/hellosct1/le-sql-dans-la-cybersecurite-avec-mariadb

natty, to random
@natty@astolfo.social avatar

Wait, if I have random database IDs

I can just do cursor pagination without any worries, right, since I can sort by created_at

gabboman,

@natty also check your indexes. please tell me its not mariadb

-sucks-a-lot -told-me-yes-the-index-is-there -out-that-if-failed-SILENTLY -figured-this-out-when-testing-wafrn-in-mysql #

jay, to web
@jay@mastodon.gamedev.place avatar

❔ Referring to the World Wide Web, do you capitalize the words "Internet" & "Web" when you use them in a sentence?

I was doing research today & noticed the AP Stylebook changed them to non-capitalized words in 2016 (See Wired article: https://www.wired.com/2016/04/ap-finally-realizes-2016-will-let-us-stop-capitalizing-internet). I've been capitalizing these words since the 90's. To me, it seems like they should be proper nouns. What's your take on the subject?

  • All
  • Subscribed
  • Moderated
  • Favorites
  • Leos
  • mdbf
  • Youngstown
  • ngwrru68w68
  • ethstaker
  • slotface
  • PowerRangers
  • hgfsjryuu7
  • khanakhh
  • kavyap
  • tsrsr
  • InstantRegret
  • DreamBathrooms
  • cubers
  • tester
  • magazineikmin
  • rosin
  • tacticalgear
  • thenastyranch
  • Durango
  • osvaldo12
  • vwfavf
  • modclub
  • everett
  • GTA5RPClips
  • cisconetworking
  • normalnudes
  • anitta
  • All magazines