PostgreSQL Adapter Project - Code Review 1 Changes

From CDOT Wiki
Revision as of 10:08, 20 April 2011 by Gbatumbya (talk | contribs) (General Research)
Jump to: navigation, search

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