tag:blogger.com,1999:blog-81658366869037914252024-02-07T21:35:43.257-08:00Technical Notes and Stuff HappeningBenhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.comBlogger28125tag:blogger.com,1999:blog-8165836686903791425.post-55104750078397974312010-03-13T00:19:00.001-08:002010-03-13T00:19:53.121-08:00First post of 2010Just because I haven't done it in awhile.Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-62423975377298294462009-08-04T18:20:00.000-07:002009-08-04T18:24:02.872-07:00Give me a function that given a line, describes the next1<br />11<br />21<br />1211<br />111221<br />312211<br />13112221<br />1113213211<br /><br /><br />char* get_next_line(char* line)<br />{<br />char next_line[4096];<br />int next_line_ndx = 0;<br /><br />char letter = line[0];<br />int num_letters = 0;<br /><br />for (int i = 0; i < strlen(line); ++i)<br />{<br /> if (letter != line[i+1])<br /> {<br /> next_line[next_line_ndx] = num_letters + '0';<br /> next_line_ndx++;<br /> next_line[next_line_ndx] = letter;<br /> next_line_ndx++;<br /> next_line[next_line_ndx] = 0;<br /><br /> letter = line[i+1];<br /> num_letters = 0;<br /> }<br /> else<br /> {<br /> num_letters++;<br /> }<br />}<br /><br />return next_line;<br />}Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-16981528259436349062009-07-29T09:15:00.000-07:002009-07-29T09:40:20.477-07:00breadth first search of binary tree (w/o the formatting)7<br /> / \<br /> 1 2<br /> / \ /<br /> 0 3 4<br /> \<br /> 2<br /><br />7<br />1 2<br />0 3 4<br />2<br /><br /><br /><br />def traverse_tree(node):<br /> q = []<br /> last_level = 0<br /> current_level = 0<br /> q.append([node, current_level])<br /><br /> while len(q) > 0:<br /> node, current_level = q.pop()<br /><br /> if current_level != last_level:<br /> last_level = current_level<br /> print "\n"<br /> print node + " "<br /><br /> left_child = node.left<br /> right_child = node.right<br /><br /> if left_child not NULL:<br /> q.append([left_child, current_level + 1])<br /><br /> if right_child not NULL:<br /> q.append([right_child, current_level + 1])Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-38023144794779258992008-10-20T14:25:00.000-07:002008-10-20T14:38:50.641-07:00MySQL restart on Mac OS XThis is the simplest way to restart the server on Mac OSX that I found<br /><br /><span style="color: rgb(255, 0, 0);">my-computer:~ me$ mysqladmin -uroot -p shutdown</span><br /><span style="color: rgb(255, 0, 0);">Enter password:</span><br /><span style="color: rgb(255, 0, 0);">my-computer:~ me$ sudo mysqld_safe</span><br /><span style="color: rgb(255, 0, 0);">Starting mysqld daemon with databases from /sw/var/mysql</span>Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-59220112621092925132008-10-16T14:58:00.001-07:002008-10-16T15:00:07.185-07:00VotedI voted so I have the right to complain.Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-1367731340825313802008-10-08T09:50:00.000-07:002008-10-08T09:53:31.287-07:00MySQL Python APIIf you try to install the python <a href="http://mysql-python.sourceforge.net/MySQLdb.html">API for MySQL on Leopard</a>, and receive the following message:<br /><br />lipo: can't open input file: /var/tmp//ccDsRjet.out (No such file or directory)<br /><br />make sure you check out <a href="http://fitri.manzanisimo.net/2008/05/11/mysql-python-in-leopard/">this</a>.Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-48714802720562926692008-06-09T01:29:00.000-07:002008-06-09T01:30:43.293-07:00Nice Macports explanation for Ruby Rails<a href="http://paulsturgess.co.uk/articles/show/46-using-macportsdarwinports-to-install-ruby-on-rails-mysql-subversion-capistrano-and-mongrel-on-mac-os-x">http://paulsturgess.co.uk/articles/show/46-using-macportsdarwinports-to-install-ruby-on-rails-mysql-subversion-capistrano-and-mongrel-on-mac-os-x</a>Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-26430637914950758712008-06-06T08:28:00.000-07:002008-06-06T08:35:29.817-07:00Installing BerkeleyDB perl module from CPAN<span class="Apple-style-span" style="font-family:arial;"><span class="Apple-style-span" style="font-size: medium;">I was getting an error executing:</span></span><span class="Apple-style-span" style="font-family:arial;"><span class="Apple-style-span" style="font-size: medium;"><span class="Apple-style-span" style="color: rgb(51, 51, 51); "></span></span></span><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); "><span class="Apple-style-span" style="font-family:arial;"><span class="Apple-style-span" style="font-size: medium;"><br /></span></span></span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); "><span class="Apple-style-span" style="font-weight: bold;"><span class="Apple-style-span" style="font-size: medium;">cpan -i BerkeleyDB</span></span></span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); "><span class="Apple-style-span" style="font-family:arial;"><span class="Apple-style-span" style="font-size: medium;"><br /></span></span></span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); "><span class="Apple-style-span" style="font-family:arial;"><span class="Apple-style-span" style="font-size: medium;">This seemed to be because I did not have Berkeley installed on my mac. Well no problem, just execute</span></span></span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); "><span class="Apple-style-span" style="font-family:arial;"><span class="Apple-style-span" style="font-size: medium;"><br /></span></span></span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); "><span class="Apple-style-span" style="font-family:arial;"><span class="Apple-style-span" style="font-weight: bold;"><span class="Apple-style-span" style="font-size: medium;">port </span></span></span><span class="Apple-style-span" style="color: rgb(0, 0, 0); "><span class="Apple-style-span" style="font-family:arial;"><span class="Apple-style-span" style="font-weight: bold;"><span class="Apple-style-span" style="font-size: medium;">install db46</span></span></span></span></span></div><div><span class="Apple-style-span" style="font-family:arial;"><span class="Apple-style-span" style="font-size: medium;"><br /></span></span></div><div><span class="Apple-style-span" style="font-family:arial;"><span class="Apple-style-span" style="font-size: medium;">from </span><a href="http://www.macports.org/ports.php?by=category&substr=databases"><span class="Apple-style-span" style="font-size: medium;">Macports</span></a><span class="Apple-style-span" style="font-size: medium;">. After that finishes, just set up a link in /usr/local e.g.</span></span></div><div><span class="Apple-style-span" style="font-family:arial;"><span class="Apple-style-span" style="font-size: medium;"><br /></span></span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family:'Trebuchet MS';"><span class="Apple-style-span" style="font-family:arial;"><span class="Apple-style-span" style="font-weight: bold;"><span class="Apple-style-span" style="font-size: medium;">ln -s /usr/local/BerkeleyDB.4.6/ /usr/local/BerkeleyDB</span></span></span><span class="Apple-style-span" style="font-size: medium;"><br /></span></span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family:arial;"><span class="Apple-style-span" style="font-size: medium;"><br /></span></span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family:arial;"><span class="Apple-style-span" style="font-size: medium;">and then </span></span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family:arial;"><span class="Apple-style-span" style="font-size: medium;"><br /></span></span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family:arial;"><span class="Apple-style-span" style="font-weight: bold;"><span class="Apple-style-span" style="font-size: medium;">cpan -i BerkeleyDB</span></span></span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family:arial;"><span class="Apple-style-span" style="font-size: medium;"><br /></span></span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family:arial;"><span class="Apple-style-span" style="font-size: medium;">should work.</span></span></div>Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com2tag:blogger.com,1999:blog-8165836686903791425.post-75539839258067314232008-06-06T07:22:00.000-07:002008-06-06T07:24:32.991-07:00Install perl module off cpanit's easy<div><br /></div><div><span class="Apple-style-span" style="font-weight: bold;">cpan -i [module]</span></div>Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-9223002122360431982008-06-03T02:33:00.000-07:002008-06-03T02:35:46.609-07:00Enable sending email on Mac OS XIt wasn't completely obvious to me, but here is what you need to execute in order to be able to send email from your Mac.<div><br /></div><div>in a terminal:</div><div><span class="Apple-style-span" style="font-weight: bold;">postfix start</span></div>Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-44742196393063141442008-05-28T04:59:00.000-07:002008-05-28T05:24:04.763-07:00Installing and setting up a fink installed MySQL with a non-default data directorySo I assume you have successfully executed: <span class="Apple-style-span" style="font-weight: bold;">sudo fink install mysql</span><div><br /></div><div>Create or edit <span class="Apple-style-span" style="font-weight: bold;">/etc/my.cnf</span> and add or change the keyword datadir to the directory you want e.g.<br /></div><div><br /></div><div><span class="Apple-style-span" style="font-weight: bold;">[mysqld]</span></div><div><span class="Apple-style-span" style="font-weight: bold;">datadir=/Volumes/another/directory</span></div><div><span class="Apple-style-span" style="font-weight: bold;">[mysqld_safe]</span></div><div><span class="Apple-style-span" style="font-weight: bold;">datadir=/Volumes/another/directory</span></div><div><br /></div><div>During installation, Fink set up some files and directories in <span class="Apple-style-span" style="font-weight: bold;">/sw/var/mysql</span>. Copy the contents of this directory to your new directory e.g.</div><div><br /></div><div><span class="Apple-style-span" style="font-weight: bold;">sudo cp -r /sw/var/mysql/* /Volumes/another/directory</span></div><div><br /></div><div>Go to <span class="Apple-style-span" style="font-weight: bold;">/Volumes/another/directory</span> and set the owner of all contents to <span class="Apple-style-span" style="font-weight: bold;">mysql</span> e.g.</div><div><span class="Apple-style-span" style="font-weight: bold;">sudo chown -R mysql </span><span class="Apple-style-span" style=""><span class="Apple-style-span" style="font-weight: bold;">/Volumes</span></span><span class="Apple-style-span" style="font-weight: bold;">/another/directory</span>.</div><div><br /></div><div>At this point you should be able to run '<span class="Apple-style-span" style="font-weight: bold;">sudo mysqld_safe</span>.'</div>Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-92041735929753598182008-05-17T05:45:00.000-07:002008-05-17T08:44:21.310-07:00fink Mysql on Macbook OSX 10.5 leopardI installed mysql from <a href="http://pdb.finkproject.org/pdb/package.php/mysql">fink</a> and received some unwelcome news.<br /><br /><span style="color: rgb(0, 0, 102);">My-MacBook:~ me$ sudo mysqld_safe </span><br /><span style="color: rgb(0, 0, 102);">Password:</span><br /><span style="color: rgb(0, 0, 102);">chown: mysql: Invalid argument</span><br /><span style="color: rgb(0, 0, 102);">Starting mysqld daemon with databases from /sw/var/mysql</span><br /><span style="color: rgb(0, 0, 102);">STOPPING server from pid file /sw/var/mysql/My-MacBook.local.pid</span><br /><span style="color: rgb(0, 0, 102);">080517 14:39:45 mysqld ended</span><br /><br />After looking at <span style="color: rgb(0, 0, 102);">/sw/var/mysql/My-MacBook.local.err</span>, it seemed I was missing the user mysql. So I snooped around google and found the answer. Based on <a href="http://wincent.com/a/about/wincent/weblog/archives/2007/10/creating_new_da.php">this</a>, I executed the following commands:<br /><br /><span style="color: rgb(0, 0, 102);">sudo dscl localhost -create /Local/Default/Users/mysql</span><br /><pre style="color: rgb(0, 0, 102);">sudo dscl localhost -create /Local/Default/Users/mysql NFSHomeDirectory /var/empty<br />sudo dscl localhost -create /Local/Default/Users/mysql Password '*'<br />sudo dscl localhost -create /Local/Default/Users/mysql PrimaryGroupID 74<br />sudo dscl localhost -create /Local/Default/Users/mysql RealName "MySQL Server"<br />sudo dscl localhost -create /Local/Default/Users/mysql UniqueID: 74<br />sudo dscl localhost -create /Local/Default/Users/mysql UserShell: /usr/bin/false</pre>My next attempt to start <span style="color: rgb(0, 0, 102);">mysqld_safe</span> gave me some more bad news:<br /><br /><span style="color: rgb(0, 0, 102);">My-MacBook:var me$ sudo mysqld_safe Password:</span><br /><span style="color: rgb(0, 0, 102);">chown: mysql: Invalid argument</span><br /><span style="color: rgb(0, 0, 102);">Starting mysqld daemon with databases from /sw/var/mysql</span><br /><span style="color: rgb(0, 0, 102);">STOPPING server from pid file /sw/var/mysql/My-MacBook.local.pid</span><br /><span style="color: rgb(0, 0, 102);">080517 17:11:24 mysqld ended</span><br /><br />This one was easy though. Just go to <span style="color: rgb(0, 0, 102);">/sw/var</span> and execute <span style="color: rgb(0, 0, 102);">chown -R mysql mysql</span>. You should be good to go from here. <span style="color: rgb(0, 0, 102);">sudo mysqld_safe&</span> should work just fine.Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-14739572431574994212008-05-14T11:24:00.000-07:002008-05-14T11:28:26.013-07:00Adobe Flex license key Leopard OSXIf you ever receive a message like "License key is invalid" when you enter in your valid license<br />for Adobe Flex on OSX, try switching to an admin account. For some reason when you enter the license key into Flex Builder (or the Eclipse plug-in) under a non-admin account, you cannot 'activate' the installation.Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-24100121127393882242008-05-10T06:08:00.001-07:002008-05-10T06:46:43.489-07:00gem install mysql mac osx leopardgem install mysql -- --with-mysql-config=`which mysql_config`<br /><br />Also you may need some additional <a href="http://jlaine.net/2006/10/3/installing-ruby-mysql-driver-on-os-x">hacking</a> to get it all working.Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com3tag:blogger.com,1999:blog-8165836686903791425.post-51318563597244096552008-03-19T05:15:00.001-07:002008-03-19T05:16:45.198-07:00Updating locate on Mac OSXUpdate locatedb on your Mac OSX with:<br />sudo /usr/libexec/locate.updatedbBenhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com1tag:blogger.com,1999:blog-8165836686903791425.post-46130975108523712532008-03-11T05:58:00.001-07:002008-03-11T06:03:36.949-07:00Debugging ruby rails in productionHelpful little thing that helped me debug my ruby rails production system.<br /><br />shell$ [RAILS_ROOT]/script/console production<br /><br />So here you can invoke a model (e.g. User.new), call helper methods (UserHelper.authenticate(user, pass)), etc.Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-28416484020591814442008-03-06T05:04:00.000-08:002008-03-06T05:06:03.604-08:00Ruby Rails column type to MySQL datatypelifted from <a href="http://www.packtpub.com/article/Working-with-Rails-ActiveRecord-Migrations-Models-Scaffolding-and-Database-Completion">PackT</a>.<br /><div align="center"> <table class="MsoTableGrid" style="border: medium none ; width: 329.4pt; border-collapse: collapse;" border="1" cellpadding="0" cellspacing="0" width="439"> <tbody><tr style=""> <td style="border: 1pt solid black; padding: 0in 5.4pt; width: 90.9pt;" valign="top" width="121"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><b><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">Migration column type...<o:p></o:p></span></b></p> </td> <td style="border-style: solid solid solid none; border-color: black black black -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 130.5pt;" valign="top" width="174"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><b><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">Converts to MySQL field type...<o:p></o:p></span></b></p> </td> <td style="border-style: solid solid solid none; border-color: black black black -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 1.5in;" valign="top" width="144"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><b><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">Available options1<o:p></o:p></span></b></p> </td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 90.9pt;" valign="top" width="121"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">:binary<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 130.5pt;" valign="top" width="174"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">TINYBLOB, BLOB, MEDIUMBLOB, or LONGBLOB2<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1.5in;" valign="top" width="144"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">:limit => 1 to 4294967296 (default = 65536)2<o:p></o:p></span></p> </td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 90.9pt;" valign="top" width="121"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">:boolean<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 130.5pt;" valign="top" width="174"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">TINYINT(1)<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1.5in;" valign="top" width="144"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">-<o:p></o:p></span></p> </td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 90.9pt;" valign="top" width="121"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">:date<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 130.5pt;" valign="top" width="174"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">DATE<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1.5in;" valign="top" width="144"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">-<o:p></o:p></span></p> </td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 90.9pt;" valign="top" width="121"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">:datetime<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 130.5pt;" valign="top" width="174"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">DATETIME<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1.5in;" valign="top" width="144"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">-<o:p></o:p></span></p> </td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 90.9pt;" valign="top" width="121"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">:decimal<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 130.5pt;" valign="top" width="174"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">DECIMAL<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1.5in;" valign="top" width="144"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">:precision => 1 to 63 (default = 10) :scale => 0 to 30 (default = 0)3<o:p></o:p></span></p> </td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 90.9pt;" valign="top" width="121"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">:float<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 130.5pt;" valign="top" width="174"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">FLOAT<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1.5in;" valign="top" width="144"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">-<o:p></o:p></span></p> </td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 90.9pt;" valign="top" width="121"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">:integer<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 130.5pt;" valign="top" width="174"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">INT<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1.5in;" valign="top" width="144"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">:limit => 1 to 11 (default = 11)<o:p></o:p></span></p> </td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 90.9pt;" valign="top" width="121"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">:primary_key<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 130.5pt;" valign="top" width="174"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">INT(11) AUTO_INCREMENT PRIMARY KEY<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1.5in;" valign="top" width="144"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">-<o:p></o:p></span></p> </td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 90.9pt;" valign="top" width="121"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">:string<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 130.5pt;" valign="top" width="174"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">VARCHAR<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1.5in;" valign="top" width="144"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">:limit => 1 to 255 (default = 255)<o:p></o:p></span></p> </td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 90.9pt;" valign="top" width="121"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">:text<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 130.5pt;" valign="top" width="174"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">TINYTEXT, TEXT, MEDIUMTEXT, or LONGTEXT2<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1.5in;" valign="top" width="144"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">:limit => 1 to 4294967296 (default = 65536)2<o:p></o:p></span></p> </td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 90.9pt;" valign="top" width="121"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">:time<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 130.5pt;" valign="top" width="174"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">TIME<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1.5in;" valign="top" width="144"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">-<o:p></o:p></span></p> </td> </tr> <tr style=""> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 90.9pt;" valign="top" width="121"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">:timestamp<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 130.5pt;" valign="top" width="174"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">DATETIME<o:p></o:p></span></p> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1.5in;" valign="top" width="144"> <p class="MsoNormal" style="margin: 6pt 0in; line-height: normal;"><span style="font-size: 10pt; font-family: "Verdana","sans-serif";">-</span><span style="font-size: 10pt; font-family: "Verdana","sans-serif";"><o:p></o:p></span></p> </td> </tr> </tbody></table> </div>Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-85120103756430158342008-03-04T03:43:00.001-08:002008-03-04T03:44:18.141-08:00Production Rails DatabaseTo make a production version of a database defined in rails.<br /><br /><span style="font-style: italic;">rake db:migrate RAILS_ENV="production"</span>Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-82712037570647385542008-03-03T01:31:00.001-08:002008-03-03T01:34:49.116-08:00phpMyAdmin plugMan... gotta use phpMyAdmin for looking at your MySQL database. On Mac use 'Fink Commander' and look for phpMyAdmin. Follow the configuration instructions <a href="http://pdb.finkproject.org/pdb/package.php/phpmyadmin">here</a>. In order for me to get it working, I had to set the following properties:<br /><br /><span style="font-style: italic;"> $cfg['Servers'][$i]['socket'] = '/tmp/mysql.sock'; </span><br /><span style="font-style: italic;"> $cfg['Servers'][$i]['connect_type'] = 'socket'; </span>Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-58436509059787933142008-02-26T01:08:00.001-08:002008-02-26T01:10:01.354-08:00Instance variable in viewer for ActionMailerUsing the ActionMailer in your Ruby on Rails application, I wanted to display a variable in the viewer. If the content_type is "text/html", the body needs to have the instance variable symbol e.g. body :var => var. In the viewer, you may reference this variable with <%= @var %>.Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-26721293055623959532008-02-14T01:00:00.001-08:002008-02-14T01:01:41.276-08:00svn checkout urlFor some reason, I always have a tough time remembering how to check out code from an svn repository. So here it goes:<br /><br /> svn co svn+ssh://[user]@[server]/[path to project on svn server]Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-29849820127275904812008-02-10T08:55:00.000-08:002008-02-10T09:08:54.959-08:00Sharing OSX leopard folder and mounting it on Windows XPSo it shouldn't be that hard, but it took me about half an hour so I got to document it. I tried mounting a folder shared on my Leopard from an XP machine. This is finally how I got it done:<br /><br />On Leopard:<br /><ol><li>In System Preferences, under Network, tab over to WINS and set the Workgroup to something like 'Mshome'</li><li>In System Preferences, under Sharing, click options and check 'Share files and folders under SMB'</li></ol>On Windows:<br /><ol><li>Right click on 'My Computer', clicking on 'Map Network Drive'</li><li>Click 'Browse', and you should see your Mac (for some reason your XP might not see the Mac right away, wait about 5 minutes)<br /></li></ol>Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com1tag:blogger.com,1999:blog-8165836686903791425.post-54524887538149433692008-02-06T01:11:00.000-08:002008-02-06T01:13:51.278-08:00Simple exporting of MySQL tables into a fileecho "select * from [table];" | mysql -u[user] -h[server] -p[password] [database] > [output_file]Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-39456127416120883362008-02-01T05:56:00.000-08:002008-02-01T06:01:44.026-08:00Simple Ruby MySQLTo get the MySQL Ruby library to work as documented on <a href="http://www.troubleshooters.com/codecorn/ruby/database/index.htm">troubleshooters</a>, I had to add the following require statement:<br /><br /><span style="font-weight: bold;">require 'rubygems'</span><br />require 'mysql'<br />.<br />.<br />.<br />mysql.close()Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0tag:blogger.com,1999:blog-8165836686903791425.post-28220582163108603162008-01-20T01:17:00.000-08:002008-01-21T00:36:09.062-08:00Nuovi Anni a Torino, Italia<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6hIRr4RrI_IxrouiV4FsR-cLxZUhMFidh6mlwtQk72bam6xPXUGZkVuJKd2hBOwLa87MBHcylSDw1jFFT-sMy03WwH18e9iYq4hlCRbWh5_mI3xypl0ioNEmoLPpnlECnjvZbTBhBgA4f/s1600-h/san_carlo_quarters_cropped.JPG"><img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6hIRr4RrI_IxrouiV4FsR-cLxZUhMFidh6mlwtQk72bam6xPXUGZkVuJKd2hBOwLa87MBHcylSDw1jFFT-sMy03WwH18e9iYq4hlCRbWh5_mI3xypl0ioNEmoLPpnlECnjvZbTBhBgA4f/s320/san_carlo_quarters_cropped.JPG" alt="" id="BLOGGER_PHOTO_ID_5157501949658996002" border="0" /></a><br /><br />Yea.... still keeping it real at Piazza San Carlo in Torino, Italia on New Year's eve.Benhttp://www.blogger.com/profile/12840311877667414184noreply@blogger.com0