Friday, October 29, 2004

SQL Cheat Sheet

GH Cheat Sheet: "SQL Cheat Sheet" with links to simple sql explanation. Handy for reference ;)

Tuesday, October 26, 2004

PostgreSQL module for Python

PostgreSQL module for Python: "PyGreSQL is a python module that interfaces to a PostgreSQL database. It embeds the PostgreSQL query library to allow easy use of the powerful PostgreSQL features from a Python script.

PyGreSQL 2.0 was developed and tested on a NetBSD 1.3_BETa system. It is based on the PyGres95 code written by Pascal ANDRE, I changed the version to 2.0 and updated the code for Python 1.5 and PostgreSQL 6.4.2. While I was at it I upgraded the code to use full ANSI style prototypes and changed the order of arguments to connect. Version 2.1 is fixes and enhancements to that. The current version works with PostgreSQL 7.3 and up."

PostgreSQL FAQ

PostgreSQL FAQ: "1.10) How can I learn SQL?

The PostgreSQL book at teaches SQL. There is another PostgreSQL book at There is a nice tutorial at, at, and at

Another one is 'Teach Yourself SQL in 21 Days, Second Edition' at

Many of our users like The Practical SQL Handbook, Bowman, Judith S., et al., Addison-Wesley. Others like The Complete Reference SQL, Groff et al., McGraw-Hill."

Monday, October 25, 2004 - Wiki Farm - Wiki Farm
Welcome to the Wiki Farm - a place where anyone can create a Wiki of their own to do with as they please. Each Wiki is run using the MoinMoin Wiki software, and our own Wiki farm extensions.

Python Modules

Python Modules: "Improved autosuper 0.9.1

An improved (read slightly faster, documented, with tests) version of my improved autosuper Python Cookbook recipe. Includes a Pyrex implementation that is about twice the speed of the pure Python version.

License: BSD-style."

Saturday, October 23, 2004

paramiko: ssh2 protocol for python

paramiko: ssh2 protocol for python: "Paramiko is a module for python 2.3 (though python 2.2 is also supported) that implements the SSH2 protocol for secure (encrypted and authenticated) connections to remote machines. unlike SSL (aka TLS), SSH2 protocol does not require heirarchical certificates signed by a powerful central authority. you may know SSH2 as the protocol that replaced telnet and rsh for secure access to remote shells, but the protocol also includes the ability to open arbitrary channels to remote services across the encrypted tunnel (this is how sftp works, for example)."

Monday, October 18, 2004

PYthon Remote Objects - misschen sneller als xml-rpc?

Pyro is short for PYthon Remote Objects. It is an advanced and powerful Distributed Object Technology system written entirely in Python, that is designed to be very easy to use. Never worry about writing network communication code again, when using Pyro you just write your Python objects like you would normally. With only a few lines of extra code, Pyro takes care of the network communication between your objects once you split them over different machines on the network. All the gory socket programming details are taken care of, you just call a method on a remote object as if it were a local object!

Pyro provides an object-oriented form of RPC. You can use Pyro within a single system but also use it for IPC. For those that are familiar with Java, Pyro resembles Java's Remote Method Invocation (RMI). It is less similar to CORBA - which is a system- and language independent Distributed Object Technology and has much more to offer than Pyro or RMI. But Pyro is small, simple and free!

Python Dispatch Package

Python Dispatch Package: "PyDispatcher provides the Python programmer with a multiple-producer-multiple-consumer signal-registration and routing infrastructure for use in multiple contexts. The mechanism of PyDispatcher started life as a highly rated recipe in the Python Cookbook. The SourceForge project aims to include various enhancements to the recipe developed during use in various applications."
Aka pydispatch

Wednesday, October 13, 2004

Open Source Development Tutorials

Open Source Development Tutorials: "Open Source Development Tutorials"

OGo Docs - Umlauts in Python XML-RPC Scripts

OGo Docs - Umlauts in Python XML-RPC Scripts: "Umlauts in Python XML-RPC Scripts
Python needs to be tweaked to allow Umlauts ...

Submitted in XML-RPC List by Dr. Martin Korff, thanks!

For those who read the previous mails on this topic, here the summary - which worked for me . Goal: reading, changing, and updating of persons and enterprise involving non-ascii (latin-1) data using python and the

1. Python site configuration: In /usr/lib/python2.3/ change encoding = 'ascii' to encoding = 'utf-8'
2. The relevant lines from the top level script are the following: #!/usr/bin/env python # -- coding: utf-8 --
3. Any new string to be assigned, edited in a iso-8859-1 encoding editor should be declared as python-unicode-string, e.g.

newattrvalue = u'newvaluewithaccents'

Finally it should be mentioned that a custom is needed not only for python2.2 but also for python2.3 since HTTP-Authentication still hasn't made it into the standard library."

Myghty - High Performance Python Templating

Myghty - High Performance Python Templating: "Myghty is an all-new, Python based content-delivery and template system derived from HTML::Mason, an enterprise-quality web development system written for a Perl environment, the templating choice of and among many others."

Monday, October 11, 2004


burger@overheid onder andere kun je hier ook klagen over mailtjes die niet beantwoord worden e.d.

Sunday, October 10, 2004

.: :.

.: :.: "JavaScript o lait
It's more than just a JavaScript library.


The goal is to ease JavaScript development by building a library of reusable modules and components and enhancing JavaScript with simpler Class and Module handling mechanisms."

you will love this!! - nice string formatting etc, but more: using xml-rpc from within BOTH I.E. and Mozilla!!!

Friday, October 08, 2004

XML-RPC Message Builder

XML-RPC Message Builder: "The download is avaliable as a ZIP file (9K) which contains:

* index.html - this about page.
* xmlrpc.js - the XML-RPC message builder script
* xmlrpc-socket.php - the PHP proxy
* http_post.util - the modifed version of http_post needed by xmlrpc-socket.
* all three demo pages

You'll also need to grab a copy of the JavaScript Remote Scripting library from"

Remote Scripting - Ashley IT

Remote Scripting - Ashley IT: "Javascript Remote Scripting (JSRS) is a client-side javascript library which uses Dynamic HTML elements to make hidden remote procedure calls to the server. It only works asynchronously, but is known to work on Win9x, WinNT/2000, WinXP, Unix/Linux/BSD, and Mac with IE4 , NS4.x, NS6.x, Mozilla, Opera7 and Galeon. There are server-side implementations for ASP, ColdFusion, PerlCGI, PHP,Python, and JSP(servlet). JSRS is in production use on intranet and public sites in Canada, the US, South America, Australia, Europe, and the Middle East. JSRS is free of charge and its source is open and freely available."

.: :. | jsolait.xmlrpc

.: :. | jsolait.xmlrpc: "try{
var server = new xmlrpc.ServerProxy('', ['echo']);
txResult.value = server.echo('');

Wednesday, October 06, 2004 : en/Projects/PyTextile/more_textile : en/Projects/PyTextile/more_textile: "PyTextile

A Python port of Textile, Dean Allen's Human Web Text Generator. Textile simplifies the work of creating (X)HTML."


PyOpenOffice: "What can PyOpenOffice do for you?

* Make serial letters and reports from templates in the SXW-Format and store them anew as SXW-Files
* Replace pictures - generate catalogues, worksheets, photo galleries etc. from an SXW-Template.
* Extract the pure text information from the SXW-Document and store it in a plain text file or a PDF-File
* Perform simple transformations from SXW-Files to PDF-Files without installing OO - for example on a webserver"