I've used #MySQL before (last time was 2016, I think), but today I'm mostly onto #Postgres (and sometimes, #SQLite). I know PG is superior to MySQL is pretty much all aspect I could think of, but still, it seems that MySQL still has a quite big user base.

What's the catch? What am I missing here? Why would someone use MySQL over Postgres to build smt since Postgres [apparently] is better than MySQL in every single possible aspect?

It's a honest question. Please help me understand it – and perhaps, consider modern MySQL/MariaDB in next projects. :)

TIL: The MySQL Docker image restarts the server after the initial data import, which means if you have enabled the query log using an SQL query it gets reset to being disabled.

If you enable the query log in the config file, this logs every query of the import.

So you have to:

1. Enable in config.
2. Disable using query before import.
3. When the server is restarted, the query log will be enabled.

Better experience and fast, secure way to create a connection with MariaDB.

// Config.php

$mariadb = ini_get('pdo_mysql.default_socket');

$pdo = new PDO("mysql:unix_socket=$mariadb;dbname=test", 'root', '');

if($pdo){
echo "Database connection success!";
}

#Datatables ist schon ein geiles #Javascript Framework zur Darstellung von Tabellen. Zusammen mit #PHP, #MySQL, #jQuery und #Ajax lassen sich da richtig gute Anwendungen bauen.

Want smoother user experience in your PHP apps? Learn how I implement MySQL pagination without the bloat. Clean, scalable, and dev-friendly.
https://mikelopez.com/blog/1118
#PHP #MySQL #DevLife #Pagination #WebDevelopment #BasicPHP

Nexus joins data across systems and you can process the join anywhere.

https://coffingdw.com/1000-techniques-to-join-data-across-systems/

Nexus can join one hundred tables from one hundred different systems in a single query.

https://coffingdw.com/2023-a-100-table-join-across-100-systems/

Nexus builds a visualization dashboard for every user on every system for every answer set.

Join data across clouds in a single query as easily as if all tables were on a single system.

Hey! I’m Yasser Elgammal a backend developer passionate about building clean, scalable solutions with Laravel

I share code, ideas, and open-source projects.

Check out my work on GitHub and let’s connect!
https://github.com/YasserElgammal

#github #php #laravel #backend
#mysql

Have you seen the syntax of INNER JOIN? Of course! What about NATURAL INNER JOIN?

https://coffingdw.com/new-to-sql-is-the-keyword-natural-join/

https://coffingdw.com/date-functions-date-formats-and-timestamp-formats-for-all-databases-45-blogs-in-one/

Aktuell laufen in der Oracle University zwei Event an denen man kostenlos sein Wissen rund um Cloud, Datenbanken, DevOps aufbessern kann. Außerdem kann man kostenlose Voucher für Zertifizierungen erhalten.

Zum einen veranstaltet #Oracle erneut das Race To Certification-Event (bis Ende Oktober) und zum anderen findet im Rahmen des 30. Jubiläums von #MySQL ein ähnliches Event mit Kursen und Zertifikaten statt (bis Ende Juli)

https://education.oracle.com/race-to-certification-2025

https://education.oracle.com/mysql-promo

You will never forget the first time you saw a 30-table join spanning 30 systems in a single query.

https://coffingdw.com/30-table-join-across-30-different-systems-shocks-the-it-world/

History : Ericsson Review article about #NdbCluster development at Ericsson. Starts at page 167 (pdf page 179) 1997 volume 4
#MySQL #DistributedSQL

https://www.ericsson.com/4ac5c3/assets/local/about-ericsson/ericsson-history/lme-review/documents/da2011-35598-ericsson_review_vol_74_1997.pdf

TIL: MySQL has a BIT(M) data type, which can store M bits of data. However, if you try to be 'clever' and use it as a boolean column, you can't insert something like 0, you have to explicitly convert it with b'0'.

I don't know why anyone would use BIT(1) (as the codebase I'm working on today does), because it still consumes 1 byte, which is the same as TINYINT and that doesn't require conversions.

(before anyone slags off MySQL, other database engines support BIT as well)

SoundHound is hiring Senior Software Engineer

#java #javascript #typescript #react #springframework #api #hibernate #aws #azure #cicd #docker #gcp #jwt #kafka #kubernetes #mysql #redis #seniorengineer
Bengaluru, India
Full-time
SoundHound

Job details https://jobsfordevelopers.com/jobs/senior-software-engineer-at-soundhound-com-jun-9-2025-bb0adc?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring

Don’t miss tomorrow’s webinar on what’s new in #MariaDB 11.8 LTS—features, improvements, and why it matters for your apps.

Register now and join us live: https://go.mariadb.com/25Q2-WBN-GLBL-Community11.8-2025-06-25_Registration-LP.html