All blog posts tagged with mysql
MySQL Sucks
There. I said it. You may disagree with me, and that's fine, but for my purposes, MySQL is a steaming pile of dog crap.
Here's my #1 problem - views. MySQL views are complete rubbish. When I create a view in PostgreSQL, and I do a query against that view, PostgreSQL knows if the tables involved have…
MySQL Database Backups with GIT
Like any good technology company, we run database backups. Being a website hosting company, these database files become monstrous - we're already well over 20GB per backup (and that's gzipped). Part of this backup process is to keep some copies for historical purposes (not simply one single backup f…
MySQL Backup Script
Just thought I'd share this Linux BASH script which we run nightly to backup our MySQL database.
The features of this script:
- it keeps a revolving list of files for each day of the week, for each week of year, and for each month. We wanted some history, but not to get carried away.
- each table is re…
The Peculiar Nature of PHP
PHP has obviously been around for a while. Not quite as long as C, but by all accounts around 1995, the same year as Ruby and Java. And yet, I find it one of the most peculiar languages with regards to how people (those core to the language itself, as well as users) have developed using such a diver…
MySQL Being "Saved"
So it seems the MySQL creator Monty Widenius has joined the "should Oracle buy Sun" fray. He doesn't care so much about the two companies as he does about the future of MySQL. He's riding the whole "keep the internet free" shtick.
However, here's my problem - if keeping MySQL free was such a major p…
Visit my Friends and Family
If you've enjoyed my site, please take a moment to visit my friends and family, many of whom have some interesting insights, and entertaining thoughts and ideas.
- Crause Family - the family website
- Peter Crause - my father
- Justin Crause - my brother
- Cencina Photomagic - great photographer
Widgets
