Over on Two simple ways to version control your MariaDB schema changes I learned a neat hack you can use to check for database schema revisions by reporting off the binlog.
The example command given was:
$ mysqlbinlog --no-defaults -R -u foo -p -d foodb -h db.home.arpa mysqld-bin.000001 > foodb.txt
My copy of MySQL Workbench doesn’t play 100% nice with my MariaDB install, so I checked out the Database Workbench software recommended by MariaDB and in the end I downloaded a trial version. It runs okay under Wine, so gonna check it out.
Here’s some good info for configuring ODBC for MariaDB on Ubuntu for use from LibreOffice Base: LibreOffice Base and MariaDB. The same article also has some info about how to use ENGINE=CONNECT for importing JSON from web services.
I had this problem which is explained in greater depth over here.
Here’s some good documentation on PHP prepared statements and stored procedures including how to call stored procedures with output parameters.
You can disable foreign key checks with
SET foreign_key_checks = 0;
And you can disable unique index checks with
SET unique_checks = 0;
Today I discovered sequences in MariaDB. Gonna take them for a spin!