All posts tagged databases

Four simple steps to optimize WordPress

A couple of years ago, I stood up a WordPress server. I made no effort to tune it, let alone turbocharge it, which is a decision I later came to regret. If your site gets more than a few hundred hits per day, you need to tune it. If you want to get more than [...]

Long passwords aren’t necessarily good passwords

Well, crud. Not all long passwords are good passwords. I’ve suspected for a long time that street addresses aren’t good to use–the formula is too simple–but now it seems that even mashing together a sentence into a long password doesn’t work. (That isn’t something I do often, but I’ve done it at least once or [...]

And speaking of SSDs, here’s how Oracle performs on an SSD

Andy Black is a former colleague and an Oracle DBA. Several times in the last few years, I ran into problems where I wished he wasn’t a former colleague, because my team got into some jams that I was pretty sure he could have fixed. (And let’s not even mention the time I got blackmailed [...]

Easier deep Firefox SQL optimization

Last year I examined ways to optimize Firefox’s SQLite databases. I’ve since found I like it better when I just put the Firefox profile in a ramdisk, but that may not be an option in all cases. If you don’t want to go the latter route and would like to avoid the command line jockeying, [...]

Take back some privacy

The creepy Girls Near Me smartphone app is drawing some much-needed attention at data brokers, companies that aggregate information about you from public information and information you provide to marketers. I even found an article that talks about how to opt out from selected brokers. I recommend you do. Open up a temporary Yahoo or [...]

How to start over with MySQL in Debian

I got my new 64-bit web server up and running today. Now the main task that remains is to get my data moved over to it. I talked myself into going with an Apache setup, since one program I want to run (Webtrees) is designed for Apache and its search engine optimization seems to work [...]

HP open-sourcing Web OS is a gutsy move

HP announced this week that it’s not going to sell Web OS–the operating system it bought the remnants of Palm to get–and plans to open-source the platform, as well as re-introduce tablets based on it sometime in the distant future. The move isn’t guaranteed to work, but I think it’s a shrewd move.

Deep Firefox SQL optimization

I was looking deeper into Firefox optimization, and I found Adventures in Firefox-places.sqlite. It’s a pretty intense analysis that goes beyond the usual simple, in-browser SQL vacuum that I’ve mentioned in the past. It was written with Mac OS X and Linux in mind, which is fine, but if you run Windows, you might want [...]

Should journalists hack?

I experienced an interesting collection of contrasts going to journalism school in the mid 1990s. Inside the same building, we had investigative journalists who specialized in advanced use of databases and stodgy editors who missed the days of manual typewriters and wore technological ignorance as a badge of honor. And yet, there were textbooks that [...]

Make Firefox run like new

This is an unbelievable trick. If you’ve been running Firefox for a long time, it gets a lot more sluggish. Here’s how to optimize its databases and give it back its youthful vigor.

Switch to our mobile site