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

From CDOT Wiki
Jump to: navigation, search
(General Research)
(General Research)
Line 3: Line 3:
 
* Add UUID generation to x64 versions
 
* Add UUID generation to x64 versions
 
* Does <code>extract(epoch from value)</code> return milliseconds?
 
* 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?
+
* 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:08, 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