Migration script to make use of stored generated columns in MYSQL. https://hackernoon.com/the-secret-to-faster-json-queries-in-mysql-generated-columns #mysql
Wir nehmen die Tage eine Episode zum 30-jährigen MySQL-Jubiläum auf. Gibt es Dinge, die ihr schon immer mal über #MySQL wissen wolltet?
MoneyLion is hiring Lead Engineer (Backend)
#java #react #reactnative #springboot #api #aws #docker #kafka #kubernetes #mysql #postgresql #techlead
Kuala Lumpur, Malaysia
Full-time
MoneyLion
Job details https://jobsfordevelopers.com/jobs/lead-engineer-backend-at-moneylion-com-mar-26-2024-96ba76?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring
And again I wonder when it's smart to use MySQL and when is SQLite better...
I'm not running anything huge on my own computer and moving stuff around over machines with SQLite is a lot easier...
Do you want MySQL with the best possible performance? Then stick to version 5.6, as long as you don't mind it's been EOL for 12 years. 5.7 also has better performance than newer versions, although not as good as 5.6. Some performance regressions are just not being fixed.
https://smalldatum.blogspot.com/2025/08/sysbench-for-mysql-56-thru-94-on-small.html
^^ Veteran database performance guru, Mark Callaghan, former tech lead for MySQL at Facebook and Google, is now an independent consultant who blogs about database benchmarking.
(For my own account as a MariaDB fanboy I must add that another option could be migrating to MariaDB which is a plug-in replacement for MySQL 5.6, as MariaDB has done a better job at avoiding and fixing performance regressions.)
Got a bit panic-scared by my website's database going down this morning, with #VirtualMin not clearly telling me that it was due to MariaDB having crashed due to an out-of-memory problem, so I filed this little UX issue: https://github.com/virtualmin/virtualmin-gpl/issues/1095
…and then filed this somewhat more important issue about needing an integrated way to detect and repair crashed #MariaDB / #MySQL tables: https://github.com/virtualmin/virtualmin-gpl/issues/1096
Reason why a test migration (that took 5-6h with troubleshooting) is needed is because the production one then is done in 15 min.
PROD Mattermost now on Postgres as well.
#ChatGPT5 agrees as well :P
@MartinEscardo This is true. I'm suggesting that this is not just a computer engineering thing. I'm saying that at base, nature itself is non-binary, and we are non-binary, and we abstract things we don't understand into black and white distinctions to make them easier to understand. It's fast and efficient to ignore certain problems. There are still problems with binary logic.
Did you know that SQL is one of the few computer languages to use 3-valued logic? Databases are highly exposed to the problems of inconsistent or missing information. But we can use binary logic to simulate 3-valued logic (MySQL uses the paraconsistent logic LP by Graham Priest, but you can use that to create a fully relevant implication as in RM3, it's just a longer expression)
With Postgres now under the hood I can use the built in official AI agent. Running with gpt-5
Well it look a better part of the day and a number of trial and error (as the documentation is a bit outdated in some cases), but I got there in the end!
This was a test instance migration, and it works!
Officially now on Postgres 17.5.
Time to document it all and get some sleep as I will have to redo all this again.
Doing a test #mysql to #postgres #database migration for my #mattermost instance. No pressure…
With version 11, that will be mandatory so might as well do it now.
Nothing like running migration tools in #docker as well ;).
Let’s see how this will end up.
MariaDB 12.0 open-source RDBMS is out, fixing InnoDB and replication issues, while adding Fedora 42, RHEL 10, and Debian 13 package support.
https://linuxiac.com/mariadb-12-0-lands-with-innodb-fixes-and-expanded-platform-support/
#MOVIM 0.31 "#Kameny" has been released (#Jabber / #XMPP / #PHP / #SQL / #MariaDB / #MySQL / #PostgreSQL / #SocialNetwork / #SocialFeed / #PubSub / #E2EE / #EndToEndEncryption / #E2EEncryption / #OMEMO) https://movim.eu/
#ADOdb 5.22.10 has been released (#DatabaseAbstractionLayer / #PHP / #MariaDB / #MySQL / #PostgreSQL / #SQLite / #OracleDB / #OracleDatabase / #SQLServer / #MicrosoftSQLServer / #DB2 / #IBMDB2) https://adodb.org/
@patrickleavy Yeah doing that should be enough, but reading the docs they are specifying #MySQL as the 'only' supported version so would be better to specify it as mysql:8.4. I do run #ghost on #mariadb (due to lesser RAM) but I am anticipating some trouble for the version upgrade.
How to Install #ClusterControl on #AlmaLinux VPS This article provides a guide for how to install ClusterControl on AlmaLinux VPS.
What is ClusterControl?
ClusterControl is a robust #database management platform that simplifies deployment, management, and scaling of database clusters. If you’re using AlmaLinux VPS for your infrastructure, this guide will walk you through installing ClusterControl seamlessly. ...
Continued 
https://blog.radwebhosting.com/how-to-install-clustercontrol-on-almalinux-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #databasecluster #installguide #mysql
O’Reilly SQL and Databases eBook Bundle | Humble Bundle.
https://www.humblebundle.com/books/sql-and-databases-oreilly-books?partner=morningdew
️ 
