Reading and writing geospatial in CakePHP 5.1+

Feb 27, 2025 in CakePHP #cakephp #mysql

CakePHP 5.1.0 introduced support for geospatial types, but for now it's limited. Here's how you can read and write these values easily.

Forwarding MySQL from local port to remote server

Oct 18, 2023 in Servers #mysql #debian #socat

Cheapest MySQL database hosting for a hobby project?

Oct 13, 2023 in Development #mysql #oracle-cloud-infrastructure #mariadb #providers

Forcing mysqldump to _really_ skip comments

Oct 13, 2023 in Servers #mysql #mysqldump

Non-destructive duplicate removal from a MySQL table

Nov 23, 2022 in Development #mysql

Changing a MySQL/MariaDB variable in my.cnf has no effect?

Oct 1, 2022 in Development #mysql #debian #mariadb

MySQL Workbench Import/Restore: "There were no dump files in the selected folder."

Sep 25, 2021 in Development #mysql #backup #restore #mysql-workbench #phpmyadmin

Restoring a phpMyAdmin sql.zip with tables exported as separate files using MySQL Workbench