Difference between revisions of "Nexjexpress/PostgreSQL Adapter"

From CDOT Wiki
Jump to: navigation, search
(Resources)
(Resources)
Line 22: Line 22:
 
# 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
 
  
 
* Postgre
 
* Postgre
Line 32: Line 31:
 
: [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 Databases
 
* Compare Databases
 
: Compare [http://troels.arvin.dk/db/rdbms/ SQL Implemenations]
 
: 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]
 
: Compare  [http://www-css.fnal.gov/dsg/external/freeware/pgsql-vs-mysql.html Postgre and MySQL]

Revision as of 09: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