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]]
+
* Database & Persistence
−
* Persistence
+
:Introductory info on -> [[User:Minooz/NexJ#Database_.2F_Persistence| My notes]]
−
# Eclipse Tutorial Videos on [http://eclipsetutorial.sourceforge.net/persistence.html Persistence]
 
−
# [http://xstream.codehaus.org/persistence-tutorial.html XML/Object Binding] and [http://code.google.com/p/xbird/wiki/XmlObjectBinding Object Persistence] = [http://xstream.codehaus.org/index.html XStream] + [http://code.google.com/p/xbird/ XBird] (XML database system]
 
−
#  data persistence with [http://www.developer.com/xml/article.php/918111/Data-Persistence-and-Java-Data-Objects----JDO.htm JDO]
 
−
# java world [http://www.javaworld.com/javaworld/jw-03-2002/jw-0301-jdo.html jdo]
 
  
−
* JDBC
+
* Postgre & MySQL
−
# JDBC @ http://en.wikipedia.org/wiki/JDBC
+
: Introductory info and comparing the two databases on -> [[User:Minooz/NexJ#PostgreSQL_and_MySQL | My notes on postgreSQL & MySQL]]
−
# 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]
 
−
: More info on -> [[User:Minooz/NexJ#PostgreSQL_and_MySQL | My notes on postgreSQL & MySQL]]
 
−
 
 
−
* 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 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 12:54, 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

  • Database & Persistence
Introductory info on -> My notes
  • Postgre & MySQL
Introductory info and comparing the two databases on -> My notes on postgreSQL & MySQL
Retrieved from "https://wiki.cdot.senecapolytechnic.ca/w/index.php?title=Nexjexpress/PostgreSQL_Adapter&oldid=49407"