Shooting myself in the head with Python, Django,Pinax

Well I decided to take some time off from working with the App-engine-patch and try Native Django,, go more mainstream so I could take advantage of more robust database and tutorials…

I’m using Python 2.62 Win 64 Eclipse 3.4 Ganymede, and trunk SVN Django 1.1

1st, one must install a Mysql driver The one in the “official library won’t work, version differences.. go here for a windows installer for Python 2.6  Fwiw I’m using 32 bit versions although there is a 64 bit version available (for both Python and the Mysql driver (lower down on that thread).

You also need to add the following change manually to the Mysqldb code

About warnings:

1) file “__init__”, replace:

from sets import ImmutableSet
class DBAPISet(ImmutableSet):


class DBAPISet(frozenset)

2) file “”, remove:

from sets import BaseSet, Set

3) file “”, change “Set” by “set” (IMPORTANT: only two places):

line 48: return set([ i for i in s.split(‘,’) if i ])
line 128: set: Set2Str,

I hope this be useful.


Luis Moreno

I realized That I had not been documenting myself when I blew up and was about ready to re install and realized I’d have to look every thing up again… Hence back to posting!

One of the most interesting revelations for me recently is how Python “installs” and referrers to packages and extensions. At this point I now think that all the trashing about is a bit too much on many installs. Looking in site-pkges in Libs in the Python directory I noticed several .pth files named for some of the extensions I was installing and using, the file was the module name.pth.. and contained the full path to the module… cool! So that is a mechanism that can be used to create a nice place to keep that stuff without messing up your basic Python install… good to know..

Another major revelation has been the use of revision control systems,,, It seems that it is well worthwhile to have a copy of all of the major systems on your machine. Git, SVN and Mercurial. If you checkout a copy of a system like Django,,, then when you want a update to the current version just do another checkout and your done!

Btw it turns out that even if you use TortoiseSVN as I do it is a good ides to install Silk SVN also because Tortoise does not provide command line access, which is used by some packages for automated installation/updating, in particular Pinax! So even if you don’t want command line you need to have it on your system…

If you use tagging with the 1.0 or latter Django you must use the svn version of tagging ….

Eclipse/App Engine/Bloog Part 4, The hard part

Well I had a long and frustrating week/week-end, all sort of run together. I discovered that my new site would not take even moderately long articles. This is apparently a “known problem” and it relates to exploding indexes, as somewhat explained here.

I finally got to corresponding with one of the Bloog Maintainers who had it turned out created a modified site search capability using Google Site Search. According to him  it still does not provide for longer article without some code mods that I have not yet started. But is a prerequisite. I got a copy from Git-hub, where Bloog is hosted. This required that I get and install GIT version control system. I chose to start with Windows based  Git Extensions. It still required that you install the basic GIT. It is only available in Tar format you will need 7zip to unpack although after a posting the developer has now provided a “full” option for Git extensions.

I then tried to apply the new code to my existing Bloog version as I had modified it. That required a differential editor,which I did not have Kdiff3 turned out to be a great choice. It compares entire directory structures and than lets you click through the files and selectively choose to apply a, b to your revised file. Very cool.

I then tried to fire things up, FAIL. I then went back to the Version I had just obtained and I could not get it to fire up either. I then started to look for “real” debug information. Not much available.

Eventually I downloaded PYdev for Eclipse, and that was a major improvement  my entire development environment. In fact I would go so far to say Do not attempt development for APP-Engine without Pydev!! It provides a much better editor, code outlining and a runtime environment. There are several tutorials on setting up Eclipse for app-engine. Use them!!! Supposedly it also provides breakpoints, but I have not been able to get that working yet, but the other improvements are a major joy. The Debug environment did give me better log messages. Through which I was eventually able to make some headway. I found out that the two versions had changed the DB schema slightly so I had to delete a few older records You can see and modify the local datastore using http://localhost:8080/_ah/admin/datastore and bang it all started to work. It actually took a long time to go through each step, and I still have to go back and learn each of the new tools much better.

Installing SQL Explorer Eclipse plug-in In Ganymede

Installing SQL Explorer Eclipse plug-in Using auto Update: Hat tip to  I noticed this set of instructions had not been updated for a while but they worked like a charm. The tool seems to have picked up some support recently and may be a good addition to your toolbox. Paticularly since the Data Tools Platform Eclipse component still seems to have a way to go. I’ll be trying to use this along side Birt for report wrting to edit the underlying queries… we’ll see. These instructions are lifted verbatum, they work. With Eclipse 3.41 and SQL Explorer version 3.5.0.RC6

  • From the Eclipse menu,
    select Help->Software Update->Find and Install. You will be
    displayed with a Install/Update dialog box.
  • Select Search for new
    features to install radio button & click next.
  • Click on the New Remote
    Site on the right hand side of the Install dialog box
  • Enter the name as “SQL
    Explorer” & “” (without quotes) for
    the url in the New Update Site dialog box and click ok.
  • Select the SQL Explorer
    site in the Install dialog box and click finish.
  • Once the search is
    finished, it will present with the features to install.
  • Select the features you
    want to install. In this case select SQL Explorer branch & click next.
  • Accept the license
    agreement & click next.
  • Select the install location
    where you want to install this plug-in. By default it will be installed
    into the eclipse plug-in directory. If you want to add another location
    click on the change location button on the lower right hand corner and
    specify the directory where you want to install. Once you are finished
    with the selections click on finish button.

Version Control?

I’ve been looking into if and how I ought to set some sort of version control up and if so what is my easiest method that will allow for growth? I found a good comparison of version control systems here, at smashing mag. But I don’t feel up to speed enough to fully evaluate the alternatives presented, or for that matter am I ready to undertake this complexity, now? I found a good intro to SVN at Peter Gecko Here. But even that article gave me pause, and I posted a similar question there.

