PostgreSQL Adapter

PostgreSQL Adapter for NexJ

Project Goal

Develope an adapter to enable NexJ Express model to interact with PostgreSQL database

Current Status

Dec 2010
Walk through parts of code related to SQLadapter, SqlSchemaManger and setup scripts in NexJ Express code Going through NexJ MySQL database Learning about Differences between PostgreSQL and MySQL

Nov 2010
Walk through parts of code related to SQLadapter, SqlSchemaManger and setup scripts in NexJ Express code Going through NexJ MySQL database Learning about Differences between PostgreSQL and MySQL

Project Phases

Phase 1: Design Requirements

• Get requirements from NexJ (Meeting on Friday Nov 5th)
• Organize list of requirements and set the task list for each part needed to be done
• Create Test Environment

Phase 2: Coding

• List of Tasks

1. implementation of PostgreSQLAdapter.java
2. implementation of PostgreSQLAdapterTest.java
3. implementation of PostgreSQLSchemaManager.java
4. implementation of main.upgrade

Resources

• Intro

Concept of Adapter [1]

FOSSLC PostgreSQL

• Java
• Database & Persistence
• JDBC
• PostgreSQL Specifications
• MySQL Specifications
• Postgre - MySQL Compare