Difference between revisions of "Nexjexpress/PostgreSQL Adapter"

From CDOT Wiki
Jump to: navigation, search
(Current Status)
Line 14: Line 14:
  
 
===Phase 2: Coding ===
 
===Phase 2: Coding ===
 +
 +
 +
== Resources ==
 +
* JDBC
 +
# JDBC [http://en.wikipedia.org/wiki/JDBC]
 +
# Relational database Management System[http://en.wikipedia.org/wiki/Relational_database_management_system ]
 +
# JDBC Driver [http://en.wikipedia.org/wiki/JDBC_driver]
 +
# Drivers table http://devapp.sun.com/product/jdbc/drivers
 +
 +
 +
 +
* Postgre
 +
: [http://www.postgresql.org/docs/9.0/static/index.html Tutorial]
 +
: [http://www.postgresql.org/docs/7.1/static/jdbc-ext.html postgre connection]
 +
 +
* MySQL
 +
: [http://dev.mysql.com/doc/refman/5.1/en/sql-syntax.html Syntax]
 +
: [http://dev.mysql.com/doc/refman/5.0/en/tutorial.html Tutorial]
 +
: [http://www.mysql.com/downloads/connector/j/ Mysql Connector]
 +
*compare
 +
 +
: Compare SQL Implemenations[http://troels.arvin.dk/db/rdbms/ ]
 +
 +
: Compare Postgre and MySQL [http://www-css.fnal.gov/dsg/external/freeware/pgsql-vs-mysql.html]

Revision as of 10:48, 21 September 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

  • JDBC
  1. JDBC [1]
  2. Relational database Management System[2]
  3. JDBC Driver [3]
  4. Drivers table http://devapp.sun.com/product/jdbc/drivers


  • Postgre
Tutorial
postgre connection
  • MySQL
Syntax
Tutorial
Mysql Connector
  • compare
Compare SQL Implemenations[4]
Compare Postgre and MySQL [5]