The San Francisco Bay Area PostgreSQL March Meeting

Jon Asher presents: PostORM

PostORM is a simple ORM code generator designed for Postgres
developers. The first version outputs C# code but is easily adapted
to other programming languages such as Java or PHP. The system
consists of a Windows application that generates Postgres schema
information and a set of templates (that require CodeSmith software to
execute in this release).

Its main purpose is to facilitate the movement of data between objects
and a Postgres database. On the server side, PostORM generates a set
of Postgres functions to support single table insert, update, and
delete operations. For the target language, it outputs (a) method
wrappers for Postgres functions, (b) OOP classes for all db tables,
and (c) numerous class-based helper methods for populating objects
with data.

Compared to full-scale ORM solutions, PostORM has no dyanamic SQL
generation (think Rails ActiveRecord), no metadata or table to object
mapping, and no query language such as HQL. Nonetheless, PostORM
automates coding of the data access layer and significantly reduces
development time without asking developers to add another complex tier
to their solution architecture.

In this presentation, we'll go over the basic features of PostORM code
generation, review sample code, and run a number of demos that show
how the system works.

RSVP to get fed!