I’m a lone and very basic developer with no current experience with version control systems. A friend recommended SVN but I’ve barely gotten my hands around Eclipse and Mysql. which are the current backbone of my development environment. I am using the Brit, Eclipse based, report writer against MySql databases.(I’m on windows, XP and vista with Freeware only) I’ve looked at the Svn documentation, but am very wary of adding that complexity into the environment I barely understand. I’d like to continue to set up an environment that can grow, (languages and tools) as I do. I only have so much bandwidth for learning!

What advice does this much smarter crowd have to offer???

Got Ganymede RC4 with Birt Running on Win xp sp3

As I thought might be the case my problems seem to have been due to massive user error. The key is that one must start a project before trying to set anything else up, and.. The BIRT package comes with its own version of data explorer that is not the same as the main Eclipse DTP. I sill have not gotten the data tools platform (DTP) working with My Mysql database. I did get a sample report going with MY mysql database. so that is a start. For help on this if you are as confused as I was, and to some extent still am see the screen shots from me and the from the great help from an Actuate master (BIRT developer). see the bug 236647 (in Bugzilla) for some useful info for the total newbie!

So a key that I don’t think is highlighted in Eclipse Docs is that you must have STARTED A PROJECT, before anything else works properly, makes sense since it uses the project workspace to store all environment info…

If any one has an idea how or where one should put the MYSQL driver into the Eclipse environment so that it will work with the DTP I’d appreciate it! Currently I just get the “can’t find it” message even though it is displayed in the Jar file tab…(and I did set up another project to test it)

I’m still drinking through a fire hose trying to learn Eclipse, MYSQL, and JAVA all at once,(along with BIRT and probably a few other items)

Installing Eclipse Ganymede on Win XP sp3

Eclipse looks to be a very powerful and well supported software development environment, with huge capability, if I can get it running!

Well…Since for the time being I bombed out on my Linux installation I thought I’d try the win Xp install. I chose the “Ganymede RC3” Report writer package. Every thing seemed to go very smoothly. Then I tried to get my My SQL database hooked up using the JDBC driver… At first I though I had it, the server pinged and indicated that it was connected.. But then I went to look for “data” the server it turns out should have shown up on the navigator with the various databases, so a “data source could be defined,,, These things never happened,. Left some messages on the Newsgroup. Got asked to file a bug report, I did, It’s Bug 236647 In Bugzilla. The first response has been that they tried it and everything works great… So again I’m at a dead end with even being able to get a fairly good starting point with Eclipse. What I don’t get is why it has such an extensive error log when I do a clean install.. It looks like ti is trying to install a bunch of other items not in the installed package,,, It makes getting useful error messages hard to distinguish from the noise.

It should not be this difficult to get a tool installed and working… I’ll even grant that it is probably “user error” but Still!!! Give me something to go on!!!

It’s pretty clear that I have to get this working but I’m not sure what’s next. I’ll have to give them a few days to see if Eclipse people can help me out. I have to get some real work done anyway!

When I get a chance I’ll update getting MYSQL going. I found a neat tool HeidiSQL looks to be much more complete and free than the mysql workbench.

Freeware, Free hosting and Web 2.0+

Updated 5/29/2008 to include links to services and my sample pages. I intend to keep updating the sample pages, so check in or subscribe!

Well I think I’m going to start to document my journey to the brave new software world. Wait! you say, its not new, and well you may be right! But it is new to me and from poking around in the process of learning it it seems that it is new to a lot of other people also.

I began by setting up a web site on Microsoft Live. Located at Http:// it hosts information about my Real Estate statistical consulting services. While Microsoft is not normally associated with great web stuff, this product is a wonderful exception. I got it when they were still handing out free domain registration, which sadly they have discontinued, now its something like $14.95 per year. The hosting however remains free. You can get a free subdomain (like and still get completely operational for free. Since, as some have pointed out, search is the most common way to find information now on the web I don’t think the lack of a full domain registration is the handicap it once was.

I also incorporated a Blog hosted here at wordpress, and incorporated into the main site via Iframes.

I’m now exploring Linux (Ubuntu), MySql, Eclipse, Open Office. I’ve got them loaded but I have a way to go to get fully operational. I’m Using a dual boot Dell Win XP pro Machine with the newest Ubuntu Hardy. I’ll pick up some of that next time. I’m striving to create a solid free software development replacement to my entire Windows experience. I need a replacement for MS Access and eventually Photoshop CS3, although If I could get that in Wine I’d probably be ok with it.

Other neat tools/ services I’ve picked up are: Many Items in Google such as my new favorite: Google “reader” the Shared items page, Base, Mail, Docs, adsense, to do lists, portfolio, finance and a bunch of others, something new almost every day.

Jott: great for keeping notes to myself when away from the desk. It is a voice recognition system which I set on my cellphone speed-dial and use to send e-mail reminders as well as to do items and calendar items.

Metadot: A free hosted Wiki that I just started to work on yesterday. My experimental site is here.; A great way to keep bookmarks organized so I can get to them via any computer and not use my browser which keeps them stuck on one machine.

In fact one of my main goals is to move as much as I can into the “cloud” so that depending on a particular machine and location is no longer necessary. So this means giving up on Microsoft Outlook. So far no problem.

One last item for today is getting Firefox instead of Explorer, It has been a great improvement. I happen to be in Explorer at the moment, for no particular reason but I find myself most of the time in Firefox, which seems noticeably faster and much less crash prone, when running exactly the same stuff! Update, Installed the rc1 of Mozilla 3.0 on Windows works great  and the pre release 3.xx version on Linux.