Category database

• OCT 03 2010

  HABTM before_filter in rails models

  Filed under database, habtm, quickie, rails, and ruby.

  How to automatically add an object to a habtm field on save... read more

• AUG 18 2009

  Compiling mysql-python on OS X leopard

  Filed under database, django, mysql, osx, programming, python, and quickie.

  How to get around a few of the problems you may encounter trying to install mysql-python bindings on OS X Leopard... read more

• AUG 17 2009

  'Hello World' with Scala and Lift on OSX

  Filed under database, java, lift, osx, programming, scala, and web.

  How to install Scala and Lift on OS X, and create a simple sample project... read more

• AUG 11 2009

  mysql select random row with join

  Filed under database, mysql, and programming.

  A couple of attempts to select random rows via a join in MySQL... read more

• AUG 09 2009

  InnoDB as default MySQL table type

  Filed under database, innodb, linux, mysql, programming, and quickie.

  How to change the default MySQL table type... read more

• JUN 18 2009

  MySQL table 'is marked as crashed'

  Filed under database, linux, programming, and quickie.

  What to do if you are getting an error similar to 'mysqldump: Got error: 145: Table xxxxx is marked as crashed and should be repaired when using LOCK TABLES'... read more

• JUN 02 2009

  Exclude tables from mysqldump

  Filed under database, linux, programming, and quickie.

  How to exclude certain tables from mysqldump... read more

• FEB 24 2009

  undefined method assert_valid_keys in Rails

  Filed under database, programming, quickie, rails, ruby, and web.

  How to fix 'undefined method assert_valid_keys' errors in Rails... read more

• JUL 27 2008

  Installing Trac on CentOS

  Filed under database, linux, programming, python, version control, and web.

  How to set up Trac and Subversion on CentOS... read more

• JUN 23 2008

  Setup 64bit CentOS (PHP5, MySQL, memcached, ketama)

  Filed under database, linux, php, programming, and web.

  A script to setup 64bit CentOS with PHP5, MySQL, memcached and ketama... read more

• JUN 23 2008

  Force MySQL Encoding to UTF8

  Filed under database, linux, mysql, programming, and web.

  How to force MySQL to use UTF8 encoding by default... read more

• DEC 05 2007

  Default Values With Hibernate Annotations

  Filed under database, hibernate, java, programming, quickie, and web.

  How to set the default value of a field with Hibernate... read more

• DEC 02 2007

  MySQL Delete On Joined Tables

  Filed under database, mysql, programming, and quickie.

  How to delete records from MySQL using joined fields... read more

• NOV 27 2007

  Appfuse "failed to lazily initialize a collection of role"

  Filed under appfuse, database, java, programming, quickie, and web.

  Fix the 'failed to lazily initialize a collection of role' error in AppFuse... read more

• NOV 26 2007

  Hibernate OneToMany Relationships

  Filed under database, hibernate, java, programming, quickie, spring mvc, and web.

  An example of a one-to-many relationship using Spring MVC and Hibernate... read more

• NOV 21 2007

  Hibernate 'TYPE=storage_engine is deprecated'

  Filed under database, hibernate, java, programming, quickie, and web.

  Fixing 'TYPE=storage_engine is deprecated' warnings in Hibernate... read more

• JUN 04 2007

  Multiple DBs in CakePHP

  Filed under database, php, programming, and web.

  How to hack cake to use different databases for different models... read more

• APR 02 2007

  Installing MySql/PDO for PHP

  Filed under database, linux, php, programming, and web.

  How to install PDO/MySql to fix Zend_Db_Adapter_Exception errors in Zend Framework... read more

• FEB 19 2007

  Installing Trac

  Filed under database, linux, programming, python, version control, and web.

  Trac can be a little tricky to install. Here's the steps that worked for me... read more

• FEB 18 2007

  Svn server w/ Apache

  Filed under database, linux, programming, subversion, version control, and web.

  A walk-through for setting up a subversion server hosted by http/apache... read more

• SEP 28 2006

  Recover Corrupted Svn DB

  Filed under database, linux, programming, quickie, subversion, and version control.

  How to recover your repository if you're getting 'Corrupted' error messages... read more