PostgreSQL Adapter

PostgreSQL Adapter for NexJ

Project Goal

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

Concept of Adapter [1]

FOSSLC PostgreSQL

Current Status

• 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. Setup Scripts
5. implementation of main.upgrade

Resources

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