Entries Tagged 'MySQL' ↓

Well, OS X now comes a lot closer to having a good Ruby and Rails, but I don’t like it.
What’s the deal with giving a default Rails DB configuration using SQLite3?!!
Lame. Sorry. Most folks doing Rails work use MySQL…

And as for the gems installed… uh where is Rmagick? Why isn’t Image Magick installed? X11 is now installed by default, so it only stands to reason…
Nice try guys, but unless this is Ruby and Rails for Apple’s internal use, there’s not much point. I expect to see a one-click replacement soon, but I’m going to go back and hook up my old installation the Hivelogic way. It just works better and corresponds better to what’s available on real-world hosting providers.

The gem choices are somewhat odd. Limited and odd. I’m dumping it and going with my own. Apple, (Laurent) I will leave yours in /usr/bin but I will not use it. Thanks anyway.

So, what’s the next big thing gonna be? TAG SPAM. That’s right Continue reading →

So you’re learning or using Ruby on Rails, or even just using Ruby with a database. The ActiveRecord component of Rails provides one way to work with databases through Ruby. ActiveRecord applies a concept called ORM (Object Relational Mapping) to quite literally map object oriented programming constructs to relational database constructs.

What’s that mean? It means it you can write Ruby in a fairly Ruby way (to be fair to purists, a Rails way) when working with databases. Most folks will be using an SQL-based relational database, such as MySQL, PostreSQL or SQLite3. Others are possible, but MySQL is certainly the most common and probably best supported.

Specifically, Rails uses an approach called database migrations to substitute for writing SQL directly. Migrations make things pretty easy, indeed. You can learn plenty about using migrations with the main book for Rails, Agile Web Development With Rails. However, I encourage everyone to also take a look to the book, Ruby for Rails.

The general approach of Ruby for Rails is to get you to know how the magic works, and help you develop a better understanding of the underlying technology so you can do more with it. This is really a key thing. You’re not going to be good at Rails without learning Ruby itself, much less CSS, XHTML, and perhaps Javascript, and definitely a little SQL.

What?! Yeah. That’s right, you do need to know about the details. Perhaps not intimately, but well enough to understand what it is you’re really doing. SQL is a big subject. Lucky for you, database-driven web sites tend to do a lot of the same kinds of things in most situations. Therefore, you don’t need to be a master of SQL but you need to experience it and understand how it works. Particularly MySQL’s version (and if you’re a programmer, consider SQLite as well)

SQL isn’t that hard, but it is fairly different from most other programming languages. (yes, I think it IS a programming language.) But I don’t just want you to know SQL a little, I want you to know a little database design too. This is what is important so you will have some concept of what it is migrations is doing for you. When you have this in your head, you will then also know what migrations may not be able to do for you.

As many of you know, with OS X, it takes a little doing to get Ruby [and Rails] working properly. Installing MySQL and configuring it properly is also a bit of a bear. More than it should be. Then, once you’ve got all of that squared away, while you’re learning all the devilish little details of these fabulous tools, you also have to dive in to using and installing Ruby Gems. Gem is a pretty nice little package management tool. Kind of similar to apt-get on Linux or MacPorts (a.k.a DarwinPorts) or CPAN for Perl, but specifically for installing software libraries for Ruby. Like all of those, gem can seem to easy and good to be true. Sometimes it downright sucks, though. Continue reading →

I’m still stuck on Ruby and Rails. In a good way and a bad way!
The good way: both are fascinating and incredibly clever.
The bad way: there is much to learn and time is always scarce. Continue reading →

Over at Hivelogic, home of many good things OS X and Ruby and command line, you’ll find this excellent write up on why everything UNIXy and binaryish you download and install should go in /usr/local or /usr/local/bin

One main tip, but a second in store. First off, why do those fonts often look unbelievably small and ugly or just impossible to read in Firefox (1.5 and 2) for Mac OS X ? What gives?? Well, Me too. I wondered about this for a year and day. And then some. But hallelujah, I have found the answer! Continue reading →

So, you want to have a blog? Or perhaps a simple web site. Well, friends, there is good news and bad news.

First, the good news is, anyone can learn to do this stuff.

The bad news? You pretty much have to learn to do stuff with some code if you want to have something good.

Step one, Continue reading →