Difference between revisions of "Nexjexpress/PostgreSQL Adapter"

From CDOT Wiki
Jump to: navigation, search
(Resources)
(Resources)
Line 17: Line 17:
  
 
== Resources ==
 
== Resources ==
 +
Some information on database & persistence -> [[User:Minooz/NexJ#Database_.2F_Persistence| My notes]]
 
* Persistence
 
* Persistence
 
# Eclipse Tutorial Videos on [http://eclipsetutorial.sourceforge.net/persistence.html Persistence]
 
# Eclipse Tutorial Videos on [http://eclipsetutorial.sourceforge.net/persistence.html Persistence]
Line 32: Line 33:
 
: [http://www.postgresql.org/docs/9.0/static/index.html Tutorial]
 
: [http://www.postgresql.org/docs/9.0/static/index.html Tutorial]
 
: [http://www.postgresql.org/docs/7.1/static/jdbc-ext.html postgre connection]
 
: [http://www.postgresql.org/docs/7.1/static/jdbc-ext.html postgre connection]
 +
: More info on -> [[User:Minooz/NexJ#PostgreSQL_and_MySQL | My notes on postgreSQL & MySQL]]
  
 
* MySQL
 
* MySQL

Revision as of 10:58, 10 November 2010

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

Some information on database & persistence -> My notes

  • Persistence
  1. Eclipse Tutorial Videos on Persistence
  2. XML/Object Binding and Object Persistence = XStream + XBird (XML database system]
  3. data persistence with JDO
  4. java world jdo
  • 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
More info on -> My notes on postgreSQL & MySQL
  • MySQL
Syntax
Tutorial
Mysql Connector
  • Compare Databases
Compare SQL Implemenations
Compare Postgre and MySQL