Difference between revisions of "Research Findings - PostgreSQLAdapter"

From CDOT Wiki
Jump to: navigation, search
(Work of Grace Batumbya and Anastasia Semionova)
 
(7 intermediate revisions by one other user not shown)
Line 1: Line 1:
 +
{{Admon/obsolete}}
 +
 +
== Blogs of Grace Batumbya ==
 +
* PostgreSQL Windows x64: Enabling UUID-OSSP.sql [http://gbatumbya.wordpress.com/2011/07/08/postgresql-windows-x64-enabling-uuid-ossp-sql/]
 +
* PostgreSQL - Compare bytea data to a Large Object on the server side [http://gbatumbya.wordpress.com/2011/06/08/postgresql-compare-bytea-data-to-a-large-object-on-server-side/]
  
 
== Work of Grace Batumbya and Anastasia Semionova ==
 
== Work of Grace Batumbya and Anastasia Semionova ==
 
+
* The timeout feature is implemented by the MySQL JDBC driver, but NOT by PostgreSQL.
* [[Default orderBy research 2/17/2011]]
+
* CLOB is supported by MySQL, but NOT by PostgreSQL.
 +
** problem solved with feedback from NexJ
 +
* The records are ordered by MySQL, but NOT by PostgreSQL.
 +
** problem solved with feedback from NexJ
 +
* [[Default orderBy research 2/17/2011]] (NULL values are organized differently by PostgreSQL.)
 
* [[Run_Junit_Tests_For_Non_Default_SQL_Adapter | Unit Testing for non Default SQL Adapter]]
 
* [[Run_Junit_Tests_For_Non_Default_SQL_Adapter | Unit Testing for non Default SQL Adapter]]
  
 
== Work of Grace Batumbya and Minoo Ziaei ==
 
== Work of Grace Batumbya and Minoo Ziaei ==
 +
 +
* [[PostgreSQL Adapter Project - Resources]]
 +
* Concept of Adapter [http://www.vogella.de/articles/DesignPatternAdapter/article.html]
 +
* FOSSLC [http://www.fosslc.org/drupal/category/community/databases/postgresql PostgreSQL]

Latest revision as of 21:46, 26 January 2014

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

Blogs of Grace Batumbya

  • PostgreSQL Windows x64: Enabling UUID-OSSP.sql [1]
  • PostgreSQL - Compare bytea data to a Large Object on the server side [2]

Work of Grace Batumbya and Anastasia Semionova

  • The timeout feature is implemented by the MySQL JDBC driver, but NOT by PostgreSQL.
  • CLOB is supported by MySQL, but NOT by PostgreSQL.
    • problem solved with feedback from NexJ
  • The records are ordered by MySQL, but NOT by PostgreSQL.
    • problem solved with feedback from NexJ
  • Default orderBy research 2/17/2011 (NULL values are organized differently by PostgreSQL.)
  • Unit Testing for non Default SQL Adapter

Work of Grace Batumbya and Minoo Ziaei