psqlODBC [LSARC/2008/371 FastTrack timeout 06/17/2008]

[Mark Carlson]

Template Version: @(#)sac_nextcase 1.66 04/17/08 SMI
This information is Copyright 2008 Sun Microsystems
1. Introduction
    1.1. Project/Component Working Name:
	 psqlODBC
    1.2. Name of Document Author/Supplier:
	 Author:  Geir Green
    1.3  Date of This Document:
	10 June, 2008
4. Technical Description


  1.3.1. Date this project was conceived:
         04/17/08

  1.4. Name of Major Document Customer(s)/Consumer(s):
  1.4.1. The PAC or CPT you expect to review your project:
         Database

  1.4.2. The ARC(s) you expect to review your project:
         LSARC

  1.4.3. The Director/VP who is "Sponsoring" this project:
         Mårten Mickos

  1.4.4. The name of your business unit:
         Database Group (DBG)

  1.5. Email Aliases:
     1.5.1. Responsible Manager:
            Masood Mortazavi <Masood.Mortazavi at sun.com>

     1.5.2. Responsible Engineer:
            Geir Green <geir.green at sun.com>

  1.5.4. Interest List:
      databases-discuss at sun.com
      postgresql-techteam at sun.com
      sun-postgres-pteam at sun.com

2. Project Summary
  2.1. Project Description:
       psqlODBC is the official PostgreSQL ODBC Driver.

  2.2. Risks and Assumptions:
       It is assumed that porting psqlODBC to Solaris may cause modifications
       of the psqlODBC code so that it will run properly on the Solaris 
       platform. The modifications (if any) are expected to be minor.

       The business risks associated with not providing psqlODBC for Solaris
       is considered high, as we would provide a less complete environment for
       PostgreSQL on Solaris as compared to what the open source community
       would expect.

3. Business Summary
  3.1. Problem Area:
       A customer who is writing software using ODBC to access a postgres
       database on a Solaris platform will need psqlODBC.

  3.2. Market/Requester:
       Applications using ODBC API to access a database - these applications
       can be ported to postgres database on a Solaris platform.

  3.6. How will you know when you are done?:
       When the psqlODBC(ODBC Driver) code together with unixODBC(ODBC Driver
       Manager) is integrated into the OpenSolaris SFW consolidation.

4. Technical Description:
   4.1. Details:
        psqlODBC is the official PostgreSQL ODBC Driver.

        The psqlODBC project is a PostgreSQL Community project that is a part
        of the pgFoundry.

        psqlODBC is released under the Library General Public License (LGPL).

   4.5. Interfaces:
        EXPORTED        STABILITY    NOTES
        ------------------------------------------------------------
        psqlodbcw       Uncommitted  (NEW) dynamic library


        IMPORTED        STABILITY    NOTES
        ------------------------------------------------------------
        libssl          Uncommitted  /usr/sfw/lib/ (http://www.openssl.org/)
        Kerberos        Uncommitted  /usr/lib/ (http://web.mit.edu/kerberos/)
        libpq           Volatile     LSARC/2008/004
        libpthread      Committed
        libodbcinst     Uncommitted  LSARC/2007/684
        libodbc         Uncommitted  LSARC/2007/684
        libc            Committed

        The 32 bit version of library psqlODBC is installed in:
           /usr/postgres/8.3/lib/psqlodbcw.so
        - and the 64 bit version in:
           /usr/postgres/8.3/lib/amd64/psqlodbcw.so

   4.6. Doc Impact:
        See: http://psqlodbc.projects.postgresql.org/

   4.9. I18N/L10N Impact:
        The psqlODBC can handle both ANSI and Unicode.

5. Reference Documents:
  http://psqlodbc.projects.postgresql.org/


6. Resources and Schedule
    6.4. Steering Committee requested information
   	6.4.1. Consolidation C-team Name:
		SFW
    6.5. ARC review type: FastTrack
    6.6. ARC Exposure: open