You are currently browsing the tag archive for the 'mysql' tag.
I’m too lazy to build from source if there’s not a good reason, and for running MySQL on OS X, I’ve yet to come across a good reason. So, I just use the MySQL Community downloads. Over the weekend I upgraded from 5.0.37 to the latest 5.1 download, because I was hard up against a MySQL bug that was fixed in later builds.
Unfortunately, while just running the installer for 5.1 worked great, it pointed the new server at a brand new set of databases - orphaning the couple of dozen databases I was working with. This was Not Good. The fix comes in two parts.
First, create /etc/my.cnf, with a single entry pointing to the old database files:
[mysqld]
datadir=/usr/local/mysql-5.0.37-osx10.4-i686/data
Second, tell MySQL to upgrade the files:
sudo mysql_upgrade -u root
So far October is shaping up to be a pretty interesting month.
- GitX - A gitk clone for OS X. Looks nice.
- Testing Fragment Caching - How to do it in Rails.
- ExtSQL - MySQL and PostgreSQL fork that adds database activity auditing and statistics.
- Simple Ruby on Rails Full Text Search Using Xapian - One more full-text search engine that I hadn’t run across before.
- Helpify, the Omni Help Emitter - Tool to build Helpbook files from OmniOutliner documents.
I think the ActiveRecord Associations Guide I wrote may actually be finished.
- Dynamic Rails Error Help - Making the default validation messages more useful with a bit of javascript.
- Exceptional - This online error-tracker for Rails apps is now in open beta.
- Is Your Rails Application Safe? - If you’re inadvertently allowing mass assignment, probably not.
- MysqlTableSyncer - Command-line tool to synch up two MySQL tables.
- turl - My contribution to a little scripting fest on Twitter yesterday. If you have FF3 + Ubiquity, you can use “turl <userid>” to go straight to a Twitter user’s web site.
This is probably a good time to mention that I’ve done a bunch more cleanup on the google_analytics plugin.
- Zero to Production in 15 Minutes - Step by step guide to deploying a Rails application on JRuby.
- Comparing PHP to Ruby on Rails - A relatively even-handed look from the Less Accounting guys.
- daemon_controller: a library for robust daemon management - Another tool from the team behind Phusion Passenger, aimed at better coordinating daemon process management for production.
- Firebug 1.2 Released - The announcement, with a good summary of what’s new.
- What’s Hot on GitHub - A roundup from Ruby Inside.
- Mack 0.7.0 - Another of the Ruby web frameworks marches along.
- GenerateData.com - Tool for quickly building reasonable test data. 200 rows for free, after that you can clone the site or pay for an account.
- MySQL Tasks - Plugin to backup, restore, and more as Rake tasks.
Thanks to the FiveRuns folks for featuring me in their TakeFive interview series, and welcome to new readers.
- Persistent Django on Amazon EC2 and EBS - The Easy Way - Detailed instructions. With EBS, AWS is reaching some sort of tipping point.
- How to Fix your Rails Helpers - Some suggestions on refactoring.
- WICE Assignment Lists - Multi-select listbox interface for HABTM relations in Rails.
- Scout Checks in on Passenger - I’ve been looking for a Passenger-aware Rails monitoring solution. Not sure I’m ready to pay for Scout, though. (via RubyFlow)
- rspec_validations_expectations gem released - Check that your models contain the validations you want, without hitting the database to test Rails-generated code.
- DoS Vulnerability in REXML - Time to patch your Rails applications.
- Ruby Amazon E-Commerce REST Service API (amazon-ecs) - I used this to hook up some book stuff on my slowly-rebuilding personal site. It worked well.
- Maatkit - A batch of low-level MySQL tools.
- Everyday git With 20 Commands or So - The basics, though you don’t even need to memorize this much to get started.
- ZiYa - Spiffy SWF-based charting gem. Now at version 2.
I need to get some MySQL ETL going to build a datamart. Looks like I can choose from Clover.ETL, Enhydra Octopus, or Apatar. Anyone used any of those?
- GitHub and TextMate Unite - Another TextMate bundle from Dr. Nic.
- 21 Ruby Tricks You Should Be Using in Your Own Code - Some medium to advanced idioms from Peter Cooper.
- SyncSql - SAAS site to synchronize a pair of MySQL databases.
I find that I’m not in any particular hurry to upgrade to WordPress 2.5.
- Deploying Rails Applications on Mac OS X Leopard - Another article from the Apple Developer Connection.
- MySQL Workbench - Visual database design tool for MySQL, including the ability to reverse-engineer a schema to a diagram. Alas, Windows/.NET only at the moment.
- StrokeDB - Embeddable distributable document database written in Ruby.
- Exciting Times in Rails Land - A rundown on what’s coming in 2.1.
- Rails CHM Documentation - Another version of the docs for 2.0.2 in downloadable form.
I’m hoping some renewed energy and inspiration comes out of somewhere today, because I sure didn’t have any this weekend.
- Merb Supports rSpec Text Stories - Merb is reaching a tipping point very quickly, I think.
- The Maria engine is released - A new plug-in storage engine for MySQL.
- MultiRails 0.0.5 - A way to test your Rails code in multiple versions of Rails. Most useful to plugin authors, I think.
- Simpler than dirt: RESTful Dynamic CSS - Technique for having CSS that depends on the details of the current model instance. Check out the comments for some other alternatives.
- Write Only Ruby - Jay Fields takes DRY to its logical and absurd conclusion.
As I ease into the weekend I’m contemplating whether I can cram in a bit more work each day. I think not, but there is just so much new stuff to learn…
- Skitch - Fun little graphics and photo-sharing app for the Mac that’s just gone into public beta.
- Navicat 7.1.0 - My tool of choice for MySQL on OS X has just had another little version bump.
Had a great deal of fun the last couple of days figuring out how to deploy a Rails site to a client’s client’s xserve.
- Testing in Rails: Part 7 - ActiveRecord Relationships - More from Null is Love.
- SiteUptime - Yet another online website monitoring service. There are too many of these darned things.
- Auto-populate socket value in rails database.yml using TextMate snippet - Dang, how much time did I waste trying to figure out which socket various mysql instances were running on before I found this?
I spent much of yesterday doing an archive & install on OS X 10.5 on my main dev box, then reinstalling all the gems I use. Took a while to get everything set up, but it was worth it to not have two installs of ruby and two battling sets of gems. I think.
- Rails 2.0.2: Some new defaults and a few fixes - Here’s the official announcement of yesterday’s minor Rails release.
- Rails 2.0.2 released, so what’s new? - Another take on the new features.
- Sqliteman - With Sqlite3 being suddenly the default Rails database (as of Rails 2.0.2), I spent some time looking around for Sqllite GUIs that work under OS X. (Yeah, I’m a wimp that way). This one has the advantage of being free, though it’s not real well-organized and has that Qt look to it.
- RazorSQL - Commercial database query tool that claims Sqlite compatibility via JDBC. Haven’t tried it.
- SQLite Manager 0.2.11 - Sqlite database tool implemented as a Firefox add-on. Actually not bad.
- What’s Coming in Instant Rails 2.0 and Beyond - The Road Map - Plans from the new project maintainer.
- Installing ruby mysql gem in OSX 10.5 - I decided I could do without building everything from source this time around. MySQL was the trickiest to get cooking from a download & gem install.
- Ruport 1.4 Preview Release - If you’re using Ruport for reporting you probably want to have a look at this.
- RSpec Textmate Bundle errors - I had a good deal of trouble getting RSpec to work correctly within TextMate. This thread describes the symptom, but the fixes there did not work for me. Ultimately I had to checkout the RSpec trunk svn, build that, and symlink the resulting TextMate bundle in to make sure everything was synched.
- Setting up autotest to use Growl - A nice little extra if you’re doing continuous testing.
- Bazaar - Distributed version control system with an easy migration path from subversion.
I’ve actually spent a couple of days doing paid work on a Rails application. I feel all accomplished and stuff. Of course two thirds of the time has been off the clock as I scurry around researching things, but it’s a start.
- Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ - I hit this moving an Edge Rails based application from development on a Mac to production on a Ubuntu box. The answer proved to be going into database.yml and fixing the production path to mysqld.sock, which Ubuntu seems to put in a different place for some obscure reason.
- Missing ActionController::Base::DEPRECATED_INSTANCE_VARIABLES - Another minor bobble I ran into moving from development to production in the same situation. The fix was to install libopenssl-ruby1.8. Not that I have the faintest idea why.
- How To Use Multiple Submit Buttons on a Form with Rails - I needed to know this. Fortunately, it’s simple.
- SQL DSL - A library for creating SQL statements from Ruby code. Not quite what I need at the moment, but worth bookmarking for the future.
- Sample Rails App Branch: With SSL - Reference code for adding SSL to a Rails app.
- ActsAsPartitionable - Another approach to bringing enterprise-level database partitioning to Rails.
Yeah, I’ve been MIA for a few days. Life has been pretty hectic. Here are a few liks to make up for that.
- MySQL Interface to Amazon S3 - Bleeding edge but intriguing. (via dzone)
- The Caboose Sample Rails Application v3 - A template application to get you started with some better practices.
- Psst - Beta testers wanted for the next version of CSSEdit.
- PHP.net style documentation for Rails - Rails API docs with examples, though there are still plenty of APIs that need examples. (via dzone)
- MOle Plugin - Inspect The Rail - Real time event monitoring for Rails apps. (via Ruby Inside)
Lightning Admin for Postgresql and MySQL gives you a tabbed workspace for two of the major open source databases. Looks interesting, and $19.99 is a reasonable price, but I’m trying not to install any more Windows-only applications these days.
This morning I had to hunt down Copying a MySQL Database From One Machine to Another in the course of moving a Rails app from a development server to a production server, as I didn’t feel like re-entering a bunch of data (and I hadn’t used data migrations to put the data in the database in the first place).
This just goes to remind me of two things about this career transition:
- There are a zillion things that I know how to do in the Microsoft universe (like copying databases from one server to another) that I need to relearn as I move sideways to a world of other software. This is a cost above and beyond whatever I spend on new hardware and software and directly learning my new core competency.
- Fortunately, it’s all out on the net somewhere, and I’m darned good at hunting things down quickly.
