database posts

I finally moved from Sequel Pro to Sequel Ace. Sequel Pro hasn't been updated in years. It mostly worked but did have some annoying problems. During a recent OS and app reinstall, I found that Sequel Pro was no longer available on Homebrew, so I went for Sequel Ace, a fork that is still maintained. It is very similar but improved. I like it.

I had a stressful end of workday yesterday. I accidentally deleted the database on three live sites, including our most important e-commerce site, and had to scramble to restore from backups. Continue reading post "#4622"

I recently needed to sort query results to match the order of IDs passed to it for use in a WHERE … IN() clause. In MySQL, this can be done using the FIELD() function in the ORDERY BY clause. For Doctrine, which doesn't have the FIELD() function and doesn't allow functions in the ORDER BY clause, there's a little more work needed to make use of it.

I made a simple bash backup script for the newer MySQL database servers at Cogneato. Continue reading post "Simple MySQL backup script"

I've just learned that, with the MySQL command line client, one can run \s or status; and get a nice readout of status information. Continue reading post "#3009"

In PHP scripts that run queries to a MySQL database over a long period of time, the connection may time out and give a "MySQL server has gone away" error. Continue reading post "Automatically reconnect PDO when connection times out"

I recently needed to programmatically import SQL files containing database dumps into a database managed by Doctrine ORM. Continue reading post "Import SQL file in Doctrine / PDO"

I've been unhappy with the inheritance provided by PHP ORM's I've looked at. In looking for something better, I discovered that Postgres has built in inheritance, because it is an object-relational database. Continue reading post "Database inheritance: Postgres?"

This is a modification of part of a previous post. each file is stored in two d…