Difference between revisions of "PostgreSQL Adapter Project - Code Review 1 Changes"

From CDOT Wiki
Jump to: navigation, search
(Created page with '=General Research= =Classes= ==PostgreSQLAdapter== ==PostgreSQLSchemaManager== =Scripts= ==postgrecreate.sql== ==postgresetup.sql== ==postgredrop.sql==')
 
(General Research)
Line 1: Line 1:
 
=General Research=
 
=General Research=
 +
* Can postgreSQL be configured to have the where clause use case insensitive compare for string values? i.e. (<code>select 'Grace' = 'grace'</code> => should return true)
 +
* Add UUID generation to x64 versions
 +
* Does <code>extract(epoch from value)</code> return milliseconds?
 +
* What encoding (UTF-8 and/or UTF-16 )does PostgreSQL use for unicode? Can this be configured by column?
  
 
=Classes=
 
=Classes=

Revision as of 10:37, 20 April 2011

General Research

  • Can postgreSQL be configured to have the where clause use case insensitive compare for string values? i.e. (select 'Grace' = 'grace' => should return true)
  • Add UUID generation to x64 versions
  • Does extract(epoch from value) return milliseconds?
  • What encoding (UTF-8 and/or UTF-16 )does PostgreSQL use for unicode? Can this be configured by column?

Classes

PostgreSQLAdapter

PostgreSQLSchemaManager

Scripts

postgrecreate.sql

postgresetup.sql

postgredrop.sql