News for hackers. Stuff that matters.
Re:In MySQL, use “utf8mb4” instead of “utf8” (2016) by timw4mail on Wednesday January 12, 2022 @01:23PM (#29910836)
What's that mean, non-starter in the PHP world? Postgres is well supported by frameworks and libraries in PHP, not to mention PHP itself.
Re:In MySQL, use “utf8mb4” instead of “utf8” (2016) by PrimeDirective on Thursday January 13, 2022 @03:30AM (#29918169)
For one, it's out of reach for lots of folks who use shared hosting services, where there's a managed LAMP stack. It's rare if they have Postgres. If you use AWS, of course, everything is up to you. There's also a connection pooling and different startup for MySQL/Mariadb vs Postgres. PHP engine generates the page and closes itself and connections. Postgres assumes you are more persistent. Also, there's a difference in how GROUP BY works in MySQL/Mariadb vs Postgres, and wrapping your head around it, after using it the MySQL way for years, can take time. So not a drop-in replacement.
Re:In MySQL, use “utf8mb4” instead of “utf8” (2016) by isotopp on Friday January 14, 2022 @01:41PM (#29938323)
ONLY_FULL_GROUP_BY is the default in MySQL since 5.7.5.