data posts

I have brought back the display of existing comments on this blog. When I switched away from WordPress to my own blog solution, I didn't build any display of comments on posts since I haven't had comments enabled in years and wanted to make the switch quickly. I also wasn't sure how I wanted to handle storing them, since my site data repo is public and will likely have an open license at some point. Storing quotes by others under my own license is probably fine, but I decided to mostly do summaries unless the exact quote seemed important. I did mostly do full quotes of my responses, since that's definitely my data. So I put their comments and my responses all in a single markdown file per post, in more of a prose format than normal comments are shown.

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"

Watching a streaming movie on Amazon video today, I was disappointed to find it had taken 800-900 MB. Continue reading post "#2955"

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 idea is based on my Local + Proxy Remote Hosting for Personal Site idea, but attempts to mitigate some of its problems further.

I am going to try to post something once a day for a while, either on this blog …

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