pitr.net

I’m about to start a new project: a transparent SQL proxy. Connect your PHP-app to this “fake” mysql server, which sits in between your app and postgresql server translating all mysql-specific queries to normal sql’92 compliant format.

Requirements:

• support backend connections to postgres
• emulate mysql behaviour to frontend
• in Release1, queries for ‘X-cart’ shopping cart software should be supported

I have a clear picture of this. Does anyone have more ideas to contribute? I’ll start designing in the next few days.

I am currently using “Graphviz” to visualize the design of a use case model within a wiki environment.

(Trac plugin: http://trac-hacks.org/wiki/GraphvizPlugin)

Consider this line:

pie->I->like->pie->yummy->I->yummy->like->I->pie->like->yummy->pie

Resulting in this picture:

Delicious!