juretta.com

4 Recent Entries tagged with »MySQL«

Loading the Netflix Dataset into MySQL | April 24, 2007

I just couldn't resist. The by now well known Netflix Prize is a great opportunity to do a little bit research about recommendation engines (recommender). I decided to use a plain MySQL 5 d...

@17:59 | Comments: 0 | Tags: MySQL (5), Netflix (1), Ruby (32)

Ruby: Installing Ruby MySQL driver on Intel Macs | October 13, 2006

Installing the native MySQL-Driver for Ruby on my MacBook Pro (Mac OS X 10.4.8) resulted in the following error after running sudo gem install mysql -- --with-mysql-dir=/usr/local/mysql. ...

@22:05 | Comments: 7 | Tags: Gems (3), MySQL (5), Ruby (32)

MySQL Cheat Sheet | June 24, 2005

mysql> SHOW Table Status; mysql> SHOW INDEX FROM table; mysql> SELECT @var := MAX(irgendwas) FROM table; mysql> EXPLAIN SELECT .... mysql> SHOW FIELDS FROM table; Multip...

@10:56 | Comments: 0 | Tags: Database (4), MySQL (5)

Ruby and Rails on Mac OS X Tiger | April 24, 2005

ruby -v [powermac:~] sts% ruby -v ruby 1.8.2 (2004-12-25) [powerpc-darwin8.0] Readline installieren curl ftp://ftp.gnu.org/gnu/readline/readline-5.0.tar.gz | tar xfz cd readline-5.0 ....

@14:08 | Comments: 0 | Tags: Mac (18), MySQL (5), PostgreSQL (1), Rails (28), Rails (28), Ruby (32)