Difference between revisions of "Research Findings - PostgreSQLAdapter"

From CDOT Wiki
Jump to: navigation, search
(Work of Grace Batumbya and Anastasia Semionova)
(Blogs of Grace Batumbya)
Line 1: Line 1:
  
 
== Blogs of Grace Batumbya ==
 
== 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/]
 
* 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/]
  

Revision as of 14:04, 8 July 2011

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