Nexjexpress/PostgreSQL Adapter

Project Goal

Develope an adapter to expose NexJ Express objects to PostgreSQL database

Current Status

• Learning about Differences between PostgreSQL and MySQL
• Walk through MySQL adapter.java code in NexJ Express code
• Going through NexJ MySQL database

Project Phases

Phase 1: Design Proposal

• Get requirements from NexJ (Meeting on Thursday Sep 23rd)
• Incorporate requirements from NexJ into Design of PostgreSQL adapter
• Prepare and send proposal for review, make changes as by NexJ until approved

Phase 2: Coding

Resources

• Persistence

1. Eclipse Tutorial Videos on Persistence
2. XML/Object Binding and Object Persistence = XStream + XBird (XML database system]
3. data persistence withJDO

• JDBC

1. JDBC @ http://en.wikipedia.org/wiki/JDBC
2. Relational database Management System @ http://en.wikipedia.org/wiki/Relational_database_management_system
3. JDBC Driver @ http://en.wikipedia.org/wiki/JDBC_driver
4. Drivers table http://devapp.sun.com/product/jdbc/drivers

• Postgre

Tutorial

postgre connection

• MySQL

Syntax

Tutorial

Mysql Connector

• Compare Databases

Compare SQL Implemenations

Compare Postgre and MySQL