Difference between revisions of "Nexjexpress/PostgreSQL Adapter"

From CDOT Wiki
Jump to: navigation, search
(Resources)
 
(40 intermediate revisions by one other user not shown)
Line 1: Line 1:
 +
{{Admon/obsolete}}
 +
 +
<big><big> PostgreSQL Adapter for NexJ </big></big>
 +
 +
 
== Project Goal==
 
== Project Goal==
Develope an adapter to expose NexJ Express objects to PostgreSQL database
+
Develope an adapter to enable NexJ Express model to interact with PostgreSQL database
  
 
== Current Status==
 
== Current Status==
 +
* Walk through parts of code related to SQLadapter, SqlSchemaManger and setup scripts in NexJ Express code
 +
* Going through NexJ MySQL database
 
* Learning about Differences between PostgreSQL and MySQL
 
* Learning about Differences between PostgreSQL and MySQL
* Walk through MySQL adapter.java code in NexJ Express code
 
* Going through NexJ MySQL database
 
  
 
==Project Phases==
 
==Project Phases==
=== Phase 1: Design Proposal ===
+
=== Phase 1: Design Requirements ===
* Get requirements from NexJ (Meeting on Thursday Sep 23rd)
+
* Get requirements from NexJ (Meeting on Friday Nov 5th)
* Incorporate requirements from NexJ into Design of PostgreSQL adapter
+
* Organize list of requirements and set the task list for each part needed to be done
* Prepare and send proposal for review, make changes as by NexJ until approved
 
  
 
===Phase 2: Coding ===
 
===Phase 2: Coding ===
 
+
* '''List of Tasks'''
 +
# implementation of [[ PostgreSQL_Adapter-nexj/Adapter | PostgreSQLAdapter.java ]]
 +
# implementation of [[ PostgreSQL_Adapter-nexj/AdapterTest | PostgreSQLAdapterTest.java ]]
 +
# implementation of [[ PostgreSQL_Adapter-nexj/SchemaManger | PostgreSQLSchemaManager.java ]]
 +
# Setup [[ PostgreSQL_Adapter-nexj/Script | Scripts ]]
 +
# implementation of  [[ PostgreSQL_Adapter-nexj/Upgrade | main.upgrade ]]
  
 
== Resources ==
 
== Resources ==
* Persistence
+
Concept of Adapter [http://www.vogella.de/articles/DesignPatternAdapter/article.html]
# [http://code.google.com/p/xbird/wiki/XmlObjectBinding Data Persistence] along using [http://xstream.codehaus.org/persistence-tutorial.html XStream Persistence]
+
* [[PostgreSQL_Adapter-nexj/Resources#Java | Java ]]
 
+
* [[PostgreSQL_Adapter-nexj/Resources#Database_.26_Persistence | Database & Persistence]]
* JDBC
+
* [[PostgreSQL_Adapter-nexj/Resources#JDBC | JDBC]]
# JDBC @ http://en.wikipedia.org/wiki/JDBC
+
* [[PostgreSQL_Adapter-nexj/Resources#PostgreSQL_-_MySQL_Specifications | Postgre - MySQL Specifications]]
# Relational database Management System @ http://en.wikipedia.org/wiki/Relational_database_management_system
+
* [[PostgreSQL_Adapter-nexj/Resources#PostgreSQL_-_MySQL_Compare | Postgre - MySQL Compare]]
# 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 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]
 

Latest revision as of 20:52, 26 January 2014

Important.png
This page may be obsolete.
It contains historical information.

PostgreSQL Adapter for NexJ


Project Goal

Develope an adapter to enable NexJ Express model to interact with PostgreSQL database

Current Status

  • Walk through parts of code related to SQLadapter, SqlSchemaManger and setup scripts in NexJ Express code
  • Going through NexJ MySQL database
  • Learning about Differences between PostgreSQL and MySQL

Project Phases

Phase 1: Design Requirements

  • Get requirements from NexJ (Meeting on Friday Nov 5th)
  • Organize list of requirements and set the task list for each part needed to be done

Phase 2: Coding

  • List of Tasks
  1. implementation of PostgreSQLAdapter.java
  2. implementation of PostgreSQLAdapterTest.java
  3. implementation of PostgreSQLSchemaManager.java
  4. Setup Scripts
  5. implementation of main.upgrade

Resources

Concept of Adapter [1]