sqlalchemy console allows you to connect to any of the databases supported by sqlalchemy and run an interactive database command line against it.
In order to light terrain, it is not enough just to cast self shadows. It is also important to light it according to sky/sun occlusion and bounced secondary light. Lumiscape allows you to compute a lightmap for use in interactive applications. The lightmap is rendered using a GPU accelerated variant of radiosity. However, it is still exceedingly slow for large terrain textures.
Pyasm generates runable x86 machine code and uses ctypes to execute it.
Pyglet is a fabulous opengl/windowing wrapper you can use to write applications in python. Gletools exposes advanced OpenGL functionality like GLSL, Framebuffers, Float textures etc. to programs using the opengl API of pyglet.