wiki: WikiStart

Welcome to the Casa de Pacopablo

ohloh profile for pacopablo
PyCon 2011, Atlanta, March 9-17

This is the hideout of the crazy gringo, pacopablo.

Blog

OS X Python Interactive Shell: <DEL> vs. ~

Everyone knows that  Python is awesome. It has a wonderful interactive interpreter that allows one to try out code. A neat feature is that one can enable  tabbed completion. This allows for one to inspect modules and cut down on the amount of typing.

If one is using OS X, however, there is a little annoying caveat: the delete key inserts a ~. To fix this, add the following line to your .pystartup file:

readl ... 

(Read more)

Documentation Driven Development and Corporate Tool

At  PyCon 2011, I attended a talk by Corey Oordt titled " Documentation Driven Development". I really enjoyed it. It focused on writing your documentation before coding and then coding to your documentation. In some ways, this is the same as what is taught in school: "Do a  requirements analysis, produce a [ http://en.wikipedia.org/wiki/Software_Requirements_Spe ...

(Read more)

FreeNAS: Jumbo Frames and LAGG Interfaces

 FreeNAS is awesome! It's got tons of features and it's polished. Some of the features that make is awesome are being able to set MTU size (jumbo frames) and use LACP.

To setup an LACP group, simply follow the  Link Aggregation and Failover instructions and choose LACP as the Aggregation protocol

Jumbo Frames is simply setting an MTU higher than 1500. The MTU can be set easily via the [ http://freenas.org/documenta ...

(Read more)

Trac Hosting on the Cheap

As happens from time to time, the question of Trac hosting was raised on #trac

Chat Excerpt from 08/11/2009
[07:46:38]<hendrixski>anybody recommend any trac hosting?
[07:48:20]<hendrixski>we're currently hosting our own, and while it's not hard ... it's time consuming
[07:48:33]<jhammel>hendrixski: what is the time consuming part?
[07:49:01]<hendrixski>we installed some plugin, which caused something to work not as we wanted, and undoing it is taking more than an hour or so
[07:49:16]<hendrixski>and... honestly, an hour of developer time a month... and it's worth having someone else host it
[07:49:26]<jhammel>hendrixski: i'm not sure if any hosting company provides that level of support
[07:51:19]<fission6>how do i execute wiki-macros as another user besides apache, can i specify
[07:51:32]<jhammel>hendrixski: actually, its a business i'd like to get into, but am not prepared to quite yet
[07:53:00]<hendrixski>jhammel: I'd pay for it
[07:53:20]<hendrixski>I love trac, I just don't like having to configure the email, plugins, etc. etc.
[07:53:48]<jhammel>hendrixski: i wish i could take you up on that offer; too disorganized right now :(
[07:54:04]<jhammel>hendrixski: maybe in a month, if you still need it...still getting my own hosting story straightened out
[07:56:31]<achilles>I am looking for someone who would like to HOST and CONFIGURE TRAC

There are many options for  Trac Hosting. The issue is really figuring out which ones are good. I tried out  Repository Hosting today and I was impressed. Some of the features that impressed me are:

  • Very nice theme work
  • Nice and snappy response
  • ...

(Read more)

SQLAlchemy: Calling MS SQL Stored Procedure with Output Parameters

 SQLAlchemy is generally a wonderful ORM and database toolkit for Python. Personally, I think it's the best one in the Python landscape. However, there are some things that tend to be a little troublesome.

Some of these are simply due to the difference between a relational database and an object oriented language. Others, however, are due to RDBMS specific quirks.

The problem I encountered recently was how to call a stored procedure in MS SQL from SQLAlchemy. In general, the ...

(Read more)

T-SQL Tidy.com: Awesome!!

Digging through Dynamics: GP stored procedures is painful, to say the least.

When you pull the SQL out of the database via SQL Server Management Studio it is one LONG line. No formatting, nothing. Reading the TSQL as one line isn't really an option. Reformatting it by hand takes FOREVER.

Fortunately, there is a wonderful online formatter over at  TSQLTidy. It can transform the GP stored procedures into something that can actually be parsed by a human brain. [ http://www.t ...

(Read more)

Dynamics: GP 10 Manufacturing -- How Not To

Having recently upgraded from GP8 to GP10 and having switched from Horizons Manufacturing to GP: Manufacturing, I wanted to lay out a few do's and don'ts for anyone else considering a switch. Hopefully the below will save you some of the headache.

  1. Take The Defaults: As with pretty much all Microsoft products, accepting the defaults is prudent and nigh a necessity. If you simply take the defaults and use the software exactly as designed, you'll have an acceptable experience.
  2. ...

(Read more)

Dell Express Service Code Program

When you buy a Dell with Windows on it, you get a little program pre-installed that will tell you the service code of your machine. This is a handy little tool for tech support, especially if your machine is in a hard to reach location. Simply fire up the program and BAM! There is your service tag

Today I was cleaning up a PC today getting it ready to cycle it out of the company. In my hacking and slashing of data, I deleted the dell directory in which the Service Tag program resides. Not a huge d ...

(Read more)

Authenticate Trac Against phpBB

So, Chuck, over at  Cobra wanted to get his trac site up and running and was wondering about using the exisiting accounts that people had in the phpBB3 forums. Trac being Python, and  phpBB being, obviously, PHP, there was no stock way of accomplishing this.

First, Trac's authentication meme is basically: get someone else to do it. Generally speaking, this is the web server. That's all fine and dandy, but some people want a bit more. Thankfully, [htt ...

(Read more)

15 Character Limit

Let's establish some facts.

  • MS SQL Server 2005 allows the sa password to be longer than 15 characters.
  • MS Windows XP allows a password longer than 15 characters.

Given these two facts, one would assume that Microsoft has a policy of allowing arbitrary length password (or at least really long ones). However, if one were to assume this, one would be wrong.

Microsoft's Business Solutions - Great Plains 8 does NOT allow passwords longer than 15 characters. I'll admit that GP8 is a bit ...

(Read more)


Thanks to coderanger, we will always know what day Easter is. :)

2012-04-08


As is evidenced by the lack of modification of the logo at the top of the page, this site is run on  trac. It is a great piece of software that provides a wonderful plugin system. The "official" site for plugins and other modifications to trac is  trac-hacks.org. Go check it out.

Last modified by pacopablo on 03/13/11 00:11:56 (20 months ago)