Difference between revisions of "Nexjexpress/PostgreSQL Adapter"

From CDOT Wiki
Jump to: navigation, search
(Resources)
Line 18: Line 18:
 
== Resources ==
 
== Resources ==
 
* JDBC
 
* JDBC
# JDBC [http://en.wikipedia.org/wiki/JDBC]
+
# JDBC @ http://en.wikipedia.org/wiki/JDBC
# Relational database Management System[http://en.wikipedia.org/wiki/Relational_database_management_system ]
+
# Relational database Management System @ http://en.wikipedia.org/wiki/Relational_database_management_system  
# JDBC Driver [http://en.wikipedia.org/wiki/JDBC_driver]
+
# JDBC Driver @ http://en.wikipedia.org/wiki/JDBC_driver
 
# Drivers table http://devapp.sun.com/product/jdbc/drivers
 
# Drivers table http://devapp.sun.com/product/jdbc/drivers
 
  
  
Line 33: Line 32:
 
: [http://dev.mysql.com/doc/refman/5.0/en/tutorial.html Tutorial]
 
: [http://dev.mysql.com/doc/refman/5.0/en/tutorial.html Tutorial]
 
: [http://www.mysql.com/downloads/connector/j/ Mysql Connector]
 
: [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]
+
* Compare Databases
 +
: Compare [http://troels.arvin.dk/db/rdbms/ SQL Implemenations]
 +
: Compare  [http://www-css.fnal.gov/dsg/external/freeware/pgsql-vs-mysql.html Postgre and MySQL]

Revision as of 10:51, 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 @ 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